Search results

There's some sort of wrapper function for all of the message boxes in that section, and I don't recall writing that. I was able to do a search-and-replace over that section, simplifying the error message boxes and get it to work without the reference to MB_iconstop bit. I do remember using...

Thanks, I was missing that little button for the Pass Through type on the ribbon. Looks like we're constantly overwriting the ones that already exist most of the time.

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...

Is "Microsoft 16.0 Access Object Library" it? it is already present and checked. Aha! Found it. It's called "Microsoft Office 16.0 Access database engine Object Library." That got me past that. Next thing that seems to be an issue is I am using MB_iconstop which seems to be referenced in...

Nope, what about "Microsoft Data Access Components Installed Version"?

No, I don't "Microsoft Access Database Engine" listed.

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...

And to top it off, I rarely save the "steps" since I rarely do the same thing twice, and if I do, I do it in VBA. This is the first time I have tried to exports something with a non-standard delimiter. Usually, I just use the .TransferSpreadsheet method, and I have a little wrapper function I...

Gasman, You may be onto something with that. And I may have inadvertently fixed it because the second time I did it, I used the Advanced button and the Save As... button. The simpler name might have been a coincidence. That's a great link

That seemed to do it. Created a new one and gave it a simple name of "pp1" and away it went.

That's a good suggestion. That export specification was what Access suggested, so I just went with it. I will re-export and save it under a new name. For what it's worth I have found DoCmd.RunSavedImportExport works file. Only, I do not have control over where it is saved or what the output...

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.