I'm looking for a line of code that would make it possible for me to select a specific record in a datasheet view form based upon a field criteria. More specifically, I would like that the selected record be the one that has id_activite = 6310. I do not want to play with datasheet sorting or anything. Is there any way to perform this simple operation?
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Learn how to number pages in an Access report over each group.
Activate two pass printing by referencing the pages property:
Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…