denise boutte lamman rucker dating - Updating tables in access

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions.

updating tables in access-11

There are circumstances where storing a calculated result makes sense - typically where you need the flexibility to store a different value sometimes.

Say you charge a construction fee that is normally an additional 10%, but to win some quotes you may want to waive the fee. In this case it makes perfect sense to have a record where the fee is $0 instead of 10%, so you must store this as a field in the table.

Don’t do massive update queries using Access If you ever need to update a lot of records at once, say, increase pricing on all items by 10%, you’re much better off doing the update via a pass-thru query or on the server directly. Limiting data to just a fraction of records at any given time.

Don’t load more data than you need to I’ve bounded forms to tables with several million records with no problem, how? Here’s how: Say you have a table of customers called tbl Customers and that the primary key is Customer ID, to load just one customer in your frm Customers form you would use the following syntax: Where lng Customer ID is a variable holding the Customer ID you wish to see.

To achieve this, use the After Update event of the controls on your form to automatically calculate the fee: Now whenever the Quantity or Unit Price changes, Access automatically calculates the new fee, but the user can override the calculation and enter a different fee when necessary.

If you are concerned about how a user could enter the calculated total with this arrangement, see Enter text in calculated controls.Alias ID is the primary key and is also autonumbered.Product ID is linked to the Product ID field in the Products table in a one to many relationship.My database uses a form to add, edit and delete records from a table called Products.There are two fields in this table, Product ID and Product Name.Never store a value that is dependent on other fields: it's a basic rule of normalization.

Tags: , ,