Results 1 to 2 of 2

Thread: [RESOLVED] Access checking recordset to keep from duplicating upload

  1. Mar 21st, 2008, 10:31 AM #1
    ameek
    ameek is offline

    Thread Starter
    New Member ameek's Avatar
    Join Date
    Mar 2008
    Location
    Ohio
    Posts
    2

    Resolved [RESOLVED] Access checking recordset to keep from duplicating upload

    I am trying to link some code to a button so that if a vendor has already been loaded into the table it will not load them again. Any ideas? Thanks
    Reply With Quote Reply With Quote
  2. Mar 21st, 2008, 12:24 PM #2
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: Access checking recordset to keep from duplicating upload

    Well, FIRST... this thread needs to be moved... this is the Forum Testing area.... not the place for questions that need to be answered.

    Secondly, check the table, if the Vendor is in the database, don't insert it. If it isn't, then insert it.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width