Recent content by jtp607

I am new to access, and am having trouble creating a form. I need the form to reference 1 sql table for name, rank, assignment, etc, in order to display on the form and not update, and then on a sub form to update certifications, certification dates, expire dates etc on a different sql table...

Here is the jpeg that you asked for. The equipment is the LifePacks, Stretchers and Toughbooks. The equipment locations are the Rescues or Engines. I am using a form that control source is the Repairs table. I hope this makes sense, thanks again for any help.

I have an inventory of equipment that is assigned to different locations. When repair is needed, the equipment is brought in and swapped with a loaner. How can I update on a form the location change from "A" to "Shop" that will show up on the related equipment table? I have "Location" in the...

Pat, got it worked out. Thank you to you and Plog for all of your assistance.

Hi Pat, Tried just what you said, used the option #1 in the join fields. Here is the screen shot. Thanks.

Thanks Pat, just tried that. It failed due to key violations. In the update query, I am pointing from the email source table to the employee destination table, using the employee# pk. Joined properties #3 all records from source to equal fields in destination. It isn't working. I am...

Okay, then by those terms I am updating, because I am taking a blank field and adding data. I just tried an update query, and am obviously doing it wrong. Please help, thanks.

I was given the email addresses after the fact of setting up the database, so therefore it is a new field with no existing data in an existing database. As I understand it, then I must then append the data, because updating requires the change of existing data, which in this case, there is...

I have tried joining on the email field, and it doesn't work. In looking at the employee table the email field is empty. When an append query has run before, I went from 900 records to 1800. It just added 900 new records and did not append to the existing. Thanks for your time.

Hi, I am trying to add a new email field to my existing database of 900 employees. I have imported an excel worksheet of email addresses into a new table that has lastname, firstname, employee#, email. The primary key on the new table is email. The primary key on the employee table is employee#...

Thanks for the help, that worked out.

I am new to access. Is there a way of creating 2 or 3 formatted report templates? I have 3 or 4 separate monthly reports that have to be done from queries. I have not found a way of saving the formatting for the reports. Everytime I run the query, I have to spend an extra 10 minutes to...

Hi All, this is jtp607 from Texas. I am new to access and teaching myself as I go. I have been tasked at the fire department to be able to come up with a database to track numerous categories of things. I am now have 3 separate databases going and just trying to keep up.