Search results

Hello all, I am not sure if this is possible or not, I am opening a query from a docmd.openquery action in a button... however, I would like to set the name of a sub query in VBA so that I can have one "main" query open with different sub queries. My main query is a "member roster" with basic...

Hello, I am not sure how to accomplish my goal- I have some code that creates queries based on a value in a checkbox. So, depending on that value, the queries may or may not exist. I need to take those queries (if the exist) and create one union query. This code (cobbled together from bits and...

Hello all, I am trying to refer to two unbound controls ("begin date" and "end date" on a report that holds a short date value, and use those values to filter a query with a date field. I am a VBA novice but I learn a little bit every day. I am using 2010. I found this code here to save the...

Hello all, I found a sample db on Martin Green's http://fontstuff.com/access/acctut18.htm It works in his sample mdb but when I try to import the form into my current project it blows up. I think it has to do with the ADO reference. Is there a way to get around this? I like how the form works...

Hello, I have tried to figure this out and I am just not getting it...:banghead: I am trying to create an "onclick" event for a control in a "navigation menu" style subform that will change the source object in another subform control on the same main form. (similar to the new "navigation form"...

Hello all, i am going in circles, again, I would appreciate any help I can get. I have a query with the fields Adult Last and Adult First from the "Adult Info" table. I have a form based on the query. I have been able to create lookups in the last and first fields to determine if the person...

I have a question, if it's not to late, is it possible to have a form that has too many controls, or pages? I seem to keep hitting the same brick wall. When designing a form that I hope to have linked to about 15 tables, i get to a point where the form stops allowing data entry, (when i get so...