+ Reply to Thread
Results 1 to 6 of 6

Creating a simple database by user input

  1. #1
    Registered User
    Join Date
    05-04-2019
    Location
    Iceland
    MS-Off Ver
    2016
    Posts
    15

    Thumbs up Creating a simple database by user input

    Hello

    Could you tell me how to do this please?

    Screenshot_1.jpg
    I also have attached the Excel file


    I would like to do these:
    *When a random user open this file, and enter his/her name and amount of sales, he will click the "Add to the list" button and these inputs + date & time info will be transferred into the table

    *Each click to "Add to the list" button, should add those 4 info after the latest filled row of the table.

    *Users of this file should not be able to make changes in any cell in the table, without entering the correct password
    Attached Files Attached Files
    Last edited by neutral5; 11-24-2019 at 10:23 AM.

  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: Creating a simple database by user input

    .
    Here is some basic code from a small database project.
    You should be able to study this code and apply it to your situation.

    Please Login or Register  to view this content.
    Let me know if you have difficulties.
    Attached Files Attached Files

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Creating a simple database by user input

    Hi Neutral,

    Excel has a Data Entry Form.. already built in! You simply need to show it on your Quick Access Toolbar. Instead of writing your own VBA code to do this, use the one already there. Here is some instructions:

    https://www.dickinson.edu/download/d...entry_form_pdf
    or better is:
    https://www.excel-easy.com/examples/...s-toolbar.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    05-04-2019
    Location
    Iceland
    MS-Off Ver
    2016
    Posts
    15

    Re: Creating a simple database by user input

    Quote Originally Posted by MarvinP View Post
    Hi Neutral,

    Excel has a Data Entry Form.. already built in! You simply need to show it on your Quick Access Toolbar. Instead of writing your own VBA code to do this, use the one already there. Here is some instructions:

    https://www.dickinson.edu/download/d...entry_form_pdf
    or better is:
    https://www.excel-easy.com/examples/...s-toolbar.html
    Thank you, but with this way, users of this file will be able to make changes in any cell in the table

  5. #5
    Registered User
    Join Date
    05-04-2019
    Location
    Iceland
    MS-Off Ver
    2016
    Posts
    15

    Re: Creating a simple database by user input

    Quote Originally Posted by Logit View Post
    .
    Here is some basic code from a small database project.
    You should be able to study this code and apply it to your situation.

    Please Login or Register  to view this content.
    Let me know if you have difficulties.

    Thank you so much, applied this. However, came across with this problem:
    User should not be able to change anything in the table manually without entering a certain password. But at the same time, form of the macro should be able to add new log rows

    Edit: Solved this issue as well by adding 2 rows for unprotection&protection
    Last edited by neutral5; 11-24-2019 at 10:22 AM.

  6. #6
    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: Creating a simple database by user input

    .
    Glad you were able to apply it to your project.

+ 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. [SOLVED] creating a database from existing database by user choice
    By almostgenius in forum Excel General
    Replies: 5
    Last Post: 05-29-2015, 05:29 PM
  2. Managing a simple database by reading and creating text files
    By ppgab in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2015, 04:36 PM
  3. Replies: 11
    Last Post: 07-31-2014, 08:41 AM
  4. Creating Database from Input Form
    By geissler05489 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2013, 11:04 AM
  5. [SOLVED] creating a folder with an user input filepath and user input folder name
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-04-2012, 10:04 AM
  6. Simple User Input Button
    By HeebieGeebie in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-16-2012, 11:25 AM
  7. Creating a serach-database for various input
    By HenkE\\\ in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-26-2007, 10:41 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