I have transaction table where the rows entered into the transaction can come a result of changes that take place if four different tables. So the situation is...

i am trying to generate uniquie numbers for a bunch of PC ID's. These numbers should be based on a few variables like location state, city. Any help?

I have 2 tables. Table1 contains field 'Streetname' field 'town' and field 'postcode'. Table2 contains customer details including addresses. How can I use...

How can you change which number your autonumber starts at, its also my primary key but i want to start a number range from 7000000 then have the database count...

I would appreciate guidance on how to proceed with this design. My skills level with Access 03 is between beginner and intermediate depending on what task I...

I want to track each bank transaction from the bank statements I receive. Is there any standard procedure for this, given that if I present a figure from...

Hi: I have design a Query and Form trying to get an Item Number, his description and different type of Requirements for the same number. I don't have problem...

Hello all, I am trying to design a database to store the information of our clients. I would like to get some inputs from you guys on the design. Also...

I need to add a field to enter a date. This date should stay constant after entered.

Access help says Yes/No format displays checkboxes on controls, but how do you get it in datasheet view? It's possible because I have some that...

I was wondering if there was a way to create a validation rule for a table field for this situation? I want to be able to validate and make sure that the Name...

Good morning, We have 5 departments in our company, and we track the jobs of those departments so that the upper management can see what is going on. This is...

I have to design a DB which contains a parts table with components as records and tables which contain information about these components. Now, the different...

I am having a situation where users are entering data that the primary key should prevent. However instead of stopping the entry, the primary key and the one...

I created an Access project and added 7600 records to the table. The size of the data base did not increase, indicating that the data is definitely...

In repairing a database, I have imported all tables into a new blank database, without relationships. The intent is to re-establish the refrential integrity...

I not sure how to setup the following fields in my table and also when I create the form for the users to input the necessary information: Employment (check...

I am new to Databases. I want to create a data base which will have a lot of information which is related to monthy figures. I have a number of tables that...

Hello, I was wondering if you could help me. I am a a brand new user of accsess and am having to design a database for some coursework. Basically, one of the...

I have a database that I have inherited. There are 3 main tables from where data is pulled. The information from these tables has got to a point where there...