I have a routine that works great for printing a filtered report. There is a form where you select the group you want, and press the print button. That executes a 'Select Case' routine and, depending on which case, executes a line similar to:
DoCmd.OpenReport stRptName, acViewNormal, ...
We have developed a form (not a report) which has personal information on it and a sub-form which then shows all the training this person has had.
When we put a print button on the form with code to print the form, the sub-form is dropped off. The VBA coding is simple:
Private Sub Print_Click()...
I have a field in my database that I restrict via a dropdown list. Now I need to add a second field that will restrict what is entered via a dropdown - the contents of which is controlled by the first dropdown list.
[COLOR=blue]i.e. I select class category of 'Safety' from dropdown #1, then...
Our company has recently upgraded from Office 2000 to 2003, as well as upgrading from Windows 2000 to XP. Prior to the upgrade, we could take approximately 200 records from Access and import them into Outlook in about 60 seconds. Since the upgrade this same action takes over 2 hours...
Hello All,
I am back again with what I hope is a simple question to which I can’t find the answer.
We have a database with multiple tables. Table-1 contains the employee name and employee ID number. Table-2 contains a list of equipment assigned to the employee. Both tables have the field...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.