Modifying a query from a form using VBA

Resolved · High Priority · Version 2003

Mon 9 Jun 2008, 18:25 Delegate Emma said...

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

Wed 6 Aug 2008, 16:33 Trainer Amanda said...

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