Thanks, that helps.
1. Do I just use database splitter to separate the data from the code, or is it more complicated?
2. After I separate them, the users add to the database, then email the tables back to me, and I import them somehow into my version of the database?
Sorry if Im confused about something simple, thanks for your help.
SEEMO
Last Activity: Mar 29 '07, 11:37 PM
Joined: Sep 29 '06
Location: Oliver, BC
-
The users will update data daily and send to me. I need to review data daily and also update data with new orders etc. I will want to occasionally make database changes and additions we go along - (new forms, etc) to expand and modify the database and structure.Leave a comment:
-
Thanks Rabbit, That helps.
1.So if I have the users join the workgroup, and I send back an updated version of the database, would the workgroup apply to the updated version, or would they need to join the workgroup everytime, for the password to be required?
2. If I add code to export the tables for data transfer, will it import very easily to update the database the other location? I will need to send it back to the users and it...Leave a comment:
-
Logs user in as admin, without password
I have recently completed a database (Access 2000) for our factory, which the users will update daily. I am at a different location and need to manage, view and also make changes and updates. Iam probably doing this wrong, but at this point, I update the database and email the whole thing to them, they update and send it back everyday. I have assigned a password for the users and me as admin, and they seem to work. When I open the database, it requires... -
Thanks, that kinda works. It changes the status to printed, but only for the first record in the subform. How could I get all the related records in the subform to show 'printed'?
Thanks for your help,
ChadLeave a comment:
-
Hi,
Thanks for responding. Im still a little confused. I could do an update query to change status to 'printed', but I really need it to automatically change status to 'printed' when the user prints the form for each item.
The job order form has several hundred items, sorted by item ID. When the form is opened, the first record from POdetail Qry appears on the form and the subform displays the details. The user prints the form and...Leave a comment:
-
How to mark a record as "Printed"
I am making a database for our factory, for managing production. I have a form for printing job orders(Job Prep) for each item to be produced, which user selects from a combo box, and the form contains a subform(Job Prep Sub), which lists the purchase orders for that item. Info comes from PO detail Query, which gets most of its info from PO detail table.
I have a button on the form, on click, prints current record.
The problem Im having...
No activity results to display
Leave a comment: