Updating a List box

[MaxEd]

I have a combo box that the user uses to select an employee name and then clicks a button to add it to the table. What I want this to do is to create a history of the employee names in a listbox each time the user has selected an employee and clicks the add employee button. Thanks.

 

[hwkranger]

you need to make a new table for the history.

then make the listbox that is drawn from your history table.

hope this helps

Cruz'n and Booz'n always.
This post shows what little I do at work.

 

[MaxEd]

hwkranger,

Is there any other way? Because I just need to save that list of employees trained for that day temporarily for viewing purposes. I would have to delete everything from the table each time the list box is used.

 

[rollo58]

If it was stored in a history table with an insert date, you could just show the current day's trainees in the list...?

 

[hwkranger]

you could use an array, stack, or queu, but... remember that when you close your form it resets all your variables. honestly, the only way i could see doing it, without using a table, would to make it write to a txt file and load the txtfile everytime you opened the form. You could also then clear the txtfile each day with a button, or manually select and delete.

Honestly, I would use another table, indexed by date - this way you still have a record of who was trained on what day.

still your options are open Cruz'n and Booz'n always.
This post shows what little I do at work.

 

[MaxEd]

rollo58, I thought about it that way as well but what I wanted to accomplish was just to see what the current user has entered into the database. I've managed to work around it using a text box instead.

 

[MaxEd]

hwkranger,

I already have a schedule table that links to the training that took place for each day. I just want to track the user interaction with the database and only show those names that JUST got entered into the database per schedule and class. I used a simple text box and just updated it as the user adds a new record so it tells the user what has been entered and what they are currently entered but will not show ALL the trainees entered into the database per schedule at anytime.

Thanks for your help.

Thanks for the tips you guys.

 

[MaxEd]

How would I query the data that was just entered today if I have a field that is "Date Entered"? Thanks.

 

[hwkranger]

build a query, and use #2/14/03# within the query and make sure your field is a DATE.

Cruz'n and Booz'n always.
This post shows what little I do at work.

 

[MaxEd]

hwkranger,

Thanks!! I got it.