Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Arrays

	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

Arrays

Resolved · Urgent Priority · Version 2003

Reply Mon 11 Aug 2008, 14:49Delegate Robert said...

Robert has attended:
Access VBA course

Arrays

Hi

I attended a VBA course last week.

I have a form with around 10 input boxes (going into one table) for which i've added a command button to put the data to an array and to then put it to one of two tables depending on the results.

The problem I have is when i've input the data, the commend button code only works when I click onto the next record at the bottom of the screen first (thus saving the data to the table).

How do I get the command button to save the data to the bound table before going into the code etc?

Thanks

Robert

For upcoming training course dates see: Pricing & availability

Reply Tue 12 Aug 2008, 08:37Trainer Stephen said...

RE: Arrays

Hi Robert

Thank you for your question

It is difficult to advise you without seeing the application and the code

Could you email a copy to me at stephenATmicrosofttraining.net and I will get back to you asap

Regards

Stephen

Access articles

· So You Still Haven't Learned How To Use Access Yet?
· Help Business To Go Global With Shared Databases
· Microsoft Access as a Business's Database Management System
· User-Proofing Your Access Database: Part 2
· It's so easy to Access the information you need

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

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips