Search results for query: *

Thanks, RickSpr. That's actually what I did. The requery portion will help, though.

I'd like to be able to change the table source of a combo box based on a value entered in another combo box on the same form. I'll call the main combo box Category and the dependent combo box SubCategory. I need to call a different SubCategory list based on the Category I choose. What would...

Thank you Roy. This is precisely what I want to do. Apparently someone else has wanted to do so as well. Several someone elses I suppose.

Good. I wouldn't have figured that out.

Thanks for your input. How can such a simple idea be so compicated to bring to fruition? I simply cannot get some of my users to exit a database after they finish using it - and the computer it is used on is shared by several of our production employees. So if someone leaves the database...

If you give me more details on what you'd like to do, I may be able to help you...

Hmmm...well, the inactivity would only apply to Access. They may be fondling other applications and such, so your first suggestion appeals to me a bit more. I would appreciate any insight into the matter...

Does anyone know how I might close a database front end after, say, 5 minutes of inactivity?

Alternate method works like a charm. You've been swell...thanks again.

qryRestOfRecords was either showing all records, or none (if using Is Null). I'll try your alternate method - thanks for your patience.

Right - I've created qryTopFour and qryAll. Then I created a new query in Design View and added qryTopFour and qryAll to it as the data sources. I linked two fields (Manifest#) and set join properties to show all from qryAll, added all fields from qryAll and one from qryTopFour and set it's...

I've tried exactly what you said, and cannot get it to work. When I add a field to qryRestofRecords from qryTopFour and set the criteria to Is Null, I get no records. If I don't add any fields from qryTopFour, but all fields from qryAll, I get all records (with relationship between two fields...

Duane, You said I'm having a problem making this work. I'm know how to edit join properties, but I'm not sure which data from qryTopFour to include in qryRestofRecords (which would consist of the same datasource tables used to make qryTopFour?). Does it matter what field from qryTopFour I set...

Okay - got the top 4 working. Now, I'm thinking I need to make another report for the template for continuation pages, which have room for 9 records per page. This report would need it's own query. How do I make this report show all records but the top 4? And can I limit it to 9 records per...

Sounds like a good idea - how do I limit the top four records in my query?

I have to create a report that will serve as a template to print shipping manifests. Manifests can be multiple pages long based on the number of line items needing to be manifested. In my instance, manifest information is pulled from a query based on tblManifests and tblManifestItems. Here's...

Thanks again, Ken. You've been a great help. I've got another post in the VBA section if you're interested.

I think I've been doing things the hard way. To reduce the chance of users typing over information accidentally, I've made three versions of the same form. One has all controls unlocked with data entry set to yes (New records), one has all controls set to locked (view only), and one is set...

My apologies - I had one more question. How do I make the label controls in a related subform change colors as well?

Excellent. I appreciate all of your help. I have but one more question. How do I use other colors? For example, the color I want to use is 4227072 in the BackColor property window of a label. Can I set the color with lbl.BackColor=4227072?