Does anyone have a access database that has most elements including VBA that a person could use to learn from? I've always had trouble taking from a book (of which I have 8 of them about Access) and putting it into action. I've always had better luck learning from "hands on" activities. What I've learned about Access so far I have learned in this fashion either from the databases that come with Access or snippets from people posting on this group. I'm now in need of learning the deeper things of VBA like my current problem which is I want to be able to use a check box on the main form (PO form) and recieve everything using a filter to open the reciever form and then have everything equal what was ordered for a quick recieve. I have a command button on the PO that I can open the reciever and then recieve line by line however this would be a great time saver when there are 20 or 30 items to recieve. I can get the form to open and for it to recieve the first row/item in the list and understand I need to loop through all of the filtered records but that's where I fail. I would assume that I need to open a recordset and then loop through that applying the same line of VBA to each record and then close the recordset but I'm lost in how to open the recordset. I've looked through Microsoft help and have downloaded the Help files to my computer but most are to general and do not apply to what I'm trying to do. Is there a site somewhere that would explain VBA with examples? I don't mind paying for access to a site but want to make sure I do not waste my money. Any suggestions?
------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
