Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Closing on OLE Object embedded in table
Access 97 I set up a query form that has a field for OLE embedded objects. These will mostly consist of documents such as Word and Excel files. When I return a search that contains an OLE embedded file, I can select it and it will open up in either Word or Excel. If I accidentially modify...- Jduke
- Thread
- Replies: 0
- Forum: Microsoft: Access Other topics
-
Passing vba variables to an SQL query...
I would like to pass a vba string variable to a SQL statemnet to create a query in Access97 and tried the above suggestion with no sucess. I still seem to pass the variable name and not the variable string value. I want to send that value to the SQL statement so a user can search a table with...- Jduke
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Querying combining Multiple Fields in Access97
To add to my Combination querying issue I would like to have the ability to have the user select "All" as an option in the lists and this will bring back all the records with any of the options from that list. An example would be: 3 Fields: "Team" "Year"...- Jduke
- Post #4
- Forum: Microsoft: Access Other topics
-
Querying combining Multiple Fields in Access97
I am using a form as a search engine. I would like to allow the user to select criteria from a series of combo boxes and have the query search be on that combined multiple criteria. Thanks in advance!!!- Jduke
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
