Search results

  1. C

    Run time error '3075' Syntax error (missing operator)

    Can you give an example?
  2. C

    Run time error '3075' Syntax error (missing operator)

    Can someone tell me why I'm getting a run-time error on the line below? I suspect it has something to do with the SQL query I have defined in the variable? Line causing run-time error: Set rs = db.OpenRecordset(MedSelectQuery, dbOpenDynaset) Content of MedSelectQuery variable: strLocalBE =...
  3. C

    Run time error '3163'?

    Can anyone tell me why I'm getting run time error '3163' on the following line? If DCount("*", MedSelectQuery) > 0 Then Here's the code listed before this: Dim MedSelectQuery As String Dim fso, f As Object Set fso = CreateObject("Scripting.FileSystemObject") Set f = fso.GetFile(strLocalBE)...
  4. C

    Function to find Access .accdb file's date created?

    Believe I found a solution: Dim fso, f As Object Set fso = CreateObject("Scripting.FileSystemObject") Set f = fso.GetFile(strLocalBE) Dim FileCreatedDate As Date If f <> "" Then FileCreatedDate = f.DateCreated Else MsgBox "Missing data in path file --...
  5. C

    Function to find Access .accdb file's date created?

    Is there a function I could use to find the date listed in the "date created" property of an Access file?
  6. C

    How to use variables in a VBA Update statement?

    Can someone tell me the syntax for using variables in a VBA update statement? I have the following that I want to use to update a record field. Dim thisTbl as String If Answer = vbYes Then If MedicationInvNo2 <> "" Then thisTbl = "tblMyMedData" Else thisTbl = "tblMedData"...
  7. C

    How do I open one Access form at a time?

    [SOLVED] How do I open one Access form at a time? I have two forms set to open if the queries listed below have existing records and the SyncData button is clicked. What I want to happen is this: if the first query has records, open the form. After the user is done with this form, if records...
  8. C

    EOF is not being recognized in recordset?

    That was it! Thanks!
  9. C

    EOF is not being recognized in recordset?

    I have a form with a query set up as the record source. If there are records in this query, the form will display. When the user clicks a button, if there is another record in this query, the form displays the next record. When it gets to the EOF, it should close this form, but EOF is not being...
Back
Top Bottom