Copying VBA from one Database to another

[John53T]

Hi
I have an existing database that has a VBA to select criteria based on a list box. This works quite well, but well I duplicated the database and took away some whistles and bells, the VBA did not work but rather came back with: Compile error: User-defined type not defined - Dim Q as QueryDef.
I am not understanding this as it is duplicated from the original database that is working.
Any Help?

[ranman256]

Sometimes it is a false error.
in the VBE (ctl-G) menu,tools,references,
if any checked items say MISSING , it can cause false vb errors.

[HiTechCoach]

Hi
I have an existing database that has a VBA to select criteria based on a list box. This works quite well, but well I duplicated the database and took away some whistles and bells, the VBA did not work but rather came back with: Compile error: User-defined type not defined - Dim Q as QueryDef.
I am not understanding this as it is duplicated from the original database that is working.
Any Help?

Did you also duplicate all the References in the same order?

To check the references, in the VBA Editor go to Tool > References.

I would recommend being explicit with your code like the following

Dim Q as DAO.QueryDef

[John53T]

Hi Ranman256,

Thanks for that, but there are no checked boxes with a missing text.

[John53T]

Hi HiTechCoach,

I compared the two references and noted that the Microsoft Internet Controls and Microsoft Office 16 Access Database Object Library were not checked. Checking them, then gave me the results I needed. Thank you all so much.

[HiTechCoach]

Hi HiTechCoach,

I compared the two references and noted that the Microsoft Internet Controls and Microsoft Office 16 Access Database Object Library were not checked. Checking them, then gave me the results I needed. Thank you all so much.

You're welcome. Glad we could assist.

TIP: Copying or importing VBA between database does not include any required references. You will not see required references checked or marked as MISSING. A good programming practice is to put comments in the code that specify any required reference(s) that needs to be set. It is good idea to read the comment inbt he code.