| Cap'n Dave via AccessMonster.com 2006-02-01, 3:26 am |
| Greetings,
I am having a problem saving my access form as a data acess page. Although
this form works fine in Access when accessing it as a web form I get these
errors:
Data provider failed while executing a provider command - click OK/Cancel
Invalid SQL Statement; expected 'Delete', 'Insert', 'Proceedure', 'Select',
or 'Update' - click OK/Cancel
This is a simple 2-tier implementation with IIS and the Access database both
on the same server.
UseRemoteProvider = False
I have narrowed down the problem to 2 combo boxes on my form. The 2nd combo
box filters data from the table based on the 1st combo box value. If I leave
out the filtering the DAP runs fine, when I have the filtering the DAP bombs
with the above errors. Here are the select statments:
This one bombs out....
SELECT tblEmployees.EmployeeID, tblEmployees.LastName, tblEmployees.FirstName,
tblEmployees.CompanyID, tblEmployees.Title FROM tblEmployees WHERE ((
(tblEmployees. CompanyID)=Forms!frm
Enrollment_ver1Web!c
boCompanyID)) ORDER BY
tblEmployees.LastName, tblEmployees.FirstName;
This one works....
SELECT tblEmployees.EmployeeID, tblEmployees.LastName, tblEmployees.FirstName,
tblEmployees.CompanyID, tblEmployees.Title FROM tblEmployees ORDER BY
tblEmployees.LastName, tblEmployees.FirstName;
How do I "filter" the ListRowSource using the value from the combo box?
I really need to filter the data so the end user selects the correct employee
for their site. Any help would be greatly appreciated.
V/R
Dave Lowe
Camp Slayer, Iraq
--
Sea ya..Cap'n Dave
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...ersion/200602/1
|