Working with a combo box record selector. Q: Debbie Sabia writes that she has created a form with a record selector combo box. The end user selects an ID from the combo box and correct data is pulled up on that student. Here’s the problem. When you use the record selector to go to record […]
How to make all table records appear in a query regardless of whether they have any linked Extras records. Q: Liz has a query that returns records from a Registration table and an Extras table. She needs the recordset to include all the records in the Registration table regardless of whether they have any linked […]
Using the Size to Fit Form. Q: Peter Farren writes “I would be grateful if you could clarify for me usage of the acCmdSizeToFitForm constant. For example, the Load Event of frmInvoices in Archon Column 114 consists of: DoCmd.RunCommand acCmdSizeToFitForm I assume that the RunCommand method is applied to the Subform fsubCompanyInfo. Once […]
How to reference specific fields in an Access query. Q: Lee Aldrich wants to know how to reference specific fields in an Access query/dataset. A: In VBA code, you can set up a DAO recordset to work with Access data, using the following syntax (the example sets two variables with values picked up from […]
How to change the color of a specific control on a report. Q: Huber Stevan wants to know whether there is a way to change the color of a specific control on a report record by record, depending on whether certain criteria are met. A: For a report, this can be done in all Access […]
