Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel form to update data from MS Access data table based on criteriain excel sheet
I'm currently using MS Excel 2003 and MS Access 2003. I also have the
XLODBC.XLA addin from Excel 2002 if that is of any benefit. What I am trying to do, if anyone can point me in the right direction is: I have a form is MS Excel that is used to do XYZ and I want to insert a reference number (REF_NO) and it will populate the form using data from an MS Access database. The MS Access database has two tables (MAIN & VEHDET) that is connected by (REF_NO). The aim of the Excel form is to popluate the data before converting it into PDF file. I tried using SQL.REQUEST but I couldn't get it to return any results. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel form to update data from MS Access data table based oncriteria in excel sheet
Still not 100% sure of what you are after, but have a look at my
databaseLookup function. There are other/better ways of accomplishing this, but this should give you some ideas anyway. Also, the site is still in design mode, so disregard the mis-aligned graphics and fake Google adds. lol http://www.mustangsofburlington.com/...se_lookup.html On May 12, 2:55*am, Santa-D wrote: I'm currently using MS Excel 2003 and MS Access 2003. *I also have the XLODBC.XLA addin from Excel 2002 if that is of any benefit. What I am trying to do, if anyone can point me in the right direction is: I have a form is MS Excel that is used to do XYZ and I want to insert a reference number (REF_NO) and it will populate the form using data from an MS Access database. The MS Access database has two tables (MAIN & VEHDET) that is connected by (REF_NO). The aim of the Excel form is to popluate the data before converting it into PDF file. I tried using SQL.REQUEST but I couldn't get it to return any results. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel form to update data from MS Access data table based oncriteria in excel sheet
Thanks mate,
I'll give it a go and let you know how it goes. On May 12, 10:37*pm, JW wrote: Still not 100% sure of what you are after, but have a look at my databaseLookup function. *There are other/better ways of accomplishing this, but this should give you some ideas anyway. *Also, the site is still in design mode, so disregard the mis-aligned graphics and fake Google adds. *lolhttp://www.mustangsofburlington.com/excelsiterevisit/function/databas... On May 12, 2:55*am, Santa-D wrote: I'm currently using MS Excel 2003 and MS Access 2003. *I also have the XLODBC.XLA addin from Excel 2002 if that is of any benefit. What I am trying to do, if anyone can point me in the right direction is: I have a form is MS Excel that is used to do XYZ and I want to insert a reference number (REF_NO) and it will populate the form using data from an MS Access database. The MS Access database has two tables (MAIN & VEHDET) that is connected by (REF_NO). The aim of the Excel form is to popluate the data before converting it into PDF file. I tried using SQL.REQUEST but I couldn't get it to return any results.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
thru form update data store in excel | Excel Worksheet Functions | |||
ADO excel VBA to update data in Access | Excel Programming | |||
How do I access the access data via Excel 2002 with auto update ? | Excel Programming | |||
Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
How to update Access Table with Excell Data | Excel Programming |