Results 1 to 2 of 2
  1. #1
    Alibaba66 is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    3

    replace one line of code with two lines of code

    I have this line of code in vba currently:
    Set conn = CurrentProject.Connection




    I would like to do a global replacement in current project with




    conn.ConnectionString =extractConnectionStringADOfromOLE


    conn.OPEN


    how can i do that using ms-access find and replace tool?


    I need to replace the one line of code with two line of codes using the find and replace tools
    i tried inserting a readable line break but the compiler produces an error ..


    thanks!

  2. #2
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,003
    Cross posted with answers here:
    https://www.access-programmers.co.uk...0-2021.330255/

    @Alibabba66 read here about Cross Posting: https://www.excelguru.ca/content.php?184\
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 07-20-2015, 02:26 PM
  2. Replies: 1
    Last Post: 11-11-2014, 03:54 PM
  3. lines of code
    By azhar2006 in forum Modules
    Replies: 6
    Last Post: 09-24-2014, 11:14 AM
  4. Replies: 2
    Last Post: 10-10-2013, 02:27 PM
  5. How to do line by line compare of VB code?
    By Buakaw in forum Access
    Replies: 2
    Last Post: 02-14-2011, 11:46 PM

Tags for this Thread

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