Search results for query: *

tsaawer and dhookuom, Thank you both for the responses, but after about 10 plus hours I figured it out. It may not be the most efficient way to do it, but it works - and if it ain't broke don't mess with it. Again, Thanks to both of you. Harry J.

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

Thanks Duane, But if you can print a form, why not the sub-form with it? Michael1947 "There are 10 kind of people in the world. Those who understand binary, and those who don't

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

RobertT687 Now I feel stupid !!! Know how 'they' say the simple things cause the biggest problem? Well, if I had selected table/Query as the Row Source Type, then I would of had this running two days ago. I am not sure how I missed that, but the problem is solved and the ComboBoxes are...

RobertT687 First, I want to thank you for your response and apologize for the delay in responding. Spring colds can cause things like that to happen. Anyway, I can't get it to work. Here is more detailed information: Table structure: ID (Key, auto number. Not used) Category (text...

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

Leslie, Table-1 contains the basic employee information. Table-2 contains the EMPID and a list of all equipment that could be issued to the employee. What is missing from Table-2 is the serial number of the item, or a 'True/False' to indicate if an item were issued. Therefore only one...

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