+ Reply to Thread
Results 1 to 4 of 4

Realtime Excel database updating through userform

  1. #1
    Registered User
    Join Date
    09-17-2016
    Location
    SURREY, BC
    MS-Off Ver
    OFFICE 2016
    Posts
    5

    Realtime Excel database updating through userform

    Hi Excel Forum,

    I was wondering if there is a way to create a form that has the ability to retrieve data from a table and edit it in real time like MS Access. I need this form to have the ability to update records without the use of the update button, just simply edit and retreive data from a table into the from and edit in the form. I want to use the table as database just like Access uses a database as the source data form its forms.

    Is this possible or do I have to use Access or another software to accomplish this?

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Excel Database Help

    Yes it is possible. Assuming you understand how your form has managed to load a row of data to fill in your form fields, you could then use _Exit events on each of those fields that specifically writes the values from each field back into the source cell as you exit the field and move to the next field.

    Take care that you don't accidentally forget to create some way for the form to also update the last edited field even if you don't remember to exit the field, food for thought.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    09-17-2016
    Location
    SURREY, BC
    MS-Off Ver
    OFFICE 2016
    Posts
    5

    Re: Excel Database Help

    I see so I guess I' be watching some videos on how tot create such a form, do you have any suggestions?

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Realtime Excel database updating through userform

    Forms are not too difficult to learn. Plenty of info out there on how to build them and how to make them do fancy things.
    Perhaps if you could post a workbook with some sample data then we can help you along here.

    BSB

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Updating a database using a userform with text boxes
    By Quintin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-27-2014, 02:12 AM
  2. multi user, userform data can we store in access db on a realtime with 4 or 5 users
    By sagar.rajula in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2013, 07:12 AM
  3. Multiuser excel userform data can we store in access database on realtime with 4 or 5 user
    By sagar.rajula in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-25-2013, 09:18 AM
  4. Updating time in realtime based on city in preceding cell
    By bholabhala in forum Excel General
    Replies: 23
    Last Post: 01-12-2010, 04:53 PM
  5. Recall information from database onto userform for updating
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2009, 05:09 PM
  6. [SOLVED] updating database from excel
    By mangyan73 in forum Excel General
    Replies: 0
    Last Post: 11-07-2005, 11:35 AM
  7. realtime updating of one open excell file when changing another
    By bili in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-08-2005, 07:53 AM

Tags for this Thread

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