The reason why I use both is because originally, this company was only
using Access to keep track of jobs and to create job #'s. When I
arrived, the timesheets were still being done manually and so I
decided to use Excel so it would be easier to calculate labour cost
for each project.
Currently, the employees enter the job # on their timesheet and the
amount of hours they worked on that job and they do so for every
workday.
I have to look in Access to find out what job name that job # refers
to. I want to automate that by entering the job # in a cell on their
timesheet and have the job name fetched from the Access database and
popped up in specified cell.
I have had limited success in accomplishing this. It retrieves the
correct record but it displays both the job # and the job name where I
don't need to have the job # repeated since I already inputted once.
Furthermore, it won't let me specify exactly what cell I want the job
name to appear in.
On Oct 31, 12:34 pm, "Leslie Isaacs" <leslie.isa...@gp-n85011.nhs.uk>
wrote:
> Why do you want to use both excel and access?
> I'm no expert but I would have thought you could do what you want much more
[quoted text clipped - 3 lines]
>
> Les
Nick Hodge - 13 Nov 2007 16:23 GMT
Perhaps this will help?
http://www.nickhodge.co.uk/gui/datamenu/dataexamples/externaldataexamples.htm
Near the bottom (Using parameters in External ODBC Data Queries)

Signature
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.nickhodge.co.uk
UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html
> The reason why I use both is because originally, this company was only
> using Access to keep track of jobs and to create job #'s. When I
[quoted text clipped - 27 lines]
>>
>> Les