Search results

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

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

I realize this is an older thread, but its the only one I can find with a similar conversation to my question... i am trying to use dropbox as a way to share a documents folder which will store documents that are linked to a filepath stored in my access table. I have done this before using a...

What I would like to do is create an event like Private Sub Form_Load() Me.Form.AutoResize = False Me.Detail.AutoHeight = False Me.Detail.Height = 700 End Sub But nothing works... so frustrating. I have a detail section (single form) that should only be about .5" tall. In the footer I have a...

Hello- I've been working on this off and on, i changed to overlapping forms, dragged the boarder smaller, etc, save, and still the same result. Ultimately I will want to have tabbed document, does your solution only work in overlapping? Thanks...

which version of Access are you using? I see no obvious way of selecting the form edge to drag it smaller in design view... ? I am using 2010.