Understanding Currentdb.execute

[dmaranan]

As always I am learning VBA as quickly as I so I can fix an application...

I'm trying to understand the syntax Currentdb.execute. I have a line of code that says , currentdb.execute "submitDEdata". My guess was that "submitDEdata" was a stored procedure. Unfortunately it isn't; the current db is an MS Access table, and the SQL serverdatabase that the MS Access table connects do does not have a stored procedure called submitDEdata.

I've got to VBA books and can't find what arguments can be passed to currentdb.execute. My gues is that it passes SQL, if thats the case what is "submitDEdata"?

Thanks!

 

[zevw]

You have a query that has this name and that is what is being executed (maybe its hidden)

 

[dmaranan]

Is there a way to show hidden queries?

 

[zevw]

Go to Tools==>Options and click on Hidden Objects

 

[dmaranan]

I see them!!!! You are my hero!!! Thank you, thank you, thank you.

Its hard going from Informix to MS Access...