Recent content by CancerStick

Thanks that worked. Now, how do I get the tab to go from the last record of one page to the first record of the following page?

When a user is inputing information into my form, I don't want the record to be saved until the save button is pressed. It seems the records automatically save once I tab through all the fields. And does anyone know how to tab to the next tab control once you reached the last field in a page...

Code seems to work... I finally got the button to work without giving me an error. Thing is after hitting the search button, the result does not show up. How do I get this to work properly!!! here's my code Private Sub cmdGetID_Click() Dim strFullName As String Dim EmpRef As String...

I'm trying to build a code that lets the user enter an employee's last name and first name to retrieve the employee's ID. I'm using a lookup form for the application so when the user enters information on a write up or equipment issue, and they need to assign the information to an employee's ID...

You're right okay, that was a bad example. I realize that emergency contact info should be on the same table as employee info. But how would you populate a secondary table's related field (i.e. employee ID) when filling out a form for a primary table when the related field is the primary key...

I have an employee data form that uses two different tables. All the employee info gets entered by using the form and it goes to the employee info table. On the same form, info is entered for emergency contact info, it is entered into an emergency contact table. My problem is, both tables are...

Thanks, that is what I was thinking. I was just going through a manual and the normilazing chapter was followed by a chapter on queries and thought maybe I should check before I continued. Thanks for the help

I've normalized my database, I've built relationship with the different tables, I'm trying to figure out my next step. I haven't populated the database yet. Should that be my next step or can should I build my forms and quereys first? If so, which should I do first?

It is a single type of certification with a license number, issue date, and expiration date. The reason that I have it as a seperate table, is because not all our employees have this cert. In normalization, I understand you're not suppose to have blank fields, so I made a seperate table.

I have a database with several different tables pertaining to Employee Data. I am using certain tables for information on selected employees. Such as, out of 100 employees, 80 of them have a specific certification. I've built a seperate table for basic employee information, and a seperate table...

Thanks for the critique, appreciate it

I'm about to create a new database for my company. I have thought it out and planned how I want everything to work. I just want to run it by somebody and see if everything seems okay or if I need to rethink my strategy. The database is an employee database and I'm creating it for employee...