Newbee Question

[vbaInet]

Docmd.OpenReport Me.NameOfListbox.value

 

[danbl]

I placed this command in the Onclick event field and received the following:

MSAccess cant find the macro 'Docmd.'
the macro(or its macro group) doesn't exist or the macro is new and hasn't been saved.
Note that when you enter the macrogroupname.macro syntax in an argument, you must specify the name of the macro's macro group was last saved under.

???

 

[vbaInet]

1. Click the elipsis button on the On Click EVENT.
2. Select Code Builder from the list and click OK.
3. Enter the code where the cursor is placed.

 

[danbl]

That appears to work fine .... many thanks to all. This is a great place to find answers and get assistance!!

How would I change the syntax to get print preview?

 

[vbaInet]

Open up the Access help file and type in DoCmd.OpenReport. You will be able to find the right argument for this.

 

[danbl]

Found it .....

Thanks again for all the help!!!

 

[vbaInet]

No problemo! You're welcome!

 

[danbl]

No good effort and assistance goes without followup thoughts and questions.

Is there a way in the syntax below to restrict the reports to only those that begin with "C"?

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32764));

Thanks once again

 

[vbaInet]

Sure:

WHERE (((MSysObjects.Type)=-32764) AND Left(MSysObjects.Name, 1) = "C")

 

[danbl]

Awsome ..... thanks again. I have learned a great deal with your help!!

 

[vbaInet]

Happy to help!