Search results

  1. H

    Validate Duplicates when importing excel

    Hi, I have code written which imports excel data to a access table and I want to validate it to prevent importing the duplicates. How can I do that? Thanks. My code is below, Public Function FolderSelection() As String Dim objFD As Object Dim strOut As String strOut =...
  2. H

    runtime error 3075

    DoCmd.RunSQL (" SELECT (LEA , SO_ID , CRM_ORDER , SO_STATUS , TASK_NAME , TASK_STATUS , TASK_WG , ASSIGNED_DATE , CLOSED_DATE , ACCOUNT_NO , SERVICE_TYPE , ORDER_TYPE) FROM All_Detail" & _ "...
  3. H

    runtime error 3075

    DoCmd.RunSQL (" SELECT (LEA , SO_ID , CRM_ORDER , SO_STATUS , TASK_NAME , TASK_STATUS , TASK_WG , ASSIGNED_DATE , CLOSED_DATE , ACCOUNT_NO , SERVICE_TYPE , ORDER) FROM All_Detail" & _ "...
  4. H

    Compile Error : Expected : end of statement

    I got it thank you Colin.:D:D
  5. H

    Compile Error : Expected : end of statement

    )Thank you Colin it corrected by, "WHERE Main.[Report_Date]='" & Me.rd.Value & "'". But what you mean by no join between tables?? :confused: I am sorry I am new to access VBA.
  6. H

    Compile Error : Expected : end of statement

    Hi I design SQL statement in access and now i want it run through button using VBA. but I got end of statement. I don't have idea to fix it. Dim sqlImport As String sqlImport = "" sqlImport = sqlImport & "INSERT INTO Main ( Report_Date, LEA, CRM_ORDER, SO_ID, SO_STATUS...
  7. H

    Import specific columns in excel to access table using button

    Isn't DoCmd.TransferSpreadsheet import all the fields? I don't want all and the columns that I want are not in order.
  8. H

    Import specific columns in excel to access table using button

    Hi! How can I import data from excel to existing table in access using button? User is selecting the excel file from windows explorer and I want to program to enter only some columns to access table. And I am inserting date from form too.
Top Bottom