I have a form frmContainerbooking in the attached DB. It has 5 different sections which represent 5 tranches of information coming from different sources who are not in the domain of access users
Section 1 which generates the BookingRefNo etc will be created in Access. The information comes in Excel and is manually copy pasted cell by cell which is very time consuming and prone to errors. What is the best way to do this?
We can build 3 different forms for each activity if it helps.
We cannot allow Access to the Table for the users as the database is split and the user are working on their fe versions with suitable forms and reports
Section 1 which generates the BookingRefNo etc will be created in Access. The information comes in Excel and is manually copy pasted cell by cell which is very time consuming and prone to errors. What is the best way to do this?
We can build 3 different forms for each activity if it helps.
We cannot allow Access to the Table for the users as the database is split and the user are working on their fe versions with suitable forms and reports