Search results

If you mean on the Visual Basic tab, then yes. Otherwise I'm not sure what module that would be.

It highlights the Private Sub line on both forms. I do have this code on two forms as that was the advice given to me. So I have it on the main form EmployeeEntry as well as the subform frmOSHATraining on both the OnCurrent and After_Update lines.

It turns red sometimes depending on what I change or it highlights it yellow with an arrow. I don't know what the WITH block is. I am learning this all on my own with the help of this forum and Google! Thank you!!

I had help with a code in order to help with the entry of a form by "graying out" certain boxes unless a criteria was met. When I put the code in it errors out and says "the expression OnCurrent you entered as the event property setting prduced the following error: Return without GoSub, The...

Sorry it has taken me so long to respond. I had to switch over to another project. As far as the craft code I am only concerned with the most current one in the OSHA tab. The skills tab it is tied to each inventory. Same thing with the jobs, I just need to know the current job they are on...

What would be the best practice for creating a form based off of 3 tables? Using the form wizard or creating by dragging and dropping the fields that are needed?

I have attached the relationship report for my database. It has taken me a week to finally normalize correctly, at least I think, the tables for the 2nd portion of my database. What I am trying to do with the second portion is track which training employees have had and the date they trained...

By that I meant federally sponsored health-care. I did a quick search and the reform affects private employers. The military along with the government is a public employer.

I will have to re-read the HCRA but I don't believe Tri-Care is going away for active or retired military personnel because that would mean Congress would be throwing themselves in the same pool. This was covered in a health care seminar that I attended.

How do you feel you will lose your insurance? Once you hit the age of 62, you are eligible for medicare, but since medicare simply does not cover everything and has limits on how many times you can be sick, you then have to find other coverage that is out of pocket. My father in law has...

The privatized Health Insurance as it stands now is unsustainable for both employees and employers. Having worked in Human Resources and working with benefits, the cost is outrageous especially depending on the industry you are in. I have been in the heavy construction industry for a several...

Thank you so much for your help!! I really appreciate it!!

Thank you!! And this will find it even attached to the subforms? So if I want to find an employee in the Skills, all I have to do is find it in that box and it will come up on both forms? I will work on the design of the form. I tried using a query behind the form but then it would not do...

How should I redesign the form? I thought originally when I set up the "Find" button it was unbound, but I wanted it to search only on the EmployeeID.

Employee Entry is the Mainform with all the tabbed subforms. So if you go in there and click on the Find Employee button in the OSHA tab, it will error. But if you are on the Skills Inventory tab it will work. There is no sensitive data in the database, just ratings and training dates. :)

Here is the A2003 version.

Here is the A2007 version. Thank you.

I am working in A2007 do you need me to save it as an earlier version?

I set it up through the wizard and the only macro I have in the db is the Auto FE updater.

No, there is not. But it does work on the first subform on both the live and the backup db. It's the second form that causing the problem, I think and I'm not sure why. Because I can use the button on that first tabbed subform and I can find all the employees but when I go to the second tab...