+ Reply to Thread
Results 1 to 2 of 2

How to add multiple data rows at once from UserForm to Excel DataBase

  1. #1
    Registered User
    Join Date
    03-13-2019
    Location
    Manchester, UK
    MS-Off Ver
    365
    Posts
    1

    How to add multiple data rows at once from UserForm to Excel DataBase

    Hi everyone,

    I understand that you cannot write my code for me, but I am just a bit stuck on even where to begin. If you can point me in the right direction, that would be great. I am working on an exam booking calendar database for work to replace the existing simple but annoying one we've got.

    On the first tab, I have a calendar display and it is conditional formatted. So red if the day is booked full, and green if not full, gray if there're no exams on that day. Now we have two exam rooms and remote exam option. Each exam room can only accommodate 12 people and no limits for remote.

    I have managed to make a form of sort next to the calendar where people can pick the days where there are exams and the table shows who have been booked on these days. The table shows:
    - Name
    - Exam to be sat
    - Status (Confirmed, booked, cancelled)

    Ideally, what I want to do is:

    - This form can also be a data entry form. So people look at the date, see there is availability, put in the names, click save and the new data only is fed into a database. obviously later on, if people go into this date again, they'll see the newly updated names as well.
    - If a learner cancels, I can go onto the database, change their status to "Cancelled" and this learner won't show in the list.
    - Limit the number of entries/ seats if they are in person exams, so only 12.

    I know this sounds super complicated. I think I might have bitten off more than I can chew. Work didnt ask me to do this, but I have the form we have now and I want to make some improvements.

    Any suggestions and feedbacks are appreciated.
    Thao

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: How to add multiple data rows at once from UserForm to Excel DataBase

    .
    Best to post your workbook.

+ 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. Organize multiple rows and columns of data into a database format
    By smd71092 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-05-2016, 12:02 PM
  2. Userform, Search, copy an paste data from a userform database to another sheet.
    By masro in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2015, 02:42 PM
  3. Multiple Users input data using Excel Userform to a Common Access Master Database
    By eummagic in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-08-2014, 01:45 AM
  4. ACcess Database, userform excel, multiple user at the same time.
    By sagar.rajula in forum Access Tables & Databases
    Replies: 6
    Last Post: 04-26-2013, 02:35 PM
  5. 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
  6. Replies: 0
    Last Post: 11-12-2012, 03:09 PM
  7. Multiple Users of VBA Userform, all data saved to one database
    By oliver_l in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-22-2010, 01:41 AM

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