i need to be able to save the entry into a history file

Chankrun · Feb 3, 2000

every time i change a feild on a table or form i need it to be saved. I need it to be saved into a history table without it changing the previous history of that feild

DougP · Feb 3, 2000

OK so do you want to have all of the records in the same table each time a change is made. 
If so then it is easiest done with an edit button and a save button. 
Before the user makes a change they click an Edit button which actually is a "SaveAs Duplicate" button 
So it creates an exact copy of the record leaving the original intact and positioning them on the new record. 
After the user changes something in the New record have them press the (save button) to save the New record. 
 
Both the Dupicate and the Save record buttons are in the button Wizards under "Record Operations" in the "Categories" list

elizabeth · Feb 4, 2000

A user may neglect to use the button properly. If you need to be sure, you may want to disable the ability to update a record just in case. You can do this through security if it is set up or you could code it in the form's events. 
 
An alternate approach would be to put code into the BeforeUpdate Event to save the old data as an Add to your History table. If the values are bound you can grab them with the OldValue property. You'd probably want to save the current date and time so you can easily identify the order of the changes.

Chankrun · Feb 4, 2000

What we need to do is to save to a history file the codes and dates and what was done to certain machine at a certain time and save the information to be looked over at one time. That way we can see what has been run on the machine and what maintance has been done. For example, we need something that looks like this: 
 
Code: Date: Discription: 
 
12345 2/6/2000 ran water test 
69780 2/8/2000 ran batch of product 
 
and so on.... 
We need to be able to save the form to read like this. PLEASE HELP! The program is already 17.5 megs big and we need it for work. Thank You,

DougP · Feb 5, 2000

You need 2 tables 
In table 1 store machines with fields like 
MachineID ¦ Name ¦ Dept ¦ etc.... 
12345 ¦ xxxx ¦ yyyy ¦ fadfsfsfs 
69780 ¦ zzzz ¦ aaaa ¦ fsdfsfadsf 
 
in table 2 have these fields (this is the Maintenance table) 
MachineID ¦ Date ¦ Maintenance etc..... 
12345 ¦ 2/6/2000 ¦ran water test 
69780 ¦ 2/8/2000 ¦ran batch of product 
 
So every record in the Maintenance table can be for any machine and any time. 
Every time one tiny little thing is done to any machine a NEW record is added to the Maintenance table. 
Now you can have a "main" form and a "sub form" on it. 
Here's how: 
Create a Machine table and an a Maintenance table. 
Single Click on the Machine table and click the "Insert" menu then click "AutoForm" It will create a form in 2 seconds already connected to your machines. 
Open your new form in "design" view. 
Make sure your Wizard button (button on toolbar with wand and magic dust) is depressed. 
Create a sub form below or to the right of your (Machine fields) 
The link will be MachineID or your Child/master field is MachineID. 
(Sorry Mine won't work right now I need to re-boot.) 
But anyway once you have that set up view your form and you will see one machine and in your subform is where the Maintenance records are for that Machine. (you can have as many as you want. 
You can add a record in the subform and it will link to that MachineID automatically, there everytime you add a new Maintenance record. 
Click on the record navigation buttons (way down at the bottom) to the next "MACHINE" and you can see it's Maintenance records. 
 
OK

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

i need to be able to save the entry into a history file

Chankrun

MIS

DougP

MIS

elizabeth

IS-IT--Management

Chankrun

MIS

DougP

MIS

Similar threads

Part and Inventory Search

Sponsor