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
reacted to
Gasman's post
in the thread
How to filter a crosstab query?.
with
Like
.
You do not name modules the same as sub or function names.
Apr 10, 2024
E
ebs17
replied to the thread
How to filter a crosstab query?.
.
Correct. Someone is reading along, I'm thrilled.
Apr 9, 2024
E
ebs17
replied to the thread
How to filter a crosstab query?.
.
TempVars are only available with Acc2007. Otherwise nothing has changed regarding queries in Access since Acc2000, so I see no reason...
Apr 9, 2024
E
ebs17
replied to the thread
How to filter a crosstab query?.
.
Form references and TempVar have problems as parameter passers when they are used at a deeper level (subquery). I don't know whether...
Apr 8, 2024
E
ebs17
replied to the thread
How to filter a crosstab query?.
.
Variant 4. Dynamic SQL (composing the SQL string using VBA) sSQL = "TRANSFORM ..." & _ " WHERE P.PDATE = " &...
Apr 8, 2024
E
ebs17
replied to the thread
How to filter a crosstab query?.
.
Variant 3: Use of a parameter table SELECT D.* FROM tblData AS D, ptblParameters AS P WHERE D.Anydate = P.parDate The parameter table is...
Apr 8, 2024
E
ebs17
replied to the thread
How to filter a crosstab query?.
.
The function is simply executed like Left, Nz, etc. The fact that it involves passing a parameter is not important...
Apr 8, 2024
E
ebs17
replied to the thread
How to filter a crosstab query?.
.
I inserted the SQL string from one query into the crosstab query. Passing parameters to ONE object is clearer. To pass parameters, I...
Apr 8, 2024
E
ebs17
replied to the thread
How to filter a crosstab query?.
.
When people talk about queries, here a crosstab query, for days - wouldn't it be helpful information to show the SQL statement here as...
Apr 8, 2024
E
ebs17
replied to the thread
Insert Data from an Access table to a similar table in MS SQL Server
.
Detached from previous suggestions: A normal query via Jet could also be used...
Apr 7, 2024
E
ebs17
replied to the thread
Insert Data from an Access table to a similar table in MS SQL Server
.
You would probably first have to talk about exactly which path (line, bandwidth) the backend is connected to the frontend.
Apr 6, 2024
E
ebs17
replied to the thread
Limit the number of entries to a table with a specific value (preventing overbooking in airline)
.
I also mentioned a source. Philipp Stiefel (@sonic8) is also very trustworthy. What always surprises and irritates me is that some VBA...
Apr 6, 2024
E
ebs17
replied to the thread
Limit the number of entries to a table with a specific value (preventing overbooking in airline)
.
Yes, of course. The ultimate way is a validation rule in the table (entered in the design view of the table or via code, analogous...
Apr 6, 2024
E
ebs17
replied to the thread
Insert Data from an Access table to a similar table in MS SQL Server
.
Why do you think such a fragment would work cleanly? Is the documentation burning so you can't look it up?
Apr 6, 2024
E
ebs17
replied to the thread
Solved
Products - Sub Assemblies - Assemblies
.
@KitaYama Take a look at this example from Josef P.
Apr 5, 2024
Home
Members
Top
Bottom