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
Help with Instr Function
.
The first request = determining an IBAN has been solved. Matches(0).Value returns the determined string Matches(0).FirstIndex returns...
Apr 26, 2024
E
ebs17
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.
Apr 24, 2024
E
ebs17
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 (...
Apr 24, 2024
E
ebs17
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...
Apr 23, 2024
E
ebs17
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.
Apr 23, 2024
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
Home
Members
Top
Bottom