Search results

I have a generic log-in form object that I want to use to to grant access to a number of desired 'edit data' events which are called via 'buttons' from a MasterForm object. Some of the MasterForm event buttons do not require password access and some do. Due to the nature of the app, the...

I am attempting to archive and delete records from a timelog table using selected start [Startdate] and end date [EndDate] paramaters which are fields contained in a separate [StartEndDate] table. I have created both an archive query and a delete query. The Archive query works fine but when I...

I have just upgraded to 2010 from 2007 and have opened my 2007 application in 2010. In the original msAccess 2007 program, after filling out information on a form, I have a triggered DoCmd: DoCmd.OpenReport "rptIntakePrintedForm", acViewNormal, , "VisitID = " & Me.VisitID In Access 2007...

I have a [Visits] form where our clients can log in their visit when they come into our office. Our clients are assigned to a Branch which is assigned to a parent District. There are many Branches in a District and many Districts. At times our clients remember their Branch number...

I have a form thatour service volunteers can use to log their service hours. Entries are usualy made weekly and management uses the data to report monthly. I provide a "View Log" button so, as the month progresses, our volunteers can view the log entries and confirm they have entered all their...

I have a simple 'Client Hours' table that has a binary field (Yes/No) called 'volunteer'. It indicates if the client is a 'volunteer' or a 'member'. If a volunteer, the Yes/No field is checked. The reported hours are summed each month by Volunteer and by Member. The 'Volunteer' report group...

I am new to much of the form field focus functionality... On a time reporting form, the user must enter a NAME selected from a dropdown (combo) list. The focus is set to this (NAME) field on form entry. If the field is left blank, OnExit, a MsgBox shows "You Must Enter a Name." Under this...

I am working to create a time-keeping report form. I am using a contact table to create a combo box list which contains the contact names (text-type) and their contact ID (Interger-type). I allow the user to enter the time-keeping form, find his/her name from the combo box and then enter...

Access 2007: I have a form which our clients can to sign in when they come to visit... It contains basic information which is captured and printed on a worksheet for our service representatives to use to assist the client. Table Name: Visits (current number of records: 10,000+) Key Field...

I've had some experience in msAccess 2003 but am returning after a few years leave for service work in Russia. Am currently using msAccess 2007. I am presently involved in trying to learn how to print a report using a single record ID. The report would be called based on testing an entered...