Search results
-
K
Move data to different table using query
Well I have read all about append queries but I can't seem to get it to do what I am wanting it to. I really need the select data to be copied in the WO REG table perminitly becuaes after the workorder has been completed it is archived in the table. -
K
Move data to different table using query
Ok here is what I've got. I have a table called (EQUIP REG) It contains all the information to the equipment in the hospitol. next i have a table called (WO REG) It contains all the information for the workorders for the equipment. In the EQUIP REG table I have field titled (PM) this is the... -
K
Need to move data from table a to table b and delete it
That will work, thanks for the simple answer. You have helped me a bunch. -
K
Need to move data from table a to table b and delete it
Ok you sold me, it is much more compliated than I would have ever thought. So....now how do I do the open/close flags? And what are they? -
K
Need to move data from table a to table b and delete it
Well I have two tables, one is the workorder register and the other is the closed work orders. This is for maintenance. I have a form for creating and veiwing workorders. I need to link a command button to the form that will delete the record being viewed in the WO REG table and paste it in... -
K
Command button, need to lock data and insert date.
Well the title says it all. I need to create a button to lock the info on the form so it can't be edited and at the same time insert the date. Any ideas?