Tables

Employee Training Help
It sounds like both Employee and Training are one to many with Completed Training However since you might want to tracj scheduled training (not yet complete) you might want to rename the third table and have an date for completion which can be set or unset. -- Dorian "Give someone a fish and they eat for a day... 27 May 2010 18:11

SAVING REPORTS "SAVE AS"
Hi All. I have created a standard report as a type of template. Users can access this report in layout view and change label captions, positions of fields etc. But when they save the report I do not want them to over-write the template, they must 'Save As' to a new report name. 1 How can I enforce this? 2 How c... 27 May 2010 18:11

Auto Increment by 1 Letter
Simple question, hope I can get an answer.... Ok, I have created a table and form for our company to keep track of incoming inventory. Being that we work with metals, each piece that comes in is assigned a unique 3 letter value. We started with AAA. What I need to know is once I enter the item we are receiv... 27 May 2010 18:11

2 Designers
All, how would you handle having two persons who work on creating/designing/editing a DB? TIA FYI I'm not in this situation but just in case. ... 1 Jun 2010 10:52

Populate a new field in an existing table
Hi all Access 2003: I have an existing Access table, containing 10,000+ rows called "Printing" and I have decided to insert a new column called "Financial Year". However, I am struggling of finding a way to instantly populate this field with the value "2009-10", without going into each row (I have three mo... 27 May 2010 17:04

Populate a new field in an existing table
Write a query to do an insert into that column for each row... Update MyTable Set [Financial Year] = "2009-10" Where [Financial Year] IS NULL; By the way, I strongly advise against using any column name with an embedded space. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and ... 28 May 2010 10:27

Auto Increment by 1 Letter
Sorry, I was assuming you knew how to write Access code. You will need to create a VB function to perform this task. I don't have much time now as I have to go to a meeting, look for a response in around an hour unless someone else chimes in first... -- Dorian "Give someone a fish and they eat for a day; teach ... 27 May 2010 17:04

Need help with table set-up and Thanks!
Hi Karl, You've answered a bulk of my questions so a special thanks to you. I sure appreciate all the contributions you make. You're always helping everyone out. project number in my data table will be truncated. I know that it will be impossible to establish referential integrity Use an Autonumber... 27 May 2010 17:04

how to set a certain format
I have what I believe to be a very simple problem for all of you who know Access better than me. I am using Access 2007 and have a field in my table where an operator would enter a job number. I want to force them to use a certain number/text format to insure continuity. Here is a sample of what some of the job ... 25 May 2010 22:22

Trying to Siplify a Query in MS Access 2003
I am a real Novice to MS Access 2003. I am trying to create a query to populate a form to be used as a subform in another form. I have created the form that use a table view of the a table. But would like to be able to use text boxes to view the data. I do not know if I should change the table designs that I am... 25 May 2010 12:26