Search results

After completing all aspects of my database, I moved on to creating queries/reports/forms for reporting purposes for my executive team. In creating queries/reports I discovered I made an error in using a combo box on a form for data entry where I should have used a table and based the form on a...

I am combining forms and queries to make my DB more user friendly. Everything was working on the forms until I tried the export button. How do figure out what is going wonky on this code? Thanks! Kristen

I would like to revamp some of my queries. On the old front end I have a form that with drop down boxes that gives ranges for the user in order to generate reports. There are two separate queries/forms that I use because I don't know how to set it up so it will choose just one or choose all...

I have a query that I created that I'm using for a form and a report. The first time I tried it, it did what it was supposed to do. Now, it does not bring up any records. What did I do wrong? Here is the query: SELECT tblEmp.EmployeeID, tblEmp.EmployeeName, tblEmpCert.CertID...

I am trying to use a join query to join two tables in order to create a form. I have done this on two other occasions in my database with no issues. Now it is only pulling the ID and I want it to pull the description. I have looked at the SQL view for the other queries that are similar as...

I am on my last piece for my database and I am having the most trouble with this last piece. What I have created is a database which tracks employee skill levels, OSHA and state licenses. The last part of the database is the certifications that an employee may or may not hold. And here is...

I am working on creating a query to base a form on. I've done it several times in this database, but today, for some reason I cannot figure out how to do it. I believe this is how I did it before but it looks like the SQL statement got wonky: SELECT tblEmpInfo.EmpInfoID, tblEmpInfo.EmpIDFK...

I am adding another portion to my database and since this is a little different than the other parts I created, I wanted to get some input from the experts. I am adding Certifications to my database. I am currently tracking skills, OSHA, & Licenses for all employees. My current count for the...

I created a query for my database to track licenses for my employees. My questions is I want to see on the query/report exactly which licenses are out of date and going to be out of date in the next month. Ideally, I would like to have the out of date licenses show up in red and the going out...

I am looking to link two tables as I would like to have reports generated with info from those two tables. tblEmpInfo EmpInfoID <PK> EmpIDFK <FK> Jobsite<FK> tblEmpRating EmpRatingID <PK> EmpIDFK <FK> EffectiveDate SuperID CraftCode StatusChange What I would like to do is have those two...

I am coming along with my Employee tracking database, much thanks to you all in the beginning. I have done some tweaking and working around somethings and now I have run into a brick wall on this latest tweakage. I am looking to create a report that tracks the current job site of the...

I currently have a VB statement written for a pop up form based on a main form. I would like to change it so it is based off of a subform and somehow tie those tables together. I'm not sure how that would work seeing as I'd have to go back and match up everything since July when I modified the...

I created a junction table in order to create a many-to-many relationship between two tables. My question is this: Do I run an update query in order to populate the information from the two primary keys (which are the foreign keys in the junction table) in the tables? Basically I took...

In my database, I have a table that is used as join table for a many to many relationship. I am having trouble using that table in queries in order to use the most recent information entered in there. For example, the table stores the emp ID and the Job Number where the employee is working...

I just updated a table in my database and now anytime I go to change the work status field Access says Microsoft Access has stopped working and then shuts down and restarts and wants to save a back up. I did the same exact process to update the table in a test environment, basically a backed up...

I am currently re-working my database and have updated a few tables, deleted a duplicate fields from tables. I currently have a pop up form that has some code behind it. I also changed a few things in the table (deleting the duplicate fields). So in tblEmpJobs there is no longer a field for...

I am appending a field from one table to another and it will not work. It is telling me that it either has violations or duplicate output destination. When I run it through as a Select Query the information is correct, but as soon as I make it an Append Query it will not work. INSERT INTO...

I have created an employee tracking database that tracks, skill inventories, licensing, certifications, and safety training. After adding tables and different reports and forms for tracking what management wanted, I realized that the database needs reworking. I have to tables that carry...

Hello All, I had created a database a number of months back and received wonderful advice and constructive criticism from you. After getting halfway through and seeing some requests come through from management on what they want to see or improvements, it looks as though there will have to be...

I have a pop up form in my database that is used when it meets a certain criteria. The issue I am having with this form is I cannot go through the records. For example, if I want to see how many jobs a person has been on, the form will not allow me in the record navigation to go through the...