Refering to an acObject with a Variable?

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a table that stores the following in a field called ObjectType;
acForm, acReport, acQuery

I am trying to use a variable to call the ObjectType & place it in some
code.
But when the varibale is used, quotations are placed around the acObject.
Example:
objType = Recordset.Fields("ObjectType")
DoCmd.DeleteObject objType, "ObjectName"

When the code runs Quotations are plaed around the Variable objType
this causes my code to fail.
How do I avoid the quotes being placed around my Variable.

I hope all this makes sense.
Thanks
 
The problem you are running into is that acForm, etc. are constants, not text strings. Go
to the debug window (Ctrl+G) and type

?acForm

to get the value of this constant. So, the final result is that you've placed a string
variable where a number should go.
 
Thanks Wayne
I changed the data in my field to the respective numbers of
each constant and the variable to an integer & it seems to work fine.
Thanks again
 
Back
Top