Search results

Im getting a run time error 3071. It says the expression is either typed incorrectly or is too complex to be evaluated! Any ideas?

The name of the report I want to open and populate is "Copy of Main Form (Search By Tool Number)". The form is called "Main Form (Search By Tool Number)". This is the code I used: DoCmd.OpenReport "Copy of Main Form (Search By Tool Number)", , , "ID = '" & Me.Tool No# & "'" The data im...

I tried the code and it didnt work. It said syntax error.. any ideas?

where do i place this code? there is no reference to the text box in the report where i want the information to go..

sorry i phrased the above wrong

I dont follow what is meant by restriction. Which field is fieldname? is that the field in the report that i want the data to go to?

Could you explain further please. Im new and I dont have alot of experience with vba

Hi Is there any way where I can have a command button on my form which will allow me to send a report via an email attachment. Also when pressing the button, is it possible for a list of contact or a message prompting for an email address to be entered to pop up? Any help will be appreciated...

I have created a report that i wish to email. I did this because I cannot send a snapshot of the current form in an email. But now i dont know how to link the textboxes in the report to those in my form such that when i look up a record in my form, I can press a button to preview the report...

vbaInet I got a problem.. how do i contact you?