what are the conditions when updating the records? could u explain further pls...
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of kingfisher2xx4 Sent: Tuesday, October 03, 2006 4:49 PM To: [email protected] Subject: [ms_access] Re: Using VB in Access Thanks for the explanation. Access is my FE and BE to create a simple time recording application. Yes, I am adding a range of dates to the table. Using For..Next to create the range. To fill out any missing dates in a report. Use DoCmd.OpenQuery to execute an append query to add a blank record but having difficulty with the reference to assign the value. --- In [email protected], "George Oro" <[EMAIL PROTECTED]> wrote: > > 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] On > 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" <george@> 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 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/
