Search results

Not related to the Delete query, but re your database design: I question the StableName field in tblHorseInfo. Don't horses get traded all the time? Then you may need a new table tblStableHistory that records where the HorseID was from time to time.

ssms implies a SQL Server database. You should be able to query sys.columns for fields by that name. Something like: select object_name(object_id) as theTable, name from sys.columns where name = '???';

Probably best NOT to do that in an expression. I don't know what the values of 0 and 12 signify, but let's say they are "Points" given to such status. UNDOUBTEDLY over time the salary cutoff values will change. It seems best to store this in a new table tblPoints: BasicSalaryUpTo / MaritalStatus...

With regard to "undocumented": the procedures are (of course) in the type library, and the Object Browser (F2) will reveal them if you turn on the "Show Hidden Members" option.

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