Sort: Rank

Creating Relationships among Tables
In my MS Access 2000 database, I have 4 tables: Bank, Client, Account, and Transaction. How to build relationships among those tables? This tutorial shows you how to create 3 relationships: Bank.id = Account.bank_id Linking an account to a Bank record. Client.id = Account.client_id Linking an ac...
2014-12-31, 6358👍, 1💬

💬 2014-12-31 mac: didn't really explain the relationship reasoning at all. I'm not sure there is an easy answer by the way, took me years to truly...

"Lenovo Keyboard Noise Reduction - TPKNRSVC.exe" Service on Windows 7
What is "Lenovo Keyboard Noise Reduction" in my Windows 7 service list? And how is "Lenovo Keyboard Noise Reduction" service related to TPKNRSVC.exe? "Lenovo Keyboard Noise Reduction" is a service provided by TPKNRSVC.exe EXE file. Detailed information on "Lenovo Keyboard Noise Reduction" service: S...
2012-04-24, 8728👍, 0💬

Generating a Standard Report
I have a table with many record in a MS Access table. How do I create a report to list all records in the table? Assuming that you have a table called Transaction in MS Access 2000 with these fields: id - AutoNumber: The primary key giving an unique ID for each transaction. trans_date Date/Time: T...
2010-04-10, 5518👍, 0💬

Getting #Name? In a Form Field
Why am I getting #Name? in a form field? If you open a form and see #Name? in a form field, it means that the Control Source of this field is linked to a non-existing column on the underlying table. The main reason is that you probably modified the underlying table structure by renaming or dele...
2010-04-10, 6088👍, 0💬

Creating a Standard Tabular Form
Using Columnar as the layout for a form as shown in the previous tutorial is good to enter new records or editing existing records. But the columnar layout only shows one record at a time. It is not convenient for browsing records or comparing records. So how to create a form to edit multiple rows a...
2010-04-10, 11133👍, 0💬

Using Combo Box with Table Rows in Form
I have a field in a MS Access form that is a foreign key pointing to another table. Can I use a combo box for this field? Yes. You can. This tutorial shows you how to add a combo box with rows from a reference table and bind it to a column in the supporting table in MS Access 2000. Another problem i...
2010-04-10, 8490👍, 0💬

Using Combo Box with a Value List in Form
I have a field in a MS Access form that takes only two possible values. Can I use a combo box for this field? Yes. You can. This tutorial shows you how to add a combo box with a value list and bind it to a column in the supporting table in MS Access 2000. In the standard Account Form created by the ...
2010-04-10, 7502👍, 0💬

Using Multiple Selections in Form Design
In MS Access form design, can I select multiple fields and modify their properties simultaneously? Yes. You can. This tutorial shows you how to use multiple selection in Form Design to modify the Text Align property of all field labels in MS Access 2000. Usually, the standard form created by the for...
2010-04-10, 7892👍, 0💬

Creating a Standard Columnar Form
I have created a table in MS Access. How do I create a form to help enter data into the table? Assuming you have a table in MS Access called Account with these columns: id - AutoNumber: The primary key giving of each account. client_id - Number: A foreign key pointing to the Client table. bank_id - ...
2010-04-10, 10390👍, 0💬

  Sort: Rank