Results 1 to 8 of 8

Excel/Access update records

Threaded View

  1. #1
    Registered User
    Join Date
    07-19-2013
    Location
    United Kingdom
    MS-Off Ver
    Office 2007
    Posts
    89

    Question Excel/Access update records

    Good morning,

    Im a little confused as to how to get this to work.
    I have a userform that when filled in sends the data to MS Access to store as a database. (i have to use it this way as users dont have use of Access I can only use it to store data)

    However, there is a time where the record thats been added needs to be changed.

    How do I code a button to locate the record to be able to update? If the users are adding a unique reference everytime.

    Ideally, I'd want the empty boxes to populate with what the record states so this can be changed..
    (ps. Excel & Access 2007)

    Thanks in advance.
    Last edited by Raanan; 02-18-2014 at 07:41 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] need to be able to update records with button click and delete records sample included
    By unreal11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2013, 11:45 PM
  2. Excel Table to Access Records
    By GBR2L in forum Excel General
    Replies: 3
    Last Post: 12-10-2010, 04:59 PM
  3. Linking Access Records to Excel
    By MayraEllen in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-21-2006, 02:40 PM
  4. Access Records into Excel
    By KJGradwell in forum Excel General
    Replies: 2
    Last Post: 10-04-2005, 02:05 AM
  5. [SOLVED] export access to excel. change access & update excel at same time
    By fastcar in forum Excel General
    Replies: 0
    Last Post: 06-24-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1