Search results

Typically, when I need Autonumber, I'll create a template table to reset it, since it will inherently increment forever and I don't want to even consider how long that would take to become a problem. Ha. This has worked without issue for a long time. Today, however, I've run into a situation...

I've pretty much always used bound forms, and have only rarely needed to do otherwise. But, while looking at one of my very simple forms recently, it occurred to me that I wouldn't have to use a bound form to show this one particular piece of data. I could, instead, use a function (that I wrote...

I've been running some import code successfully for a long while - like hours. This import step/process is being repeated many hundreds of times. (I'm looping through hundreds of files in a folder, pulling data in from them basically.) Suddenly, I see this error 3625, with a misleading message...

I'm very frustrated that the many years of experience with Access VBA, still leaves me challenged to do the simplest things. I have a simple form, connected to a simple table, and I want to perform a simple process - just add a new record. I'm trying to avoid the scenario where the user keeps...

I'm trying to process some large text files, and although I can import them, I would rather link to them pull the data I need and then unlink and process the next file. Turns out I need to do some clean-up of these files before working on them (removing junk up top - leaving nice delimited...

Maybe I don't understand what these routines are for, but, I cannot get them to fire - at all. My intention is to use the Detail_Paint routine to do a little custom formatting, but this routine is called over and over again. So, I want to find a way to trap if/when the form is *first* rendered...

I need to determine if Access 2000 (Jet/ADO 4.0) supports the full UTF-16 Unicode encoding standard or if it only supports UCS-2. Anyone know this? (Apparently various resources out there have inconsistent info - indicating it is UTF-16, while still asserting it uses 2 bytes per character -...

In Access 365, I often dynamically construct queries in VBA, (e.g., in a variable like "strSQL"), and then run them with DoCmd.RunSQL strSQL. I've encountered a very odd situation where Access throws Error 3113 when encountering a certain query in a VBA routine, but then upon clicking the Debug...

With the introduction of Data Macros (apparently 2010 and later), Access now supports something close to a database trigger. I was very excited to finally be able to set up a Date/Time field that would automatically update to reflect the most recent edit of any field in a table. For this to...

I've managed to mess up my Access 365 installation to the point that if I try to use the Replace(x, y ,z) function in an SQL statement - it actually crashes Access. Does anyone know what dll is used by Access 365 to perform this function in SQL statements?

I'm trying to use "data macros" as a basis for performing a trigger-like action in Access (365). Ordinarily I might do this simply with an "After Update" event on the field of interest with some VBA etc., but in this case, I have a split database, where code is running in the back-end, and I'm...

I have two forms, both of which I've updated the data source to a new query - and both are presenting the exact same new field from that exact same query... One form works fine, the other shows "#Name?". I've double-checked the field name is correct. The two forms are both of the same type -...

I'm Papa_Bear1 and I'm just introducing myself to AccessWorld. I've been programming in Access since I can remember (... the early 90s... ;-) I think it is a fantastic realm to live in. I've been singing the praises of MS Access for many years. I do admit that having used it for so long, I...