If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Showing data from linked spreadsheet to a form
Hi there!
I'd like to show data from a linked spreadsheet into a form. How do you do this? I've managed to link the spreadsheet into the database. The database has order numbers which matches the Order number in the spreadsheet. The info I needed to show in the database is the Billing Status according to the Order number. The Billing status is constantly updated in the original spreadsheet. What I'd like to happen is the following: In the form, an order number is typed in and all the info concerning that order is pulled from a database table as well as the billing status which is coming from the linked spreadsheet. I'd appreciate any help. Thanks. |
#2
|
|||
|
|||
Showing data from linked spreadsheet to a form
On Tue, 6 Jan 2009 15:16:00 -0800, maxinemdk
wrote: Hi there! I'd like to show data from a linked spreadsheet into a form. How do you do this? I've managed to link the spreadsheet into the database. The database has order numbers which matches the Order number in the spreadsheet. The info I needed to show in the database is the Billing Status according to the Order number. The Billing status is constantly updated in the original spreadsheet. What I'd like to happen is the following: In the form, an order number is typed in and all the info concerning that order is pulled from a database table as well as the billing status which is coming from the linked spreadsheet. I'd appreciate any help. Thanks. Create a Query joining the linked spreadsheet to the local table. Base your form on this Query; you can put a Combo Box on the form using the combo box wizard, choose the option "Use this combo to find a record" and have it based on the orders table, so the user can select an existing order number. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|