Search results

I had the command to open the report as a macro. I changed it to a vb code and received this error on "docmd.openreport" - Run Time Error 2497 - The action or method requires a report name argument

I received a: Syntax Error in WHERE clause. and the next box says: Action Failed Macro Name: FrmIncident : btnReport : OnClick : Embedded Macro Condition: True Action Name: OpenReport Arguments: RptIncident, 5, , , Normal

It reads 3086. Is that too much to make a difference?

I tried the debug.print but no window appeared. I even removed the open report and replaced it with the debug.print and received nothing. with the second part, are you saying to replace... If Not IsNull([Forms]![frmIncident]![Breed]) Then strWhere = strWhere & "([Breed] = '" &...

Oh. Sorry. After I added the final yes/no fields, the error "filter canceled" reared its ugly head again. I counted approximately yes/no 170 fields in total.

Mister, You are a lifesaver!!! Thank you for the help. I guess I need to look more closely. (of course I've been at this for approximately 12 hours today though).

I figured out what was wrong with the report button not working when transferring from 07 to 03. If a form has "No" for auto center in properties, it doesn't open in 03. I changed it and the buttons work now. Must be a flaw in the program. I'm going to try to look through the code again and...

it is sent

sending it now.. taking some time to attach.

Do you mind looking at my actual db and determining where I'm going wrong? I'd like to send it by personal message, though, and not post it for all to see.

I removed the single quotes from the numeric fields. I still receive the same error as last. Is there something I need to do for the yes/no fields as well?

That was it. Thanks Paul!

I tried this strWhere = strWhere & "([Classification] = '" & [Forms]![frmIncident]![Classification] & "') And " and got a "data type mismatch in criteria expression.

ah. I didn't see the single quote. Let me try that.

I'll try the first part. I thought of the second part and set the form -when filtering- to open in "new record" and added "form.undo" near the end of the thread so that the record is not changed when filtering.

Hello, How do I set "openform" buttons to hide certain buttons on the form to be opened on click?

Actually, Sorry, I saw a mistake in my code. I actually had this... strWhere = "([tbo1] = " & [Forms]![frmIncident]![tbo1] & ") And " & strWhere I took of all the "& strWhere" and now when I click the report button, all records appear on the report as if I never filtered.

Thanks for the string Paul. I assume what you recommended was that I replaced all the.... strWhere = "([tbo1] = [Forms]![frmIncident]![tbo1]) And " with strWhere = "([tbo1] = " & [Forms]![frmIncident]![tbo1] & ") And " I did this and reattempted the filter and received a "enter...

Hello, I have a form with a memo box where the user can input a few sentences. I was wondering if anyone had a simple keyword search-to-report form/code where a user could enter a...keyword...and hit the report button to display all records where the desired keyword is in the memo box?

I'm sorry, but I'm somewhat new to this still and not sure how to implement the code in the link you provided. I get the basic of the page is saying, but I'm not sure how the code would look as a whole.