Cant Find Object

[IkeK]

Hello All.

I created a view in SQL that can be viewed in Access ADP.

I want to email this view.

I have a simple docmd line that should work, but the error I get is below. The strange thing is that Access is adding a one to Query name. I tried assigning it to a variable and I get the same thing. Below is the screen shot of the error and code I am typing in the immediate window to test.

docmd.SendObject acSendQuery ,"CurtisDrayageInvoiceEmail", acFormatXLSX,"test@email.com"

 

[IkeK]

Compare the line of text you typed to the error message. Your code is different from what you posted.

I dont see what you are reffering to. The queryName is hard Coded as "CurtisDrayageInvoiceEmail" the error is coming back "CurtisDrayageInvoiceEmail1" . it appears the system is adding a 1 to the query name.

 

[Gasman]

Have you tried another query just as a debug step?
That syntax works fine for me?

 

[IkeK]

Have you tried another query just as a debug step?
That syntax works fine for me?

your correct, it is happening with any query. Strange

 

[IkeK]

Look at your code. If you don't see the 1, then there is probably some corruption. Delete the line of code. Do a Decompile. Then retype the code.

decompile? I never saw that command. I did a compile and didnt get an error

 

[xavier.batlle]

decompile? I never saw that command. I did a compile and didnt get an error

Open ms access with the /decompile parameter:
MSACCESS.EXE /DECOMPILE
And recompile the code again

 

[cheekybuddha]

What version of Access are you using?

I didn't think recent versions of Access even opened ADP's anymore.