Search results

  1. A

    Using ADE 2003 and have date() problem

    Please can anyone help I am using Access Developer Extensions 2003 to package up my database and it works fine on a PC which can run the database without Access Installed. The only problem I have is that the Date() function doesnt seem to be working on any Date fields. When a date is defaulted...
  2. A

    Run time error '13' Type mismatch

    The following code: Private Sub Archive_Click() 'Run Archive - Append and Delete. Dim strSQLAppend As String Dim strSQLDelete As String Dim errLoop As Error 'Define two SQL statements for action queries. strSQLAppend = "INSERT INTO tblHelpdeskcallsArchive " & _...
  3. A

    passing a parameter between 2 queries

    I have 2 queries as follows: DoCmd.OpenQuery "qryappendtblHelpdeskcallstoArchive", acViewNormal, acEdit DoCmd.OpenQuery "qrydeletetblHelpdeskcallsArchived", acViewNormal, acEdit Both queries have a parameter of Archive date which is used to first append calls less than the Archive date to...
  4. A

    querying an empty date field with IsNull problem

    I am using the QBE grid and am writing a select query to select only records with an empty Date Closed Field. The Date Closed field is a Date/Time Field. I am using Access 2003. When I use in the criteria IsNull([DateClosed]) I do not get any records selected which have an empty Date Closed...
  5. A

    CloseCurrentDatabase Method what is saved?

    The standard switchboard on an Exit Application uses the CloseCurrentDatabase method which closes the database and leaves Access open. I have looked at the help and am wondering what objects are actually saved with this method? I am wondering how this compares to using the code Application.Quit...
  6. A

    problem with switchboard and run code

    Im new to VBA and Im trying to run the following module called quit from the standard switchboard: Public Function quit() On Error GoTo quit_Err DoCmd.quit acSave quit_Exit: Exit Function quit_Err: MsgBox Error$ Resume quit_Exit End Function In the standard switchboard I am...
Back
Top Bottom