Search results

This is from a previous back up but this will give you a general idea of what I am looking to do in the form. But instead of the yes/no field I was going to do a combo box. When I enter the data if on the mainform above the tabs that status is active the form will require me to fill out all...

That is exactly what I was thinking too, since tblEmpInfo is dependent on that EmpStatus if I should have it linked there too. There are 4 stati that an employee can have: Active, Eligible, No Rehire and Disability. The only reason I am using it in this table is to have that report pull...

1. For every Employeein tblEmployee, how many records can they have in tblOSHA? You've said it has to be 1, but could it be more? They can have multiple records. 2. For every Employeein tblEmployee, how many records can they have in tblEmployeeInfo? You've stated it could be 0, but could it...

I have a post in the Forms section that relates to this post but I have not received any replies as of yet. As I was thinking about the form and having redone the tables I want to make sure the table design is normalized. I have 3 tables for this sub form which ties back to the Main form PK...

Can some one help me PLEASE??

For entry for a tabbed subform that is based off of 2 tables and a lookup table, would it be better to create the form based off a query? I have code behind the form because one table will only be filled out if it meets certain criteria based on the main form but it keeps erroring because if...

SELECT [tblOSHA].[OSHAID], [tblOSHA].[EmployeeID], [tblOSHA].[Osha10Hour], [tblOSHA].[TrainingDate], [tblOSHA].[Document], [tblOSHA].[Osha30Hour], [tblOSHA].[TrainingDate1], [tblOSHA].[Document1], [tblEmpInfo].[EmployeeInfoID], [tblEmpInfo].[EmployeeType], [tblEmpInfo].[CraftCode]...

I have been working on this and I finally got it to add a record by adding : Option Compare Database Option Explicit But once I do that it doesn't run the SetCntrlProperties so all the fields are enabled and therefore setting up the error that it can't find a record in the tblJobs with a key...

When I went in to take a look at the code it is highlighting this : and telling me there is a compile error.

It is actually a combination of 2 tables and a look up table. So tblOSHA must be filled out and then tblEmployeeInfo should be filled out if on the Main Form the EmploymentStatus is "Active"

I changed my tables around in my db so they make a bit more sense then created a form for entry. I have added the following code to the form as one of the tables only needs to be filled out if certain criteria are met. Private Sub Form_AfterUpdate() Call SetCntrlProperties End Sub Private...

Thank you! Although I don't quite understand how you did that. I think, now that you mention it, that my tables will have to be changed. The tricky part to this portion of the database is the only information that will always be filled out is the OSHATraining, with the exception when an...

No it does not...I copied it from another post that I had put up.

What I would like to see happen is on the OSHA tab is: If in the Main Form (EmployeeEntry) the Employment Status is either Eligible or No Rehire or Disability then I want the following fields "grayed out" in the OSHA tab: EmployeeType, CraftCode, JobNumber and JobSite. If in the the Main Form...

I copied and pasted the code from the database that was reposted but now I am getting 3 errors. I checked, double checked and triple checked to make sure I have the code where it needs to be and it is where it supposed to be. The 3 errors I keep getting are: The expression On Current you...

Also it keeps giving me a compile error again...not sure why.

It is still giving me an error with the Job Number telling me it needs information in there.

I'm sorry it is EmployeeEntry and then the tab form that I am having an issue with is frmOSHATraining.

Here is a stripped down version of the db. Thank you!!

No there is no Module for that code. I just have my export module there.