Search results

  1. A

    Runtime error '3075'

    Hi All, I am getting "Run-time error '3075'" syntax (missing operator) in query expression '((([GRN_Account Details].[WBS Element]) Is Null Or (([GRN_Account Details].[WBS Element])="") " & _ OR (((Left([GRN_Account Details].[WBS Element],4))=""GB.9""));' while executing the following code...
  2. A

    Error while creating pivot with odbc

    Hi All, I am using Excel 2010 and access 2010 versions. I am trying to create a pivot based on a ".csv" file. With the help of previous posts in this forum, I have written the below codes. But I am getting runtime error 5 "Invalid procedure call or argument" in the below code...
  3. A

    Error in navigating excel range through Access

    Hi All, I have created the following code that deletes the existing data and copies the data from another excel and refreshes the file before closing. I am getting error in the step ws1.Range("A2:" & ActiveCell.Address(0, 0)).Select. Below is the full code. Please help. Sub...
  4. A

    Need text box in form for changing Linked files path

    Hi All,:) I am new to access and to this forum. I am having a database with tables linked to excel and text files from two different folders. I need a text box in a form were I can give the path to the linked files so that it gets picked up. The reason is if the database in used by different...
  5. A

    Hello All

    Hello All, I am a beginner in access. Interested in learning more. Need all your support. Thanks, aganesan99
Back
Top Bottom