Search results

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...

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...

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#...

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.