Results 1 to 8 of 8
  1. 02-21-2015, 12:46 PM #1
    Rich1968
    Rich1968 is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Jan 2015
    Posts
    27

    Update Qry


    Hello all,

    I have a hyperlink field in a table. It is formatted "K:\1234123.pdf"

    I want to Update the field to read "C:\PDFFolder\1234123.PDF

    I have been playing with the replace function but it's never right. Any help would be appreciated.

    Thanks

    Rich
    Reply With Quote Reply With Quote
  2. 02-21-2015, 01:43 PM #2
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    Have you tried using an Update query
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  3. 02-21-2015, 06:21 PM #3
    Rich1968
    Rich1968 is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Jan 2015
    Posts
    27
    Yes Bob that's exactly what I have tried but it's not doing what I want it to do.
    Reply With Quote Reply With Quote
  4. 02-22-2015, 03:09 AM #4
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    EDITED:
    Can you show us the query's SQL statement
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  5. 02-22-2015, 03:59 AM #5
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    Can you show us the query's SQL statement
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  6. 02-27-2015, 01:44 PM #6
    Rich1968
    Rich1968 is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Jan 2015
    Posts
    27
    Hey Guys...I figured it out. Thanks for all your help
    Reply With Quote Reply With Quote
  7. 02-27-2015, 01:49 PM #7
    orange's Avatar
    orange
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Rich,

    If you post your solution, it may just help someone else with a similar issue.
    AccessFunctions_SyntaxAndExamples TechontheNet
    M$oftVBA Function Details
    Debugging VBA and Error Handling
    Links to articles re Database Planning and Design
    DataPig Videos Revived DataPig Queries
    DataPig Form Basics
    Reply With Quote Reply With Quote
  8. 02-27-2015, 01:49 PM #8
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    Quote Originally Posted by Rich1968 View Post
    Hey Guys...I figured it out. Thanks for all your help
    Care to tell us about your solution?
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. After Update event, loop function - Update two tables from a form
    By luv2birdie in forum Database Design
    Replies: 6
    Last Post: 11-05-2014, 05:27 PM
  2. Update Query Criteria - ensure source string is not zero length before update target
    By davem05 in forum Queries
    Replies: 7
    Last Post: 08-26-2013, 06:05 AM
  3. Having trouble using update query to update fields within the same field using logic.
    By Steven Seagal in forum Queries
    Replies: 2
    Last Post: 08-30-2012, 07:59 AM
  4. Is an update query with user input of data to update TO, possible?
    By Owl in forum Queries
    Replies: 4
    Last Post: 11-10-2011, 03:41 PM
  5. Large SQL Server table linked to Access datasheet is slow to update on first update
    By slevine in forum Access
    Replies: 1
    Last Post: 01-22-2011, 12:23 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums