For design simplicity, all of my lookup tables have two fields, an autonum for the primary key and text field for the value. Example: tblPriority PriorityID:...

Accounting packages like Quickbooks allow the item descriptions to be edited once place in an invoice. For example, assume the following Invoice: Invoice...

Is there a template or shareware project that supports something similar to the Outlook calendar using Access? Best, Christopher

I understand the importance if identifying all table relationships during the database design phase for the purpose of good design, but what is the purpose of...

My database is separated into FE and BE. All tables are in the BE. I had been assuming that the relationships were stored with the tables in the BE, but I...

What is the recommended technique to determine if any records of a table have been modified or added in a multi-user database since the last tick of a Timer...

When I close/open the relationship diagram, Access redraws all the tables and links. The Access version has orphaned tables, criss-crossed links, etc. My...

Don't know why, but all of the Relationships in my database are missing. A review of backup files shows they were present until 4/5 and have been missing since...

I firmly believe a popular Access database template would be one for employee tracking of training. I would greatly appreciate a database where I could use to...

My database is designed to store information regarding the valuation of plant and machinery. There is a transaction table that contains specific...

Dear friends I would like to find the first and the last element of a record in a table. Is there any possibility especially if yoy have not promary...

I have a couple of questions, both relating to the same database. 1. The database I'm working on includes tblInternetSpecs with a field strFormat. The user...

Hello, I have been trying to set up a good Normalized database and need someone to help me set up forms. What I am setting up is a training database. I...

I want to create a database (in access or excel) of organisations that my organisation intends working with. I designed a template/form for details of those...

My switchboard page which presents to users has button controls which link to sub pages in switchboard. Design view only gives access to the default page. If...

At one time I entered a 0 as the default value of a field in a table. I later wanted to change it, so that the default would be blank. It seems that no...

Where is the SetValue Action in Access 2007? When I try to create a macro the action is absent. Is there a way around this? -- Thanks, Chuck

Hello, I am looking to make a database to help me manage 20 managers that report to me. I want something where I can click on a location and it will allow...

I have 2 tables with the same fields. How can I move the records from one table to the other?