Results 1 to 4 of 4
  1. 07-10-2013, 12:00 AM #1
    gringotani
    gringotani is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Posts
    5

    verify the ship-to mailing address fields in an Access table

    Please recommend a reliable method to verify the ship-to mailing address fields in an Access table, before I batch export the addresses to stamps.com. If the ship to address is invalid, I need to update the “status” field to status “hold”. I do not know VBA, but I do know Access queries and macros.



    Thank you very much in advance, Nathaniel
    Reply With Quote Reply With Quote
  2. 07-10-2013, 01:14 AM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,644
    What determines the address is not valid?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  3. 07-10-2013, 08:10 PM #3
    gringotani
    gringotani is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Posts
    5
    Quote Originally Posted by June7 View Post
    What determines the address is not valid?
    the address validity, would be determined by looking up the given address in an online directory.
    Reply With Quote Reply With Quote
  4. 07-11-2013, 12:46 AM #4
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,644
    Which online directory? I have no idea if that is even possible. Programming VBA to interact with web pages is not easy.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Creating a maile merge from a preferred mailing address
    By pbouk in forum Access
    Replies: 4
    Last Post: 11-06-2012, 12:38 PM
  2. Query those table fields ONLY that have a website address
    By snowboarder234 in forum Queries
    Replies: 3
    Last Post: 11-01-2012, 04:44 PM
  3. tblAddresses OR address fields in tblCustomers
    By 123seven in forum Database Design
    Replies: 3
    Last Post: 04-09-2011, 05:34 PM
  4. Custom Fields from OUtlook Address book
    By Mikeydee135 in forum Import/Export Data
    Replies: 0
    Last Post: 03-22-2011, 07:46 AM
  5. Import Lotus Notes address book into a MS Access table.
    By acheo in forum Import/Export Data
    Replies: 0
    Last Post: 02-19-2007, 02:43 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