macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Macros

Macros

resolvedResolved · Low Priority · Version 2003

Hilary has attended:
Access Intermediate course
Access Advanced course
Access Introduction course

Macros

What is the difference between "on enter" and "on got focus"?

RE: macros

Dear Hilary

Thank you for attending Access Advanced course!! I hope you enjoyed the course and benefited from it.

I beleive that I have sent you an e-mail which mentions not only the mentioned action but many other.

In brief GotFocus differs from Enter in that GotFocus occurs every time a control receives the focus. For example, the user clicks a form check box, clicks a report, and then finally clicks the form check box to bring it to the foreground. GotFocus occurs both times the check box receives the focus. In contrast, the Enter event occurs only the first time the user clicks the check box. Occurs after the Enter event.

I am uploading the word file one more time for your convinience.


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Attached files...

macros in access.doc


 

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips


Server loaded in 0.08 secs.