ebs17's latest activity
-
Eebs17 replied to the thread How many genders are there? How many should there be?.The oldest trade in the world ensures that you can not only look but also touch.
-
Eebs17 replied to the thread Solved Access VBA Grouping and Averages.PARAMETERS parMargin Double ; SELECT Q.Race, Round(AVG(Q.Rate), 10) AS AvgRate, COUNT(Q.Rate) AS Runners FROM (...
-
Eebs17 replied to the thread Solved DatePart function error.? CDate("Apr-24") There are a number of formats that can be directly interpreted as a date. When it comes to names (here Apr), the...
-
Eebs17 replied to the thread Solved DatePart function error.? CDate(Format(202404, "@@@@-@@-24")) But the 24 is arbitrary because it cannot be derived from the year or month.
-
Eebs17 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...
-
Eebs17 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...
-
Eebs17 replied to the thread Subtract integer from time duration.DateDiff("n", EventBeginDate + EventBeginTime, EventEndDate + EventEndTime) / 60 DateTime values are internally numbers, and numbers can...
-
Eebs17 replied to the thread Subtract integer from time duration.EventBeginDate & " " & EventBeginTime Real? I would expect one to add numbers.
-
Eebs17 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...
-
Eebs17 replied to the thread Docmd.Transferspreadsheet.Saved under new name (CreateQueryDef, ...): SELECT * FROM ExistingName Can your organization cope with something like that?
-
Eebs17 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...
-
Eebs17 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.
-
Eebs17 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...
-
Eebs17 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...