I want to reference a table named "FinCoachin g Enrollment File 2" that contains a variable named Client__Name. One source said to use quotes when a file name has spaces.
What is the correct way to do this in VBA?
Thanks.
hwsilver
Last Activity: Jun 28 '21, 09:35 PM
Joined: Jun 8 '21
Location:
-
hwsilver replied to Want to create VBA to create a button which will go to the relevant line in a linked database for a clientin AccessTHanks, NeoPa.
Can a table and variable appear like this? "FinCoachin g Enrollment File 2"!.Client__Nam e?Leave a comment:
-
hwsilver started a topic Want to create VBA to create a button which will go to the relevant line in a linked database for a clientin AccessWant to create VBA to create a button which will go to the relevant line in a linked database for a client
I'm trying to write VBA to create a button which will go to the relevant line in a linked database for a specific client. First I need to have VBA that IDs when the client name in the report matches that in the linked table.
This is what I have so far.
DoCmd.OpenForm "Clients with matches Full Report",View:=a cFormsDS, ,WhereCondition "FinCoachin g Enrollment File 2"!.Client__Nam e = " & "Client... -
That did it. I don't know where the second ([Coach Meetings Record 2].Uniq_Client_ID = [FinCoaching Enrollment File 2].Uniq_Client_ID ) came from, but getting rid of it solved the problem! Thanks.Leave a comment:
-
This is the SQL, with an INNER JOIN, but when I switch it to a LEFT JOIN I get an error message:
SELECT [FinCoaching Enrollment File 2].[Active Match], [FinCoaching Enrollment File 2].Uniq_Client_ID , [FinCoaching Enrollment File 2].[email ], [Coach Meetings Record 2].Uniq_Vol_ID, Max([Coach Meetings Record 2].[Coaching Session Date]) AS [MaxOfCoaching Session Date], Min([Coach Meetings Record 2].[Coaching Session Date]) AS [MinOfCoaching Session...Leave a comment:
-
Hi. Thanks for your response. I tried creating the first table with the information I needed from the meeting table. It didn't work.
Access says that "the SQL statement could not be executed because it contains ambiguous outer joins".
I have been asked to create a report with a page for each client and another report with a page for each volunteer. It don't think that your recommendation does that, but I'm not sure....Leave a comment:
-
hwsilver started a topic re: Can get a Left Join to Work in one summary table but not another in Accessin Accessre: Can get a Left Join to Work in one summary table but not another in Access
I have pulled Clients, Volunteers and Meetings into tables into Access. I need to make a summary page for each Client and Volunteer. If they are matched then the summary should include the name of the client or volunteer with whom they were matched and the first and last times they met. To do this I made a Left Join between the volunteer table and the meeting table and then a rightjoin between the client table and the meeting table.
...
No activity results to display
Leave a comment: