Search results

Have query that is currently run as a passthough query in the legacy app (see threadhttps://www.access-programmers.co.uk/forums/threads/error-in-loading-dll-when-adding-reference-to-dao.315181/) I was getting message "Error:Item not found in this collection" when running this pass-trough...

Using Access 365. Created new accdb file. Have old code that I need to re-use that uses DAO. When I attempt to run it, it tells me "User-defined type not defined." Aha, this usually happens when I am missing references. Of course, I open up the references and since it's a new accdb file...

Trying to figure out if it's possible to add a column of data that I don't care how to match. Basically, I need to insert some sample data into a table to replace live data for a test. So basically I have live data: ID Name Amount 76543 Venkataraman $1,200.00 76532 Mattarnovy $720.23...

Using Access Business 365. I am getting this error 3625 'The text file specification "x" does not exist. You cannot import, export, or link using the specification." I created the specification by performing a successful export. I right clicked on the table, chose Export|Text, chose the...

I am a new user. I have been using Access and Access VBA for about 18 years. I maintain a longstanding app with chewing gum and bailing wire.