Page 3 of 3 FirstFirst 123
Results 31 to 35 of 35
  1. #31
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    The problem is that there are quotes in the error message.

    Use: Replace(Err.Description,"'","")
    This will remove all of the single quotes in the Err.Description - this is causing the query not to run.

  2. #32
    subhasmita is offline Novice
    Windows 10 Access 2007
    Join Date
    Jul 2017
    Posts
    25
    Tried this too..still the same.

  3. #33
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    See post # 20.

  4. #34
    subhasmita is offline Novice
    Windows 10 Access 2007
    Join Date
    Jul 2017
    Posts
    25
    It worked now .. I have changed the table column format to for Err_Num and used Replace(Err.Description,"'","") and its printing both column.

    Thanks a lot.

  5. #35
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Glad to hear it, well done!

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import Excel file to MS Access
    By subhasmita in forum Import/Export Data
    Replies: 3
    Last Post: 07-27-2017, 03:24 PM
  2. Replies: 2
    Last Post: 02-28-2017, 01:34 AM
  3. Import Excel file based on a date and time in file name
    By nhylan in forum Import/Export Data
    Replies: 4
    Last Post: 04-16-2013, 03:26 PM
  4. Import Excel file to Access
    By emmett in forum Import/Export Data
    Replies: 3
    Last Post: 04-06-2012, 05:27 AM
  5. Link Excel file to MS Access and generate rep
    By Priceless in forum Import/Export Data
    Replies: 14
    Last Post: 02-21-2011, 02:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums