Thread: Excel/Access
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
justjohn
 
Posts: n/a
Default Excel/Access


Hi Bob,
and thankyou for taking the time to reply.

As you may have guessed, my ability to use excel and access is VERY
limited. I use it in a very simple manner and have no knowledge at all
of visual basic, and I think that was the code that you refer to.

I will try to give more details of the problem, and perhaps you could
take the time to help.

Access database contains all our customers' details (rows), these
include account number, name, address, postcode, vehicle details
(columns).

I have made a simple jobcard in excel to be printed for use in the
workshop.

instead of typing or copying and pasting the customer details from the
database to the jobcard each time a jobcard is required I thought that
it could be possible for MS to "search" (if that it the right word)
through the database for name and address details and copy them to the
appropriate cells in the excel jobcard. This "search" would be
"triggered" by putting a customer's account number into a cell in the
excel spreadsheet/jobcard that would be somehow attached to a
function/macro.

As you can tell by what is probably poor use of terminology I am way
out of my depth here, and I have no idea whether any of this is
possible.

The part that I thought I had working was a simple copy and paste
macro, but even that failed.

If you can help/advise/write whatever it takes I would be very
grateful, but thanks for reading anyway.

PS
thanks for the previous advice that you gave on validation too, it
turned out to be exactly what I needed.:)


--
justjohn
------------------------------------------------------------------------
justjohn's Profile: http://www.excelforum.com/member.php...o&userid=30663
View this thread: http://www.excelforum.com/showthread...hreadid=503672