Home |
Search |
Today's Posts |
#1
|
|||
|
|||
connect a form to excel database
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? |
#2
|
|||
|
|||
Excel has built in option--try data|form.
If that doesn't quite work, but it's close, John Walkenbach has an enhanced dataform at: http://j-walk.com/ss/dataform/index.htm And if you want to design your own, Debra Dalgleish has a get started with userforms: http://contextures.com/xlUserForm01.html Kathy wrote: 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? -- Dave Peterson |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
Thanks Otto,
I've never used Excel a lot so I will study up on your info and try it, thanks for your help, will let you know how I go. Cheers, Kathy "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? |
#5
|
|||
|
|||
Thanks Very much Dave I'll try that.
Kathy "Dave Peterson" wrote: Excel has built in option--try data|form. If that doesn't quite work, but it's close, John Walkenbach has an enhanced dataform at: http://j-walk.com/ss/dataform/index.htm And if you want to design your own, Debra Dalgleish has a get started with userforms: http://contextures.com/xlUserForm01.html Kathy wrote: 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? -- Dave Peterson |
#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? |
Reply |
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) |