Hi,
I'm new to modules and am using a module to generate sequential numbers in a query. I originally had some trouble as it required referencing DAO before ADO. I then got it working in a simplified database.
When I went to use it in the actual database it didn't work. I made sure the DAO ADO settings were the same as in the database that did work. I'd get a runtime error 91 which is the same I got when I didn't have the DAO ADO settings correct.
I had someone esle more knowledgable look over what I had done look it over and he couldn't see any difference between the one that was working and the one that isn't.
He suggested I just import the tables, queries, etc into the database that did work and go from there. I did this and I still get the error.
Does anyone have any ideas on what I am doing wrong?
Thanks
PS the function is attached
I'm new to modules and am using a module to generate sequential numbers in a query. I originally had some trouble as it required referencing DAO before ADO. I then got it working in a simplified database.
When I went to use it in the actual database it didn't work. I made sure the DAO ADO settings were the same as in the database that did work. I'd get a runtime error 91 which is the same I got when I didn't have the DAO ADO settings correct.
I had someone esle more knowledgable look over what I had done look it over and he couldn't see any difference between the one that was working and the one that isn't.
He suggested I just import the tables, queries, etc into the database that did work and go from there. I did this and I still get the error.
Does anyone have any ideas on what I am doing wrong?
Thanks
PS the function is attached
