Recent content by ma t

Thank you Pat, i will research how to use a querydef. I am using the query/subquery because my users fine it helpful to be able to see a simple list of results with the subdatasheet not expanded, but easily expandable if they want to see the detail. I used to spend hours formatting reports and...

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

Thank you PBaldy, i might need more than basics :( do dteStartDate and dtrEndDate refer to my search fields in the form, or the fields in my enrollment info table? I am sorry for my lack of understanding. Thank you for trying to help me!

I know this message is very old, but can PBaldy give a bit more clarification for us novices? I have a student class enrollment table with start and end dates for the time period the student is enrolled in a certain class... i have a form by which the user can find all students who were...

I tried that, but then the first section cat.Views.Append "qrySelectTotal", cmd line gets a yellow highlight with an error. Thank you,

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

Thank you to everyone who contributed to this solution, it was exactly what I needed!:)

Yes, I have tried that and similar other things. Thank you,

Actually, I am just using the report as a UI "container" for the subforms which have the date field controls. The report and subforms are unbound. The onclick event of the code just opens a query in datasheet view. I hope that makes sense. I appreciate the help!

Re: help with type mismatch (date field) Just in case it helps, I have more going on in this report. I found some code by Martin Green that uses multiselect list boxes to filter a dynamic query, and it seems to be working great. I just need to get the date part to work and then I think I will...

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

ok- i may have stumbled on something. I compared the references in the sample to my current project and there was another one missing. I created a reference to the MS active x 2.1 and it now works!

By the looks of it, it's WAY over my head. I was hoping this would be simple. Hah!

Hello Dale, I am using 2010. The code window opens and i get a message that says "user defined type not defined" and the line of code i mentioned above is highlighted. I am very novice at VBA but I hope to learn more.

The sample code says this: ' This code uses ADO and ADOX and is suitable for Access 2000 (and later). ' A reference must be set to Microsoft ADO Ext. 2.7 for DDL and Security. I can't find 2.7 so i created a reference to 2.8. The line that seems to be the offender is: Dim cmd As New ADODB.Command