No need to. Just have primary key in main form and use a subform for data entry. "TURNIP" wrote: I have created a database with a few tables which are...

Where would I find a simple stock control template -- Thanks Ken

I have downloaded the template for access that is for ordering. I like the way it is set up, but I need it to do some more stuff in a way and cannot rem. how...

Where does tbl_MIGWorkorder come from? Or did I miss something? "Ross" wrote: Hi, I posted this to the querydesign group and was told I may have a ...

I have created a database with a few tables which are mainly one to many relationships with a primary key in one table and a foreign key in another table...

I need to change a text field that has values ranging from 0,1,2,3, and T. It is easy to use find and replace to change the T to 0.25. However, access strips...

We have recently upgraded to office 2003 from 2000 and I have an access database - that was created in 2000 that I am trying to merge with word 2003 When i...

i need to set up a report based on the user selecting (from a select list) one or more options from the same field - ie 'Enter Licensor/s Required' and have...

I work for a company that owns a bunch of equipment. Things like compactors, dozers, excavators, graders, loaders, scrapers, etc. Each of these pieces...

Due to a recent "phantom compiler-error" diagnosis of a "user-defined type not defined" error message, I had to re-create my mdb by creating a new db and then...

Hi, I am new to access and trying to set up a database, basically I want to store a customer with details including address,contact details etc and then I have...

Hi everyone I use Access 2003 and have seen several sample databases which have at least one table with multiple keys. I understand that there can be only...

Aside from the query/table definition conflicts and the lack of relevant foreign keys, you need to understand that when the table design is finalized, you are...

Greetings, Real noob here trying to use Access with SQL Server. I have a local access database and want to use it with the SQL Server. What I did was...

I am new to access and I am working on a project for work. My problem is that I have two table. The first table is labeled LeadProjectManager and the second...

WE have a old system @ work that drives me nuts, I have to write a order by hand and then enter the info manualy into a PO register in Excel and again into its...

Hello; I hope someone can possibly point me in the right direction. I thought this forum might have a member that can point me to a pre-made Access database...

When I signed up for instant messenger and Microsoft send me an email verifiying my sign in; I accidently deleted the email and not I keep getting the message...

I would like to be able to bring up and entry in access and click on a link to a word document and have that word document open up in word. How can I do this...

Hello, I'm trying to help my office manager replace her existing flatfile database with Access. Currently she uses an old program called Q&A which is all...