Emma has attended:
Access VBA course
Modifying a query from a form using VBA
Hi, I want to modify a query from a form using VBA. I have created a calander in a form. From the calander, you select a date, then copy this to a text box using the command Me.BeginningDate = Me.ReportCal.Value
I thne want to copy this date into a a pre-existing query, so I can query on this date (or on any other date), just by selecting the date from the calander.
Thanks
RE: Modifying a query from a form using VBA
Hello Emma
Thank you for your query and welcome to the forum.
Firstly apologies for the unusually long delay in response.
We offer the forum service to all our delegates to answer questions related directly to content of courses they have attended with us.
While we are happy to support and advise our delegates in the manner that the forum was intended, there will be instances where we choose to advise delegates that we can only assist in a consultative role which would involve dedicated time from a trainer, and be billable.
If you are interested in taking this option forward to resolve any remaining issues with your spreadsheet, please contact our enquiries team to discuss your requirement on phone number.
Kind regards
Amanda
