Recent content by Deavyin

The unique identifier is something I am working on with HR right now. They have been using spreadsheets for years now so the number system they use, as dumb as it is, is engrained and they are not too keen on changing it. I've expressed how important it is, from a DBA standpoint, that the...

every employee, per company, is assigned an employee ID. It's a completely numerical value. Unfortunately, since we have 5 different companies and employees are split amongst them, more than one employee can have the same employee ID. I've been trying to convince HR to use company name then...

Hey jdraw, I really have to leave the office right now, but i'll try and do that when I get in tomorrow (can't take the dba home..company is weird like that). I do have relationships established currently. Both the Absence and Discipline tables are joined to the Employee table in a...

Alright, I got it to work. I'm still using the Insert query to append to the discipline table and I am still using the unbound fields since each employee can have multiple discipline entries and we need to keep a history of them. Also, and I know it's not a good way of doing things, my company...

Wow...I'll just look past the rudeness. You can feel free to just not answer my posts if you can't do so in a constructive manner. Having said that, I get your points and will update accordingly. However, what is the issue with the 'numerated' field names? These are actual follow up dates...

Not all of the fields on the form are bound as they are entered by HR while the Discipline form is open. The First Name, Last Name, Employee ID fields are bound to an Employee table and are automatically populated when the discipline form is opened from the general employee form that has an...

Not all of the fields on the form are bound as they are entered by HR while the Discipline form is open. The First Name, Last Name, Employee ID forms are bound to a Employee table and are automatically populated when the discipline form is opened from the general employee form that has an...

Thanks for responding. I have checked that and made sure that the fields I don't want to be required (namely the date fields) are set to false for required and yet, unless I put everything in, I get that error message. I assumed it had something to do with the way i'm using the Me. command to...

Hey Guys. New to the forum here and I have a question on something I am programming in access. It is within an attendance DBA for our HR department. The issue is on the below 'save' button that should insert several fields, using data on the current form, into a discipline table. The...