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
Assessing Project Size
.
Database development is a special branch within programming because it involves processing a lot of data very quickly and certain...
Apr 22, 2024
E
ebs17
replied to the thread
Solved
DatePart function error
.
The overall expression produces a number using mathematical calculation, i.e. 202404 for the current month. So the multiplication only...
Apr 22, 2024
E
ebs17
replied to the thread
Subtract integer from time duration
.
DateDiff("n", EventBeginDate + EventBeginTime, EventEndDate + EventEndTime) / 60 DateTime values are internally numbers, and numbers can...
Apr 21, 2024
E
ebs17
replied to the thread
Subtract integer from time duration
.
EventBeginDate & " " & EventBeginTime Real? I would expect one to add numbers.
Apr 21, 2024
E
ebs17
replied to the thread
Solved
DatePart function error
.
DatePart, Month and Year return an integer, Format returns text. With text, more bytes have to be processed than with an integer, which...
Apr 21, 2024
E
ebs17
replied to the thread
Docmd.Transferspreadsheet
.
Saved under new name (CreateQueryDef, ...): SELECT * FROM ExistingName Can your organization cope with something like that?
Apr 19, 2024
E
ebs17
replied to the thread
Solved
Error on Creating a Query after changing LongTextField to Short Text
.
With CurrentDb .Execute "UPDATE " & tableName & " SET Umsatztext = Left(Umsatztext, 255)", dbFailOnError .Execute "ALTER...
Apr 17, 2024
E
ebs17
replied to the thread
Solved
Select Into Query with varible issue
.
As an addition: To be on the safe side, you could mask the table names with brackets if there could be spaces or special characters.
Apr 17, 2024
E
ebs17
replied to the thread
Round Up
.
Function CeilingToMultiple(ByVal value As Double, ByVal multiple As Integer) As Double CeilingToMultiple = -Int(-value / multiple) *...
Apr 17, 2024
E
ebs17
replied to the thread
Solved
Progress meter for reports & queries in MS Access
.
Adding an additional break is easier than shortening the runtime in a process. You can also simply install a progress bar there and you...
Apr 16, 2024
E
ebs17
reacted to
The_Doc_Man's post
in the thread
Solved
Progress meter for reports & queries in MS Access
with
Like
.
You reminded me of a moment where I "optimized" another program that took a predictable 17 minutes to finish its processing, but I got...
Apr 16, 2024
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
Home
Members
Top
Bottom