Convert an excel Spreadsheet to Access forms
I have an excel spreadsheet that is used to control the daily workflow of up to 4 drivers from 2 different companies
that work for us, at the top of the form you have the company and the driver name
The information that is in this spreadsheet that is created manually is already stored in my shipping
system (MSACESS 2K FE/SQL SERVER BE) as follows:
in the tblCarrier I have the carriers
in the table tblCarrierDrivers I have the drivers
My question is How can I create a form in Access that will reproduce the format of this spreadsheet
since the dispatchers have been working with this thing for a while it will be easier for me to make the change less painful by using something very similar in order for them to do their work.
I had posted this previously and got no response.
The excel spreadsheet in question is located in EE stuff under the number of the old question I hope the links work still
if they do not please let me know to re-post the file.
View all files for Question ID: 22946081
https://filedb.experts-exchange.com/incoming/ee-stuff/5434-border-crossing.zip
Direct link to your file
https://filedb.experts-exchange.com/incoming/ee-stuff/5434-border-crossing.zip
that work for us, at the top of the form you have the company and the driver name
The information that is in this spreadsheet that is created manually is already stored in my shipping
system (MSACESS 2K FE/SQL SERVER BE) as follows:
in the tblCarrier I have the carriers
in the table tblCarrierDrivers I have the drivers
My question is How can I create a form in Access that will reproduce the format of this spreadsheet
since the dispatchers have been working with this thing for a while it will be easier for me to make the change less painful by using something very similar in order for them to do their work.
I had posted this previously and got no response.
The excel spreadsheet in question is located in EE stuff under the number of the old question I hope the links work still
if they do not please let me know to re-post the file.
View all files for Question ID: 22946081
https://filedb.experts-exchange.com/incoming/ee-stuff/5434-border-crossing.zip
Direct link to your file
https://filedb.experts-exchange.com/incoming/ee-stuff/5434-border-crossing.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Why do you have 2 trip 1's.
ASKER
I have two trip 1 by error it was intended to be trip 1 then trip 2 etc
I think that you got your from dlan75.
I would recreate the look of the spreadsheet in the Access form.
It just takes some layout work, unless I'm missing something, it looks pretty straight forward.
There is no way to effectively import a working spreadsheet/form into an Access form.
It is possible to import the form as a picture and then place fields over it but this is clumsey and sometimes more work than creating from scratch.
Hope this helps
I would recreate the look of the spreadsheet in the Access form.
It just takes some layout work, unless I'm missing something, it looks pretty straight forward.
There is no way to effectively import a working spreadsheet/form into an Access form.
It is possible to import the form as a picture and then place fields over it but this is clumsey and sometimes more work than creating from scratch.
Hope this helps
ASKER