Search results

Awesome. Thanks Paul. I will take a look at these and see what I can come up with.

So I was able to get it to work. I created a query to populate my report instead of just using the table after realizing/remembering my table was linked to another. Below is what ended up working. Now I need to build it into a form that lets you select the save location and if you want to...

@pbaldy I fixed the location of the where statement and no luck. Now I'm getting a data type mismatch on that same line.

I have a database that has one table with almost all of my data (it's imported from SharePoint). I am trying to export each record as a single PDF but am having some issues. I found the below code on this site but can't seem to get it to work. Every time I run it, it gives me a PDF names with...

It's not 4 different reports. I guess it is more like a dynamic report that is created with the criteria (the combo boxes) you select. The goal is for the user to select a general picture of the data or drill down to something more specific by select more than just the top level (most broad...

Sorry. The report is generated from a form that has 4 combo boxes. I want the user to be able to select one or all 4 to generate a report. So if it works they should be able to look at all records in a community, records in a community within a boro, records in a community within a boro that...

Ok I have looked all over the forum for this but can't find a good answer. I have seen mention of a UNION query but not sure how and if that would work here. I have a from with multiple combo boxes to select criteria for a report. The below SQL statement works great but for records that have...

missingliq - yes, minor typos. and of course the subform is named something totally different. was using that simply to try and get my idea across. like i mentioned i tried both options (.visible and .enabled) independently without what i thought the correct result should be. when .visible...

Ok that makes sense. When you select nothing in either combo box you get similar errors. My goal is to prevent the record add if there is nothing in both combo boxes. In other words something must be selected in each before you add. The code catches the first box but not the second. And...

Can you do the same thing with a sub form? Like hide a sub form until someone selects something from the combo box. I tried it as described above and it doesn't work. Also tried me.subform.enable = false

I have a form that has 2 combo boxes that I need to make sure an item is selected in before the record is upated. I have the following code in the BeforeUpdate event. The first "if" statement works, the message box pops up, then the focus is set to that control and I select an item. The next...