Search results

You need to revisit your table structure. Customer Name is a bad choice for primary key. What are you going to do when a customer name changes? Customer Name is defined as Short Text or Long Text in your tables. You cannot link those 2 types. Add a autonumber ID field as the primary key to your...

Could it be you have an un-trapped error causing the global m_SplitForm in mySplitForm to be cleared?

If you already have the data in Excel, link your Access FE to the sheet(s), then use queries or code and record sets to import that data into normalized Access tables.

When dealing with high precision math on a computer, you need to be very careful with all calculations. Defining all constants and variable using the required precision helps the complier choose the correct method. You will find languages handle the calculations very differently. Lookup...

If you are converting existing text and memo fields to RTF, you will need to update the data. Replace line feeds with "<BR>". Replace$(OldText, Chr$(10), "<BR>") or Replace$(OldText, vbCrLf, "<BR>")

I have add RTF to some forms, but the Access version of it is VERY limited.

Welcome from a another former Paradox user.

impersonationLevel=impersonate is the default, but it don't hurt to add it. see https://learn.microsoft.com/en-us/windows/win32/com/impersonation-levels https://learn.microsoft.com/en-us/windows/win32/wmisdk/setting-the-default-process-security-level-using-vbscript

Is that the same as the command line taskkill /im MSACCESS.exe /t /f? Killing all instances of Access?

Have you considered rebooting your computer once a day? A lot of software handle resources poorly, reboot cleans that up. I use CAD software and it has documentation to improve performance; it suggest giving your computer a lunch break by rebooting. Another thing that will slow down your...

I converted 1.95 to single as an example to get the same result as you are seeing in SQL Server. My guess is that SQL Server is doing the calculation in the lower precision because the 2 terms can be represented as Integer and single. By casting 1.95 to double, you force SQL Server to do the...

I was able to get close to the SQL server answer by casing 1.95 to single. Could be you need to cast 1.95 to double before the calculation. ?1/csng(1.95) 0.5128205

Is the laptop on wifi?

Scripting.Dictionary is nothing like a table or query object. My point was that those 2 objects are derived for the same base class and VBA thoughtfully decided they were interchangeable in this case.

Actually they are very similar. I looks like the VBA compiler is being its helpful self when handling type conversions. BTW it compiles on my computer with out error.

I suspect that DAO.TableDef and DAO.QueryDef extend the same class. Of course it would be simpler to access the properties directly. debug.print tc.Name debug.print qd.Name or debug.print db("Name") db("Name") qd("Name")

I posted one in code repository. It configure it's self for MsgBox and InputBox based on how it's opened. https://www.access-programmers.co.uk/forums/threads/another-input-box-replacement.334414/

I remember reading somewhere that if you name your message box function MsgBox, it will be used instead of the built-in function. The reason is that VBA modules are search before built-in.

I just finished an AI session trying to solve a problem with a poorly documented API. It repeatedly gave me solutions using object properties that don't exist. It did finely admitted that it could not reference any examples that would solve the problem.

The only time I saw that problem was on laptops when not connected.