Search results

I made an OOPS!! Everything is supposed to relate back to tblEmp as everything is pulled off their Employee ID The tblOSHA is SUPPOSED to be related to tblEmp. I fixed that so now those tables are related and it is allowing me to enter and save the information. I fixed the relationships and...

It happens after I enter the information into the subform and go to move to a new record in the OSHA subform tab. The record source of the main form is tblEmp. For the subform it is tblOSHA, tblEmpInfo and tblJobs. I have uploaded the relationship report. I can post a zipped copy of the...

Ok, because the way the tables are set up now, it will not allow me to add or change a record because a related record is required in another table. I can do the form/subform (although I don't want a datasheet for this info) but can I make it dependent on the Main form? I attached a snapshot...

That's where I'm having trouble. I have the info in the one form based off the one table but there is no data in the other tables as I have not figured out the most logical way to put it there. I was thinking a report based off of a query because the data will change week to week as the...

I have a main form and there will be 4 sub forms. I have the first portion updated and it has already been out for testing for 2 months. The second portion is I thought would be easier as there is not much to track essentially. It is one table which would be the subform and it is related to...

The form is for data entry, it has 4 tables that it will be using. I think. Two of the tables are only filled out if a certain criteria was met. But I was thinking of using that form in a report. Having a pop up modal form.

If I am creating a form, is it better to do it from a query or tables? I fixed the form that needed updating, I scrapped the other form completely and am starting from scratch. Most of my other forms are built off of tables but I'm wondering since this form for this portion of the db, the...

Thank you!! Got it! :)

If I have a form that I am entering data in and I update the tables so now the data is still there but I have a look up table for Supervisors do I just do the change on the form level?

Ok, I understand. As long as the EmpID is in both tables it should be able to pull the info needed. I have attached the Excel Report that I am currently using but would like to be able to pull from Access once the data is entered. It doesn't necessarily have to look like this but it should...

I really like what you did...and understand it a little better. The tables make a little bit more sense than before. I did however change some of the tables only because I really think the tblOSHA and tblEmpInfo need to be related somehow. I created a junction table but still kept tblOSHA...

I am having a minor brain issue. I have created a search form for the first portion of my database, but right now, no matter how long I look at it I cannot comprehend how I got from beginning to end with the forms. I am looking to create 2 more search forms. One is a little one, I just want...

Thank you! For tblOSHA, I am tracking their OSHA training. Since it is the nature of our industry (construction) to have employees be laid off and rehired due to the work of the projects, some projects may require OSHA training. So as a company, we made it a prerequisite to have the OSHA 10...

Thank you! That is exactly the question I was trying to get to. :) They are relatively short lists (3 max) and will likely never change unless the federal government decides to change up documents and hours and don't really think they have in the past 40 years since OSHA came into existence...

Sorry, I meant Look Up tables versus using the Value List and Row Source in the tables. I have 3 fields that have a "list" of options and I was trying to determine which would be the better way to go, using additional tables or using the Value list in the table.

Is it more advisable to have look up tables rather than combo boxes on a table/form? Would it make it easier for reporting purposes to have a look up table? Thank you!!

I think that was an AHA moment for me! I think I'm more frustrated since this portion seemed to be a bit easier than the last one. But thank you so much for helping me out with this. I will be doing some research on pop up forms and some tutorials tomorrow. :)

Thank you so so so much!! Ok I think I'm getting it. So that form would then generate the information based off the EmpStatus and only pull up those employees that have that status and somehow link that to the OSHA info as well and then fill out the info as needed. The first entry would...

Yes, that is still the most current version of the database. The back up I have right now has no data or tables in it at the moment. I have no problem waiting. I am doing tutorials right now on VB for Access as I know the rest of the database will require more and more coding. :) Ok, I...

Two weeks. I figured I would need to redesign the tables and relationships as no matter what I did in the current design I was getting errors. The thing that is tripping me up is the two tables that are only needed for a certain portion of employees (tblEmpInfo & tblJobs). In the current db...