Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BigL
  • Order by date
  1. BigL

    Search range of date in Query-by-Form

    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?
  2. BigL

    Getting rid of Access' shell

    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...
  3. BigL

    Search range of date in Query-by-Form

    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=...
  4. BigL

    Access Project Import Specification

    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...
  5. BigL

    Assign ADO-recordset to form's RecordSource

    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...
  6. BigL

    Assign ADO-recordset to form's RecordSource

    I would like to do this also. My form is unbound.

Part and Inventory Search

Back
Top