+ Reply to Thread
Results 1 to 3 of 3

Iissue Creating Data Base. Please Help!!

  1. #1
    Registered User
    Join Date
    08-01-2012
    Location
    roanoke
    MS-Off Ver
    Excel 2003
    Posts
    5

    Iissue Creating Data Base. Please Help!!

    I have issue crating a data base and Query. every time i select Name, DOB option button and hit Enter Data. the data is not getting saved for the Party ID.

    Please if someone can help me out set it up I like if I select the Name, DOB, or any other option button is selected that it will show in the data base for the Party ID if i hit Enter Data and for the Enter Data button needs to refreshes for me so i can input the next Party ID,
    Attached Files Attached Files

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

    Re: Iissue Creating Data Base. Please Help!!

    Hi damdam,

    Where should we start. You have a TABLE where the data is saved. In the table you have fields that you can define as different type of information. You need to look at the DESIGN of the table you are trying to keep you data in. You have a field called "Name" which stores a number. That is just wrong!! You need to start by creating a Table that has the correct types of fields to store your data. THEN, and only after you have a good table do you create a FORM that puts stuff into the table. I'd suggest you use the FORM WIZARD to create your first few forms. It will ask what table you want this form to use/add/edit data from. This then binds this new Form to the Table.

    It seems to me you are trying to create a good looking Form that is supposed to save data, BEFORE you have told it where to save the data. It is just a little backwards. Perhaps reading is needed?? See: http://office.microsoft.com/en-us/ac...010341808.aspx for starters.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Iissue Creating Data Base. Please Help!!

    In addition to Marvin's suggestion, you should read the white paper at this link for an understanding of how to set up a RDBMS

    http://www.deeptraining.com/litwin/d...asedesign.aspx
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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