| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Hi Otto,
It worked a treat thankyou so much. "Otto Moehrbach" wrote: Kathy Yes, this can be done several ways. One way is to use VLookUp formulas in the pertinent cells of your form. Or you can write a macro to do it. Look at VLookUp under Help and see if it fits with what you have. Post back with more details about the layout of your form and database and where each is located if you need more. HTH Otto "Kathy" wrote in message ... I have a database in excel which lists our stock and prices etc. I would like to be able to enter a stock number on an invoice that will retrieve the details and price from my excel database. Can this be done? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Form File Errors | Excel Discussion (Misc queries) | |||
| Is there way to enter multiple values into excel cells w/ a form? | Excel Discussion (Misc queries) | |||
| Database records from excel templates | Excel Discussion (Misc queries) | |||
| How do I use Excel to post data to an external database? | Excel Discussion (Misc queries) | |||
| Query a Access database that has a module from Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
