I am developing an Access application using Access 2010 running under Windows 7. The database has some large tables containing many thousands of rows. I want to display the number of rows in these tables in a form.
I have tried a couple of methods to do this, both of which work fine except that they take several seconds to run. One method is to use DCount; the other method is to create a recordset and access its RecordCount property....
Gordon Padwick
Last Activity: Jul 17 '11, 11:10 PM
Joined: Oct 15 '10
Location:
-
How to display the number of rows in a table?
-
Why won't Microsoft Windows 7 Upgrade Advisor Work?
I'm getting ready to upgrade from Windows Vista to Windows 7. I downloaded and installed the Windows 7 Upgrade Advisor. When I tried to run it, I received the message "Windows 7 Upgrade Advisor was unable to reach the Microsoft server for compatibility information. Check your internet connection and try again later."
My internet connection is okay -- I'm able to access bytes.com. I tried to run the Upgrade Advisor several times with... -
How can I control what is displayed by a combo box selection?
I have a combo box in Access 2003 that contains three columns from a table. The combo box correctly lists the contents of those three columns. I have one column specified as the bound column, so when I select a row in the combo box’s list, the combo box displays just that the information in the one bound column. Instead, I would like the combo box to display the concatenated values of the three columns. Is there a way to do that?
... -
How to select Records in an Access Subform from a Combo Box
A form contains controls, one or more of which can be other forms. A form that contains another form is known as a main form. A form contained by a main form is known as a subform. A subform itself can contain other forms, sometimes known as subsubforms. This article deals only with main forms and their immediate subforms.
The books about Access I’ve read contain some useful information about subforms, but don’t adequately...Last edited by MMcCarthy; Oct 28 '10, 09:43 AM. Reason: Moved to Insights section and added code and formatting tags -
How to refer to a subform's properties from a main form
I’m still having a problem with using a combo box in a main form to select records to be displayed in a subform. I’ve tried code suggested in several sources, but it doesn’t work.
In “Filter records based on a combo box selection in Access 2004/XP/2000/97,” Microsoft provides an example of a database that has two forms: frmCustomers (main form) and frmCustomers_su b (subform). Microsoft suggests this code for a... -
Thanks for the two suggestions.
I don't quite understand what Nic is suggesting, perhaps he can elaborate.
I assume he is referring to the Forms Wizard. When using that wizard, the new form/subform doesn't appear until I click Finish in the wizard, so how can I add a combo box while the wizard is still open?
Also, Nic refers to the "last option to search for a value." I don't see such an option in the forms wizard....
No activity results to display
Leave a comment: