Archive for the ‘cpt’ tag
Procedure Code Lookup
where does DoCmdRUNSQL get its pathway to look up a database from?
i have an access database that has a DocmdRUNSQL procedure in the vbcode. but when it runs i get an error 3044, saying that the pathway is not valid, and it gives me the errant pathway. i know what the new pathway is that i need to enter, but i cannot find where the RUNSQL is getting the errant pathway so i can change it. i’ve deleted every other piece of code in the whole database, and still i get the same message. is there something i’m missing here? where does it lookup the pathway?
where does DoCmdRUNSQL get its pathway to look up a database from?
Firstly, “DoCmdRUNSQL” is not a standard vba keyword in Access.
“DoCmd.RunSQL” is the standard command in Access which requires an sql statement.
Therefore the following line would typically look like:
DoCmd.RunSQL “Select …… ”
The standard DoCmd.RunSQL runs from the same database file which it is used in and therefore no pathway is required (it’s already known).
The error code 3044 refers to a database connection (which can be itself) which requires a valid path, userid and password (in some cases) but is typically used with ADO or DAO objects which creates a connection to the database.
It sounds like that your DoCmdRUNSQL is a written procedure which creates a connection of this type and you will need to locate this in a module. The best way to do this is go to this command and place the cursor on this command and then from the keyboard press SHIFT + F2 together which should jump to the procedure if known.
Take a look at the code and debug it. It will be here the path is set etc…
Ben Beitler
ICD-10 Code W21.3
|
|
CPT 2012: Standard Edition (Cpt / Current Procedural Terminology (Standard Edition)) $61.00 … |