Recent content by mba1942

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 have a generic log-in form that I want to use to to grant access to a number of desired 'edit data' events which are called via 'buttons' from a master form. Some of the MasterForm event buttons do not require password access and some do. Due to the nature of the app, the password is hard...

I can manually delete a record with no problems. Note: Using Access 2010. Thank you... MBA

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...

Note: I found the problem... For some reason, the report mentioned had the "Use Specific Printer" option (radio button) selected. I found it in the REPORT DESIGN TOOLS super-tab > "Page Setup" Tab > "Page" sub-tab. Therein you can select either the "Default Printer" or "Use Specific Printer"...

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...

Thank you so much for your response! I have taken over this program from others and the transition from 'old' to 'new' will take a little time. Thus I am keeping some of the old with the new for now. In reality, the BranchNo and DistrictNo fields are, in themselves, Combo Box fields which in...

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...

It works! Thank you so much for your help! Note: Without success, I had tried something similar to your suggestion using Iif(Volunteer,"Volunteer", "Member") assuming a true/false test on the binary 'Volunteer" field. Your direction did the trick! MBA

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...

Thank you Paul, Just the information I needed to complete the task! I appreciate your quick reply! MBA

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...

Thanks so much for your quick response! I may not understand completely your response... Sorry for being so obtuse! To explain further, the client is simply adding his contact data to fields in a sign-in form. [Which is uniquely identified by the auto-numbered 'VisitID" field]. Once he has...