How to use data from Access database to fill in cells in Excel

  • Thread starter Thread starter musicmike89
  • Start date Start date
M

musicmike89

Though I am a competent Office user, I am a relatively new to Access, so
sorry if this question is a stupid one. I have checked through the forums but
haven't found anything completely similar to my problem:

I work for a company producing many different 'lines' of a certain certain
everyday product, each particular line having an identifying code and quality
control parameters such as height, weight, width, loadtest etc. (if you don't
understand what I mean, imagine a factory producing lightbulbs with lines of
conventional bulbs with line codes 40W, 60W, 100W and then the energy saving
equivalent 40WE, 60WE, 100WE etc - every bulb from a particular line is given
the same code). The codes and quality control parameters are stored in Access
in the format:

| Code | Height | Weight | Width | etc...
| AA01 | 200cm | 10.10g | 15cm |
| AA02 | 350cm | 15.00g | 13cm |
| AA03 | 180cm | 11.60g | 18cm |

At the moment the quality people have blank sheets set-up on Excel in the
format the company desires, which they print out and fill in, manually
looking up the parameters from the database and manually entering the
parameters they measure. e.g they would fill in a sheet like:

Quality Control Test Sheet
Line Code:
Target Height:
Actual Height:
Target Weight:
Actual Weight:
Target Width:
Actual Width:

At the end of the day, they would file all the Quality Control sheets
together in a folder specifically for that day, which would be archived.

The aim is to speed everything up by computersing the whole system which
would save paper and space!
Instead they need to open a sheet (at the moment in excel but doesn't
necessarily have to be) and either fill in the line code or select it from a
drop-down list, so that the data on file is already filled ou like so:

Quality Control Test Sheet
Line Code: AA01
Target Height: 200cm
Actual Height:
Target Weight: 10.10g
Actual Weight:
Target Width: 15cm
Actual Width:

Then all they need to do is type their in the recorded parameters and save
the sheet under the current date.

The initial idea was to have a template for every product ie. "AA01.xlt",
"AA02.xlt", etc. but the specifications are regularly updated on the database
which would mean updating the templates, and besides we have over 2,500
product lines which would require too many templates!

I hope I have made the problem clear and any solutions, help or advice would
be greatly appreciated! Thank you!
 
edit: Though I don't think it matters, I am using Access 2003 on Windows XP
and the quality system would be on one of the company's internal servers on
the network.
 
Back
Top