Results 1 to 6 of 6
  1. #1
    MikiA is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2020
    Posts
    5

    Insert data into table

    Hello,

    I have fields on the form as in the picture.
    There can be over a hundred different people.
    Second text box was date of creating entry.
    It is set to the default value of current day for every
    time i open the form.
    Third and fourth text box is for numeric values.
    I bound text boxes to the table field.
    Set form to the data entry YES.


    So, when i open form and make entry at the first text
    box i got same values at all text boxes at the form.
    I believe this is because the text box is linked to the same field in the table.
    I mean workink hours to the field 1, extra hours to the field 2....
    Behind the name is a hidden text box with id values ​​for the given name.


    Does anyone have any idea how to do this?
    Should I set the fields to unbound and use the sql statement to enter data into the table?
    Attached Thumbnails Attached Thumbnails Untitled.jpg  

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    I'm not sure what the problem is with your form but posting a copy of the db would help with that.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    MikiA is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2020
    Posts
    5
    I just stated and stuck with this. I use access button for adding records at the form. I upload sample database, so maybe will be understable wht i try to do.
    Attached Files Attached Files

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    I'm afraid your db makes no sense to me. You have NO relationships defined.
    I don't understand the language, of course, but on the form you appear to have the names of people in Label controls.

    IMHO from what I have seen, I would recommend you to read up on database design and normalization.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    I agree with Bob. I don't understand your database nor its intended usage. Since it's in foreign language (possibly Croatian??), I don't think many members will readily understand it either. I recommend you provide a brief description in non-database terms of what "processes" this database is intended to support. Further, I recommend that you write it in your native language; then translate to English (Google translate) and post.
    Good luck.

    Nadalje, preporučujem da ga napišete na svom materinjem jeziku; zatim prevedite na engleski (Google translate) i objavite.
    Sretno.

  6. #6
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,250
    Please have a look and see if that is what you were trying to achieve.

    Cheers,
    Vlad
    Attached Files Attached Files
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 16
    Last Post: 04-02-2020, 04:49 PM
  2. Replies: 1
    Last Post: 11-19-2018, 06:53 PM
  3. Replies: 3
    Last Post: 08-23-2015, 12:11 PM
  4. Replies: 1
    Last Post: 06-12-2015, 02:02 PM
  5. Replies: 5
    Last Post: 12-01-2014, 11:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums