Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Modifying a query from a form using VBA

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Modifying a query from a form using VBA

Resolved · High Priority · Version 2003

Reply Mon 9 Jun 2008, 18:25Delegate 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

For upcoming training course dates see: Pricing & availability

Reply Wed 6 Aug 2008, 16:33Trainer 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

Access articles

· Don't Do It By The Book, Access Your Important Contacts In An Easy To Use Database
· Use Split Form View In Access For Simultaneous Views
· Practice Microsoft Access Database Decorum To Reap The Rewards
· How To Create An Index Report In Access
· Three Myths About Microsoft Access

Please browse our web site to find out more about
microsoft access training courses and other Microsoft training courses.

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips