r u talking about using VBA or Access just BE and VB is ur FE?
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of kingfisher2xx4 Sent: Tuesday, October 03, 2006 3:47 PM To: [email protected] Subject: [ms_access] Using VB in Access I have used access (v. 2003) for a number of years an have used structured progamming on a regular basis. I am somewhat familiar with programming objects. I am venturing into using VB in Access. I am having some trouble getting started. I have a table with a single date field that I want to add records to and assign a value to that record. A form with a button initates the process and I want to use a for next loop to append a blank record and assign a date value to the new record in the table. How do I execute the query from the VB procedure, the DoCmd or do I reference it as an AccessObject? Thanks for your help! Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
