Replies

yes.

Yes. I have created the file specifications.

Any other suggestions?

DP

Yes. I have created the file specifications.

Any other suggestions?

DP

Thanks!

I searched the help files this morning and was testing the currentuser options. I was not very successful. I think I can follow your instructions and be able to assist the instructors with wrongful entries.

Thanks SO MUCH!!!!

Deborah

Thanks!

I searched the help files this morning and was testing the currentuser options. I was not very successful. I think I can follow your instructions and be able to assist the instructors with wrongful entries.

Thanks SO MUCH!!!!

Deborah

I guess my post was not real clear. The people who are using the db have security access to add/delete/modify records to the table. I want to know if they is a way to capture who added/deleted/modifed the record in the table. They all have user names in security.

Can you provide some sample code or help to get this accomplised?

Deborah

I guess my post was not real clear. The people who are using the db have security access to add/delete/modify records to the table. I want to know if they is a way to capture who added/deleted/modifed the record in the table. They all have user names in security.

Can you provide some sample code or help to get this accomplised?

Deborah

Hans,

How to I specify what field to connect it to? I need 2 parameters to match company, cost center and type of training.

Deborah

Hans,

How to I specify what field to connect it to? I need 2 parameters to match company, cost center and type of training.

Deborah

THANK YOU!

This is such a wonderful feature and I appreciate the rapid reponse.

Deborah

THANK YOU!

This is such a wonderful feature and I appreciate the rapid reponse.

Deborah

Hans,

Thanks for the reply. I understand the idea behind generating the text boxes but I am lost on this part (see below).

All subreport controls could share one source object; they should be linked to the main report by means of the text boxes (and probably, by the month and year).
In the OnOpen code of the report, hide the text boxes at the end that are not appropriate.

Can you clarify a little more or produce a sample?

Thanks,
Deborah

Yes, I have all the employees in my database. My database is solely for DHEC records. I maintain the database with weekly updates from payroll. When we have New employee Orientation on Monday, they come to class and then on Wed, I get a download from payroll. I search by Emp # and enter and O for training type and the date of Orientation. The following year, I produce a report to send to the director stating that your employee came to orientation on 3/1/2002 and it is time for them to come to Annual training (theyhave to come within their hire month). Once they come to AT, I go back to the database and search by Emp# and add a new entry for AT. Now, the next year 3/1/2004, I modify the old AT and change the date to the current year. They also have to complete a telephone training as well every year. An existing employee should always have 3 records, O for Orientation, AT for training Class and T for Telephone in my database. I am not concern with any other training. We offer all sorts of training. The other database keeps track of all the outside as well as inservices. This Corporate training was a requirement for all employees. We decided to count it as their AT as well as for inservice. So they will get credit twice for the same class.

My database is very simple: Employee table linked to training table by Emp#. The training table consist of autonumber – training entry, Empl#, date completed, date entered (default of =now()), type of training (AT or T or 0).

The other database consist of the same but location, instructor, hours, etc.

I imported the table into my database. I created an updated query to update the AT completed date field to the date they completed the corporate training. So…my record could have stated AT on 6/6/2002 and now it states 1/14/2003. I ahve completed my AT for this year. It works with people who have an existing AT. My problem is I want to check to see if they DO not have an AT and then append the corporate as an AT with the date compeleted. I do not want to override the O record – I want to add a new record without manually doing this.

How can I do this?

Sorry so long ! Deborah

Sorry, I made a mistake. The problems are occuring on new machines with Win2000 installed. We are still using Access 97. Is there something I can do?

Deborah

THANK YOU….THANK YOU……THANK YOU!!!!