Search results

Oh, so it is ok to use the combo boxes with the value list in the lookup in the design view of the table. I did misunderstand then. THank you!

Awesome!!! Thank you SO much!!!

For my database that I have created I have a main form which all the other subforms in the tabs are related to. The main form is based off the employee information. I was wondering if in certain tab controls with certain forms if I could have kind of like a double check for me (since I am the...

I am using it to track what type of document I have on file and there are 2 documents that I would be choosing from. I was advised in a different post not to use the lookups but I can't get away from them. I did end up using the value list for the fields that I needed.

I was advised to not use combo boxes in my tables as it can cause issues. I don't want to create a table to be used for a lookup since it will only contain two bits of information. Would it be easier to create unbound combo boxes in the form and get the information that way? The form is...

Ok, I will have to add more tables to the db for those combo's that I need. It may end up working out for me as I move onto the other portions for licensing and certifications.

What would your suggestion be? The fields that I want to have lookups in would be Document1 and Document2 which are both the same thing I would need to choose between card and certificate and the third field is Personnel and I need to choose between Supervisory and Craft. Using the lookup...

Thank you!! One more question...can you have 2 combo boxes in the same table? I am almost done updating the table with the information and it will not allow me to have a combo box in more than one field. Is there a reason for this or am I doing something wrong?

Can you have a date/time stamp on a form to see when it was entered? Since it is near impossible for me to be "real time" with the data and when reports are run from the database right now, I would like be be able to say to a manager I received the information on this day but did not input it...

I do not take it as a put down. I am most definitely a beginner in Access and slowly making my way towards an intermediate user. I don't want to convert the Excel into Access as most of the basic info is already in the database, I am just adding another portion (well 3 portions to be exact)...

I am working on the second half of my database and I want to make sure before I promise the manager that I will be able to do a report in Access that I currently do in Excel. Currently in Excel I have a report run from our Payroll system which is then dumped into Excel and then I have to do a...

Ok, I will give that a go. Thank you!

I was using it as a lookup table, somewhat similar to what I did with the tblSkills.SkillCode and tblRating.SkillCode. I don't want the relationship to be a 1-1 relationship but I cannot get it to be a one-to-many relationship. I am wondering if it is because the TrainingID is an autonumber...

I am trying to get the second half of my database complete. I have posted previously about the tables and I think I may have it now but I'm not sure. I have attached the relationship report. The only issue I think I may have is the one-to-one relationship between the tblTraining and...

That makes sense...Thank you!!

I need to be able to make notes on employees for my database. For example if they are out on WC or they need a certain test, etc. The main table in my database is the tblEmployee and that is where I added the memo field called Notes. My question is how exactly does this field work? I have...

Yes, I'm sorry I should have specified that better. Each ID is specific to one employee. For example John Doe's employee ID number is 1250 as this number identifies John Doe for all programs including the payroll and benefits system. I installed the Auto FE Updater and from what I read on...

The reason why I did not do autonumber for the tblEmployee was too keep all records under one ID. I already have this portion of the database published, is there a way that I can go back and redo the tables like you suggested without disrupting the users? The second half of this database will...

Here is the relationship report and the slimmed down version of the database. I have not yet started adding tables to the database as I am trying to get it worked out on paper first. Thank you so much!!

I am having a tough time trying to get my tables normalized. I'm thinking that I should have an additional table for a look up for all the other trainings and use it that way in a datasheet? Also some of those trainings do not expire so with the 3rd table should I add a yes/no field that asks...