complete fields in excel spreadsheet

[doobr1e]

is access 2000 suitable for the following:-

we order goods from a supplier, the supplier requires a seperate excel
workbook order form completed for each and every order that relates to a
different location (lots of locations) and at the moment we have say 50
seperate locations every day and this is going to increase too.

each and every seperate excel workbook has to be emailed to the supplier
in a seperate email

now, ive been over the whole thing with the supplier in order to make
this a far less onerous task. for our own purposes it only needs an
extra column on the spreadsheet which would allow us to put everything
on 1 spreadsheet but they wont have it, follow their system or go
elsewhere (we cant, its specialist items only approved through this
supplier!)

so, could we setup an access database so we can enter the information
during the day and have access run a process to create the completed
excel spreadsheets for us in 1 go and maybe even create the emails?

is this something suited to access? (im going to have to learn access2k
in order to do it too, from ground up no previous database experience
but im willing)

 

[Immanuel Sibero]

Hi


Yes, this can be done in Access (well, as you will find out, really both
Access and Excel).

The general idea is to have the same data entry fields in an Access form as
those currenty used Excel spreadsheet. Once an order is filled in the Access
form, Access can then automate the data entry into the Excel spreadsheet (I
imagine you have a uniformly formatted Excel template for this order) and
save a copy. Access can even invoke Outlook to send this file via email.
Another obvious benefit, you would have a history of orders in one place in
Access, instead of scattered Excel spreadsheets everywhere.


HTH
Immanuel Sibero

 

[doobr1e]

Hi


Yes, this can be done in Access (well, as you will find out, really both
Access and Excel).

The general idea is to have the same data entry fields in an Access form as
those currenty used Excel spreadsheet. Once an order is filled in the Access
form, Access can then automate the data entry into the Excel spreadsheet (I
imagine you have a uniformly formatted Excel template for this order) and
save a copy. Access can even invoke Outlook to send this file via email.
Another obvious benefit, you would have a history of orders in one place in
Access, instead of scattered Excel spreadsheets everywhere.


HTH
Immanuel Sibero

yes, thats it, a uniform excel sheet to order with, they have set it up
with vlookups for the items to be entered with a four digit code, etc
but having to open the template, enter data, save template, email saved
document, etc, etc is becoming quite a chore for the folk that have to
do it

the funny thing is (well, not funny!) ... this is the improved version -
the previous way was the same thing but on paper, faxing each one to
them and them faxing back ... ! it's all lunacy ... but one we have to
endure for the moment until they realise it can be done far more easily

well, i see a few weeks of getting to know access coming up

 

[Immanuel Sibero]

Hi

You can definitely eliminate the "chores" you described. I would recommend
the nearest bookstore for MS-Access and of course this newsgroup is an
endless source of information. Post back here if you need further help, and
good luck to you.


Immanuel Sibero