Search results

Isn't that additional work that overshadows the actual effort of query execution? => TakeStartTime Set rs = db.Openrecordset(SqlStatement, dbOpenForwardOnly) rs.MoveLast => TakeEndTime For a clean measurement, I would also expect that each compound expression is unique, i.e. occurs only once in...

I would like to see the complete test environment. If you do exactly the same thing and just add some overhead, you shouldn't be surprised if runtimes increase. This conclusion seems plausible to me even without testing. The Expression Service only works if the query is started from Access...

Mid, Instr and other functions are not part of Jet-SQL, but are made available via the so-called Expression Service. Therefore, VBA functions, Access functions (Nz, DCount) and self-defined functions can be integrated into queries. If you do not notice such a transfer and the associated...

Don't worry. I do that often. You're basically right about performance. But performance is relative. If I use RegEx, even an external library, there are no problems that a user would notice when querying record numbers in the 5-digit range. In a query with mass data, I would never use compound...

What is the expression but applied programming? One could also argue that the expression represents a hard-coding of precise circumstances. Split is a bit more variable, and RegEx, if you can use it reasonably well, is a highly variable magic wand.

Normally the frontend is simply replaced. The developer makes the necessary changes and provides the user with the new version. If the frontend is compiled (delivered as ACCDE), there is no alternative. Otherwise: 1) Reference to Microsoft Visual Basic for Applications Extensibility 5.3. This...

What if you believe the error message: If FileExists(TableName) Then Name TableName As FolderName Else Debug.Print "not found: " & TableName End If https://www.devhut.net/vba-determine-if-a-file-exists-or-not/

Creating a copy will be less of a problem. However, you don't know whether this copy is error-free and can be used 100% as a backup. You shouldn't just assume something like that, you should check it explicitly. If you really need a backup, it should also be usable. Simple rule of thumb: In...

Strictly speaking, a delete query always eliminates entire records. There is no need for a field list: DELETE FROM tblPhoneDirectory

You only open a form, creating it is something else => use design mode and take appropriate action by hand or code. A form is a class, and opened forms are "only" instances of this class. The form name is actually the name of the class, which is then passed on as a property of the instance. If...

I explicitly included a DB reference as an argument because I basically wanted to take into account unlinked tables from external databases. The test used by @MarkK via MSysObjects will then fail in this form. Of course, one have to initialize this reference before calling it. But that was less...

Note: I always see the effort to put together an SQL statement using code. I personally prefer to pass a complete SQL statement as an argument, and also the name of a saved query. For me it makes more sense to write a query the way it should look, rather than trying to put it together somehow...

I would suspect less of a data problem. If the amount of data to be loaded is larger than the currently available memory, the data is automatically switched to the swap file on the hard disk. The result is that the processing speed drops significantly. Or should the swap file be too small? I...

In this topic, however, we are primarily dealing with the task described in #1: marking the records in the table in which the associated file no longer exists. Something missing can only be determined by comparing what is complete with what is present => a classic task for SQL, and for this you...

Therefore, it would be beneficial to monitor the file system itself and to immediately record current changes and pass them on to the database. Something like this could help. https://www.codeproject.com/Articles/42212/WMI-and-File-System-Monitoring

#Name? ... means that something is unknown. The existing rule of getting values from somewhere doesn't work like that. The first step should therefore be to look at what exactly you are doing. So, what do you have planned? Simply complaining is of no use. It makes more sense, also in the sense...

A great quote. One should also beware of political leaders who insult others and spread hatred and division.

I haven't tested the function sufficient yet. I guess the initial test needs to be changed. If intYears <1 Then ' => If intMonths <13 or something similar, and adjust the other lines of code accordingly. Try it yourself, you learn best by doing.

Yes, it's the same logic. Day is preferred here because it returns Long, while the Format function produces a String. Comparing using numbers is faster than using strings because fewer bytes are needed for representation. Format(Date, "mmdd") ' could also be replaced to generate numbers by...

It is just a demarcation from your code. The name of the function can be anything you want, it just needs to be self-explanatory. DateDiff should be self-explanatory, or compare in the documentation. However, when it comes to years, it makes a difference whether the Hire_Date is before or after...