Search results

I have a table that is set up as a pop up modal form based on a status. In one practice db I have the table works fine it collects the data. The other practice db I have set up in the exact same way, each time the table pops up the data that was previously in there and then overwrites it. The...

I've gone through and done a side by side comparison and found the only difference so far is the event procedures for the from one is on load and the other is after update but when I click on the ellipses (...) it brings me to the VB screen but no code. Is there something that should be there...

Both forms are the same I have checked all their properties. The code is the same for both pop up forms. Once I get this query working for the Practice2 db I can go live with this portion as well. Please help!!!!!

Can someone please take a look at the 2 databases and the queries qryOSHAbyJob in the one database and qryOSHAJob in the other database? One will return the data I want and the other one only returns the last record entered. I will attach the db's. I am working in A2007. Thank you!!

Here is the compressed version. It is actually doing the opposite it is visible if the employee is NOT active now. Thank you for taking a look at it!

I am in the process of getting the data in as I had another project come up yesterday so I had to put this one on hold. I have both forms ready for entry BUT I can't get the form to pop up with the Active status. I put it as a Subform on the Main form but when i go to the next record or find...

Thank you!! I think I understand!

Yes, I have 7 unbound combo boxes that tie back to the query in order to run the report. So 6 out of the 7 combo boxes (Emp Status, craft codes, skills and ratings) need to be filled out.

I have a form that uses a query to run reports. Is there an operation for a button to clear the form? When it starts the wizard there is no option for clearing the data, just refreshing. They are all unbound combo boxes that I have in the form. I don't need to save any records as this form...

I have a form that is based off a query with combo boxes in order to choose what data is pulled. I would like one of the combo boxes (for superintendents) to not have to have information in it so it will pull everything all the info OR be able to choose a specific superintendent. I looked on...

That worked...now I'm working on fixing the keying mistakes. Thank you!!

The PK for tblSuperintendent is SuptID and the PK for tblEmpRating is EmpRatingID. I have attached the relationships report. Thank you!

It is all the same information so they should match. They are both number fields using their ID's so for example 5841 is in the tblEmpRating under SuptID already and I put it in the tblSuperintendent under SuperIDPK as 5841 and it is like that for all the ID's. That is where I pulled the info...

I am currently working in A2007 and am tinkering with my db with help from other forum members here and I was implementing some of the suggestions. I added a table to the db to hold look up data and when I went into the the relationships to drag and drop to create the relationship it pops up an...

Yes, I'm sorry I misspoke. I will work on getting sample data into the db tonight and tomorrow and post tomorrow once it is complete. Thank you thank you!!!!

I think I get that. When I create the form, under the property sheet on the OnCurrent and AfterUpdate rows is where I would put the code in order to make it visible based on EmpStatus.

For all reporting, it will only matter who is currently working. When they are rehired, laid off, etc. is tracked through the Skill Assessment tab. Once an employee is marked No Rehire, down the road once I get the database up and running I would like to export those employees to an "archived...

Ok, because what I have been doing currently is just changing the status so it overwrites what was previously there. SO this is NOT a good practice? I have that stored in tblOSHA in the field Document. Same thing I was going to overwrite that data as I really don't want to track when they...

Yes, I started it at the table level then removed it so it is only on the form at the moment. There are 4 statuses to choose from: Active, Eligible, No Rehire and Disability. I only want a form to pop up with Active is this is what will drive the report I am looking to do. I will attach it...