A
Anderflash
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?
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?