Sorry... BE = Back End or ur database and FE = Front End or ur application so basically u want to add a new record and assign a value to ur date field using VBA?
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of kingfisher2xx4 Sent: Tuesday, October 03, 2006 4:22 PM To: [email protected] Subject: [ms_access] Re: Using VB in Access I am using Access, and I guess I need to go to acromyn school because I have no idea what you are using BE and FE to refer to. --- In [email protected], "George Oro" <[EMAIL PROTECTED]> wrote: > > r u talking about using VBA or Access just BE and VB is ur FE? > > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On > 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 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/
