Thanks, but been there, done that.
I get((DateField=">#09/26/01#")) which also errors out. Works Ok in an MDB but not in an ADP.
Any other ideas?
I would unders Tools-Startup select your intial form to open and uncheck "display database window". If you put "DoCmd.Quit" into the "on close event" of the startup form the user will never see the interface. If you uncheck the "Allow..." boxes you will...
I can search for ranges of dates OK in queries and by coding for specific searches. But I cannot seem to be able search for range of dates or > dates in query-by-form mode in Access projects.
Access projects enclose the filter expression in double quotes. Ie: Me.filter=...
I have an Accesss 2000 project connected to an SQL database. I would like to use an import specification but the "save" but is inhibited and will not let me save the specification, but will do the import. I have tried assigning the connection user name every permission there is in...
Because I am trying to use Access 2000 as a front-end to SQL Server 2000 database engine. The only way I have to reference a table is to link using ODBC. I was looking for a way to load and edit a recordset just using the code in the form. I can get it to work using the following code:
Dim...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.