Search results

I think what I am looking for is that we have MS Office 2007 installed on a computer. It did not come with Access 2007. Our IT guru wants to install Access 2000 on the computer. Since we are possibly having Access 2000 install on a Microsoft Office 2007 isn't there some kind of compatability...

I know this answer but I would like to hear it from an expert. My question is several of our computers are currently running XP with Microsoft Office 2007. MS Office didn't come with Access our IT department wants to add Access 2000 instead of purchasing the 2007 Access. Is there a...

I am going to see about trying to resolve this myself. Since I cannot upload my database now becasue it is too big I will try and figure it out. If I have any more questions I will let you know. Thank you.

Yes I am (or at least I think I am) I have clicked on the two tables so in the query I have the two tables and clicked on the field name ID's which are automatically entered into the fields I click the append under query and select EmplJobQuals for the append and then I go into the code and...

I have done what you have suggested by going with your first option. I created the query and have now ran the query it doesn't show any new data. It shows zero rows copied

I have decided to keep it how I have it. If the auditor wants to view the name of an employee then they can use the search command option. Thanks for your help.

Ok I will try it. I would click the qryAppendApplicable Quals right. I am just making sure that I am hitting the correct one. I will try this and see what happens.

Ok, I was still hoping it was a request from my supervisor but hey I do agree with you that your way would be wiser and easier.

I know of that way to do it but I was hoping that there was an automatic way where you start typing the last name of an employee and it would automatically go to that record. I can use the command box though if I cannot do it the way I want to.

Thanks I was able to figure it out and it works well.:D

I hope that I am in the right area for this question. I have a table of employees that has been turned into a form. My question is is there a way to set up the field that will allow you to begin typing the employees last name and automatically take you to that particular record?

Also would I also have to add new employee for a person who is cross trainied. I just tried to enter one and it did what the new employee opion did when I entered in the data.:o

I am running Access 2000. After I had posted my question I had a feeling I would have to set it up how you had suggested. I remember reading it somewhere that you cannot add PDF in earlier versions of Access. Funny part is that I was going to set it up simliar to how you had created the...

Is there a way of implementing this into each individual record?

I did finally finish it with the thanks to you. I do have one additional question for you and I hope that it is a simple one. I have made modificatins to the Employee table I have added hyperlink fields to store PDF files for some of the employees. My question is (and I have been researching...

I want to add a hyperlink to individual records that will store a PDF file. How would I go about doing this? Is this possible with the version of Access I am using.

I have tried the expression suggested but it still is printing out all employees.

I will give this a try thanks for your help:)

I am currently usig a query to determine which employees have been here less than 90 days field name is HireDate When I use < Date( ) - 90 it shows everyone I only want the new employees Secondly, how would I set up a query to show which employees have had training during the year ie. Job...

It works perfectly. It looks like I still have a lot to learn about this software. I may know the basics but this is what learning is all about. I understand what you have done and how you have done it. This will be a great replica for any future projects that I will possibly encounter...