Search results

There's a couple of things that might be happening.... Are you using a date field for the month parameter, or text? There might be a disconnect then somewhere between your form and the query, too. Try using blank parameters in your query, so in your Job Field in the query, in the Criteria...

I understand completely. Did you manage to get it working?

SirStevie3, I think you'll need to run two queries. I'm not sure how you're doing this, but you can run one query without any criteria on your checkbox field if you value is "Ignore" and then a second query if the value is <> Ignore and write the query with an IIF in the the criteria, like...

I'm not sure what's happening ... can you post your database? I'd be happy to look into it but it's hard for me to troubleshoot without seeing it.

Make sure your form is not in Design mode....

Great! Glad to help.

Numerous parameters shouldn't be a problem. You can always test your query before launching the report to make sure it works. If you like, post your query here and I'll see if I can spot the problem.

LinaRose, I'd put the parameter in the query. As an example, I create reports for regional operations - and we have four regions: Central, East, North and West. In my query, in the Region Field, I place the parameter like this: [Forms].[frmPrint].[cboRegion]. Then, on my frmPrint form, I have...

JHB, thanks, that worked fine. I appreciate that! Although, I do wonder why it didn't work on the first page, but only intellectually, as the report is due out the door, and now it works. Thanks again, I appreciate the tip.

Sure you should be able to do this. I might use combo boxes on the form, then write a query for the report and use parameters in the query based on the values in the combo boxes.

Hi everyone. I have a report where I read the value of a field in my query (a boolean) field, and if the value is true, I display two lines on my report, hide the lines if the value is false. Here's the code: Private Sub Report_Page() If Me.Flagged.Value = True Then...

Really, thanks again, as it was a tremendous help. It ran in about 1 second to solve a problem that otherwise would have taken me hours. If I'm ever in Merseyside, I'll buy you a pint, or if you're ever in Canada....

That's it, works a treat. Thanks again.

Thanks again, Brian, but I am a bit thick; this works perfectly if I place my columns in positions 1 and 2. The only challenge I have understanding where you identify which column to look into for the year and the ID. If I get that, I'm off to the races. Thanks again, Don

Thanks Brian; I was trying to do this with formulae. I'll dive into the code and, providing I can replicate it, I'm away. This looks like it will work - thanks ever so much.

Hi, I have an Excel Spreadsheet (2010) with 50K+ rows that has transaction information for individuals. I have DOB, unique ID, and transaction information in the columns. For each person, I may have dozens/hundreds of entries. What I would like to do is count how many persons I have using...

Thanks Godsspeed. Sadly, we're still using Word 2003/Excel 2003. My VBA solution that I posted here is working, and what I've (wisely?) done is change the process to use an Access database and I've programmed that accordingly to give the users both the input and output that they want. That's...

I have a document that, based on a user selection from a combobox, I'd like to put a specific note in the footer. The combobox is on the first page of a multi-page document, and I'd like a notice to appear on each page, and the footer would work well. While I am fairly comfortable with VBA in...

Just to let you know, I 'mostly' figured this out. I'm not thrilled with my solution, so if there's some improvements I can make, I'd be happy to hear of them. What I did was create a series of macros like this: Sub High() 'warn users if they are not in the table If Not...

Hi there, I have a two-column table in word, where column one is a static label and column 2 can have 4 values - High, Low, Medium and Nil. What I'd like to do is format the background colour of the cell after the value is entered. I'm fairly handy with VBA in Access, but am a complete newb...