Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
ebs17's latest activity
E
ebs17
replied to the thread
Solved
Progress meter for reports & queries in MS Access
.
The primary concern would be that the processes are sufficiently fast so that a progress display is only perceived as an annoying...
Apr 16, 2024
E
ebs17
replied to the thread
Subtract integer from time duration
.
DateTime values are internally numbers (double). The integers are days (since 1899-12-30), the decimal parts are fractions of a day. So...
Apr 16, 2024
E
ebs17
replied to the thread
Several executes with currentDB possible?
.
I don't use OpenQuery. db.Execute handles stored queries very well and provides reasonable error handling.
Apr 15, 2024
E
ebs17
replied to the thread
Solved
What causes a sub form being locked?
.
Have you already landed on the unbound form? If events and dependencies in a bound form bother me, I eliminate the cause and switch to...
Apr 15, 2024
E
ebs17
replied to the thread
Solved
Select Into Query with varible issue
.
Of course not with one table in the source query. However, the table alias is more efficient than using the table name multiple times...
Apr 15, 2024
E
ebs17
replied to the thread
Solved
Select Into Query with varible issue
.
strSQL = "SELECT S.* INTO " & intoTable & " FROM " & selectTable & " AS S" Using a table alias makes things clearer because the name of...
Apr 15, 2024
E
ebs17
replied to the thread
Solved
What causes a sub form being locked?
.
I like to exaggerate identified problems to make them clearly visible. In this specific case, the chosen statement may not be...
Apr 14, 2024
E
ebs17
replied to the thread
Solved
What causes a sub form being locked?
.
It is bad and problematic to start editing a record in a bound form and then do something completely different before finishing -...
Apr 14, 2024
E
ebs17
replied to the thread
Solved
How much computer memory is required to run SQL Server Cloud
.
If you work with Access: An Access file can be a maximum of 2 GB, Access cannot manage more. The same quantity limitation applies to...
Apr 13, 2024
E
ebs17
replied to the thread
Finding missing No
.
Something can only be missing if you have an idea of completeness. Therefore you would have to compare your table against a complete...
Apr 13, 2024
E
ebs17
replied to the thread
Abortion
.
In the former GDR (East Germany), abortions were allowed up to the twelfth week, and there was not much discussion about it. One did not...
Apr 12, 2024
E
ebs17
replied to the thread
Opentextfile leads to error 5
.
ForReading If you use late binding, constants from the object used are unknown. So you would have to insert the real value or declare...
Apr 10, 2024
E
ebs17
replied to the thread
Inserting multiple rows into an email created by VBA
.
How do you add the one line so far? For ease of use, this would be the interesting place to meet your requirements.
Apr 10, 2024
E
ebs17
replied to the thread
how to resolve inconsistent query results
.
In the access options you can set: SQL Server compatible syntax (ANSI92) Then the percent sign is used as a wildcard. ANSI89 is used as...
Apr 10, 2024
E
ebs17
replied to the thread
How to filter a crosstab query?.
.
It must be a standard module, not a form's module. And of course the form being accessed must also be open at this moment and contain a...
Apr 10, 2024
Home
Members
Top
Bottom