Initial problem:
Have a database built from form fields in a web form which included a date field that was initially set to a text data type. I can sort with this field but can not perform calculations or use date/time functions. I want to construct a macro or delete query in the Access2000 database that will select all records prior to the current date and delete them. I need a date/time field in order to use the Now() function, so I changed the datatype from text to date/time. Now I am getting the error message above in a database results region that uses the date field for a search parameter.
I have updated the database in FormProperties, Send to Database, Options and gotten the completed successfully message.
I've also rerun the Database Results wizard, and I've checked the properties for the field in the form -- it is "No Constraints" -- date/time is not a datatype option here.
Finally, I have created a completely new page but still get the error message.
Two evovled problems:
I can not get am Access database query to produce results using now() as criteria in the date field -- 0 records returned even though several entries have been made to the database since changing the data type in the database table, form, etc. AND . . .
I can not get my database results to work for just this one results region -- others connected to this same database but not reliant upon the date field as a search parameter work fine including showing all the data in the date field
Here are pages to view related to this problem: - the gateway to various results regions
- the data entry form upon which the database is based
Any idease about how to resolve the problem(s)? All suggestions and comments appreciated.
Have a database built from form fields in a web form which included a date field that was initially set to a text data type. I can sort with this field but can not perform calculations or use date/time functions. I want to construct a macro or delete query in the Access2000 database that will select all records prior to the current date and delete them. I need a date/time field in order to use the Now() function, so I changed the datatype from text to date/time. Now I am getting the error message above in a database results region that uses the date field for a search parameter.
I have updated the database in FormProperties, Send to Database, Options and gotten the completed successfully message.
I've also rerun the Database Results wizard, and I've checked the properties for the field in the form -- it is "No Constraints" -- date/time is not a datatype option here.
Finally, I have created a completely new page but still get the error message.
Two evovled problems:
I can not get am Access database query to produce results using now() as criteria in the date field -- 0 records returned even though several entries have been made to the database since changing the data type in the database table, form, etc. AND . . .
I can not get my database results to work for just this one results region -- others connected to this same database but not reliant upon the date field as a search parameter work fine including showing all the data in the date field
Here are pages to view related to this problem: - the gateway to various results regions
- the data entry form upon which the database is based
Any idease about how to resolve the problem(s)? All suggestions and comments appreciated.