Recent content by briandrago

Now I see why you're microsoft MVP 2007, thanks a lot. You can mark this thread as solved.

So you're the man, what was the difference between the two sets of code? It worked by the way.

I basically copy and pasted the code from your help website and substituted my report and field names Here's the code, and its supposed to be looking up text in a query and outputting a report: Private Sub Command29_Click() Dim strWhere As String Dim ctl As Control Dim varItem As Variant...

I think the code works fine except for the last part, I keep getting an error that says that there is a syntax error. Why do you have EmpID in the last part of the code, should I enter the primary key from the query that I'm getting the information?

File when zipped is still too large to post, sorry

How can I create a code or macro that will allow me to select several options for a listbox and then filter a report based on these selections. I can do it for only one selection but it can't find a match with what I'm looking for when I select multiple. I've visited the baldy help website...

I want to create a form that lists all of the possible brand names from a query, once that brand is selected, it will open up a report that shows all of the information regarding that brand. How can I do this? I've tried Microsoft Help but I can't seem to find the answer to my specific...

How can I enter the following expression into a report to calculate a percentage, please view the attached report picture =absolute value((Actuals-FY09 QF2)/(Actuals)) I need to do this for each lane Thanks for your help