Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help for access to excel via VBA
So, I'm trying to make a user form where I can have the user select
some fields to search in a huge database. For example, they will be able to choose Male/Female.... Age Group.... etc. I have tried to record a macro and see how the code works to get the data from Access. However, as I try to incorporate it in my program, I have errors. So, I was wondering if there an easier form of code that will work? I would be forever grateful if someone tells me how the code that I need looks like or have an example of it. :) Thanks Eric |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help for access to excel via VBA
See Mr. Erlandsen's site on use ADO with Excel and Access:
http://www.erlandsendata.no/english/...php?t=envbadac -- Regards, Tom Ogilvy "cyc1120" wrote in message oups.com... So, I'm trying to make a user form where I can have the user select some fields to search in a huge database. For example, they will be able to choose Male/Female.... Age Group.... etc. I have tried to record a macro and see how the code works to get the data from Access. However, as I try to incorporate it in my program, I have errors. So, I was wondering if there an easier form of code that will work? I would be forever grateful if someone tells me how the code that I need looks like or have an example of it. :) Thanks Eric |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help for access to excel via VBA
See also my new page
http://www.rondebruin.nl/accessexcel.htm I hope it is useful -- Regards Ron de Bruin http://www.rondebruin.nl "Tom Ogilvy" wrote in message ... See Mr. Erlandsen's site on use ADO with Excel and Access: http://www.erlandsendata.no/english/...php?t=envbadac -- Regards, Tom Ogilvy "cyc1120" wrote in message oups.com... So, I'm trying to make a user form where I can have the user select some fields to search in a huge database. For example, they will be able to choose Male/Female.... Age Group.... etc. I have tried to record a macro and see how the code works to get the data from Access. However, as I try to incorporate it in my program, I have errors. So, I was wondering if there an easier form of code that will work? I would be forever grateful if someone tells me how the code that I need looks like or have an example of it. :) Thanks Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
Access data -work in Excel- save in Access | Excel Programming | |||
Getting Access Error Messages when running Access through Excel | Excel Programming |