Search results

I guess can someone explain what matching means here. We are comparing people on some government lists to our employee list here. I guess one list will be coming from our system and one from each web sites. HR will be setting up the Excel files for importing to Access. So about 5-6 tables. A...

Yes. Thanks for the followup

Nope. its populated via a Qualifications form which is partly tied to the Instructors table and some fields show from the contacts table on it as well and everyone can forget about the SSN issue. It was the way I was or was not checking off the yes no fields I guess because instructors can be...

Hi all, Is my last post off base? Thanking about changing the index properties. The SSN field is set all zero length but is also set to be unique in the Index properties for the table. But there is a lot of contacts with a SSN value. its not a required field. Would that explain why those...

Contacts can be students and instructors but in a Duh moment I figured this out somewhat. At least one field in the table has to be at valued for it show but it appears it only updates those who also have SSN present in the contacts tables as well. Could it be because whoever set these tables...

What I meant is if the tables are related with 1 to 1 relationship(which I looked in the master version of the db as being the case) with the Contact ID field should that information not be in the table for Instructors. I am not show what hidden entities means so please explain to me. It might...

The instructor table holds if they are certified to teach things like PALS,BCLS levels of CPR. And I am not planning to remove all the data from the Contacts table. My goal is to make edits to some tables and the reports(I have done that already) but I want to address this issue. The Instructor...

Can someone take a look at this? I would appreciate any assistance.

Here is the db. I took some of the personal fields out of it.

Yes it is and I tried to copy the database tables as you suggested. problem is the contact table has non instructors in it as well so it has about 42000 records total. I want to keep a mixture of instructors and students in the db I post so it may take a while.

I figured the lookups probably does have something to do with it but again I did not create this database nor do I feel I can really blow it up and start from scratch. Not an option if you see all the forms, tables, and other objects in the db as I am only trying to edit the database to allow...

Confused on how table works. I am trying to add instructor ids to an exisiting database that an outside company built years ago. So I added an Insructor ID field to what I feel is the correct table and created an insrtuctor entry form. Probably less than half of the Instructors that are in the...

I have been asked to make some modifications to a database an outside vendor built years ago for CPR training for a department here at our hospital. I am trying to figure how everything works because its a complex built Access db. Its a linked database with the data part sitting on the network...

I am all for making this easier on myself. Any suggestions on a linking field for this seperate table. I am assuming this would mean a subform where the license fields are?

How did I do that? Oh well. Its fixed now. Thanks for the help.

Not sure what you are meaning. There's only three test records in the database. Duplicate file?

Ok I see what you mean. I ran it as well. Only problem its repeating the employee more than once if it finds matches on any of those fields. If you try 08/01/12 to 08/31/12 you will see what I mean. I just need them to show once. Suggestions?

I tried what you suggested but now it will not run the query saying its too complex. I will restate the original problem. I need to check 8 license expiration date fields in order to see if any of them fall in the date range I put. I do not need the parameter box to show more than once. Its...

I actually have 8 date fields I need to check because I have 8 text boxes for License/Certification information and each of those date fields are to be associated with each of those. So will access allow me to do that many lines?

I tried your suggestion in the query LicExpDate for date 08/31/12 since all three test records have that have that date for some of the License Date field in question. I pull no records when I run it though.