Recent content by MBruns

Help? Did you ever find the answer to this. I'm having the same problem. For me, it's occurring on one computer in a networked environment. Several computers use the same database and it's worked fine for ages. The color problem occurred for me when we got some new, used computers. The...

I have a search form that I built for a contacts db which allows searching based on the user choosing which field to search, a boolean term and the data. Users can string together up to 3 fields connected by and/or. The whole thing works great for text and I was/am delighted with its' use in...

Here's my answer So here's the answer I found. Yes, it's true that subforms have the same properties, I just couldn't get the syntax to refer to them right. Here's an example: Forms!frmInputMainbyEntry.Form!FrmSubInputDetail.Form.AllowDeletions = False This does the trick.

Am I missing something When I click on the subform I get two sets of things. Single click I get onEnter and OnExit events. Click again, I get a list like a regular form. However when I try to refer to the subforms' "AllowDeletions/Additions" properties I get an error message saying the...

Is there a way to do this just for the subform I know I can do it on the main form properties, but what about the subform....Thanks

I've got a subform that I want to keep people from editing while allowing them to view all the data that's on there. Based on who they are and whether they should be able to edit or not I lock them out of editing the main form and various controls on the subform. I have code that theoretically...

I have several reports created in an Access database that are set to use the default printer which for most people is a duplex printer. Our accounting person has her own printer which is non-duplex. When she tries to print multipage reports, the printer stops with each page and she must hit...

"You or another user may have unexpectedly quit Microsoft Office Access while a Microsoft Office Access database was open." I get this error message after a user has closed an Access 2003 database with the x rather than through my forms. This part follows the message about the database being...