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
|
|||
|
|||
Query of Office Spreadsheet (Web Components) in a Access Form
I put the Office Spreadsheet in a form;
I accessed the 'Command and Options' button and went to the 'Datasource' tab; I put the database and the query in the fields at the normal process in this tab...; I can manipulate this datasource fields of the spreadsheet using the propery 'connectionstring' on VBA Two questions about it: 1)I cannot put the same database as I'm using, because it says that the database is already opened by another user (in this case, me). I can do it only putting another database. Can I put the active database on the datasource tab of the spreadsheet to view the tables and queries of this database? 2)If the query has a criterium like 'field like "A*"' (without single quotes), the spreadsheet doesn't work. The query with criteria like 'ID = 2' works well. How can I do to the spreadsheet works with complex queries? Or what is the limitation of the query to be used in a Spreadsheet? |
Thread Tools | |
Display Modes | |
|
|