Search results

Open the Immediate window (Ctrl+G) Type: Application.SaveAsText and a <space>, and follow intellisense prompt. Similar for Application.LoadFromText.

This is a normal error that gets raised when you (or your code) cancel certain actions, such as OpenForm or OpenReport. That's why in Northwind Dev Edition's error handler, we wrote: If lngError = 2501 Then Exit Sub '2501 = The OpenForm action was canceled. Not really an error. BTW, I...

I'm curious what arguments pro and con you end up with. Please share your thoughts when you get to that point.

I like using classes in Access, in a number of ways. * Static classes such as clsErrorHandler in Northwind 2 Dev Edition (NW2), to further encapsulate error handler functions. * Form subclassing, so we can have common functionality (responding to certain common events) implemented once, and...

The zero-code solution is to make that field required in the table. That is also the best idea from a database design point of view.

Welcome to the forum! Tom van Stiphout, from Phoenix, Arizona.

It's a really bad idea to have a table without a Primary Key. However, just adding one does not fix the problem. Moving the line "Set rs1 = db.OpenRecordset("listtables", dbOpenDynaset)" to below "DoCmd.SetWarnings True" does solve the original problem. You then have a new problem: Error 3021 =...

If such forum has technical content, I will follow it. If it is watercooler content, then not so much.

In one project I have tblDocuments with all documents. The filename references the document in a server folder. All 120K docs are in the same folder. The OrigFileName allows for reconstructing the file in the TEMP folder with the original filename. After that, I have tables that link the records...

Tables can be in the FE. For example, I keep tblSystemSettings_FE in the FE. It includes a field indicating where the BE is. Your tblReports can certainly be in the FE as well. I'm not so sure about lookup tables (tblTaxLine and tblAccountTypes appear to be such tables): since their ID values...

Assuming you're not targeting A2007, this is not needed. And hWnd is a LongPtr.

This may help: https://www.microsoft.com/en-us/download/details.aspx?id=9970&msockid=2f33863951c960d80163931050b66168

File >New gives you access to the templates. I can recommend Northwind Starter Edition. It is a showcase of what is possible with Access, and it comes with lots of documentation.

I have seen this too. Sorry, I don't know how to fix this, other than to close forms after they have been idle for a while.

Did you know that you can calculate running totals in a report? https://support.microsoft.com/en-us/office/summing-in-reports-ad4e310d-64e9-4699-8d33-b8ae9639fbf4 Wrt sorting: it is customary to base a report on a query, not a recordset. That query can be unordered. Then in the report you use...

To list the names of the available printers, save this procedure to a standard module, and run it from the Immediate window: Public Sub DumpPrinters() Dim p As Access.Printer For Each p In Access.Printers Debug.Print p.DeviceName, p.DriverName, p.Port Next p End Sub

What phone system are you using? If a business class phone system, I may have a possible solution.

It is not recommended to use Reserved Words like Type and Group for object names. https://learn.microsoft.com/en-us/office/troubleshoot/access/reserved-words

Amen to that. Do not fall in the trap of temporary solutions. They may be around for a long while. I agree: keep the local cache in place. It works. Don't mess with it. The new-ish Cache settings in Options form are not for your scenario. Leave it alone.