Results 1 to 4 of 4

Difficault add new Record Problem (Thanks Expert)

  1. #1
    ey54025192 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    4

    Post Difficault add new Record Problem (Thanks Expert)

    VBA add record problem, how to do this result?? Thanks a lot!!



    Click image for larger version. 

Name:	2018-05-16_152605.png 
Views:	9 
Size:	21.6 KB 
ID:	34040

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    4,288
    You will have to provide much more information. Why is this a vba problem and not a query problem? Does Field03 exist in the table? Why should each combo value go into the table in the same order as you are showing (there doesn't seem to be any relationship between any combo and any particular date or name). You have not really named things as you are showing??

    This looks like pseudo data (something made up that doesn't really represent the real situation).
    - "doesn't work" is no help. What's happening? Error messages? Where??
    - Use code tags for code/sql. Implement changes in copies of your database.
    Irregardless, ain't no such word as "reoccur".

  3. #3
    ey54025192 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    4
    I don't know how to write code about like this situation.

    We want to distribute the goods to different shop, and record it in list view, but it is more easy to enter distributed data in a form.

    but i don't how to write a code using loop field name + number adding a record so please help.

    Click image for larger version. 

Name:	2018-05-16_161448.png 
Views:	9 
Size:	35.7 KB 
ID:	34041

    Thanks

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    4,288
    This is not a code issue; it's a query issue. Query language (sql) is not code. I'm not understanding why you keep asking about code.

    Using the design tools from the Ribbon Create tab,
    - create your table.
    - create a select query based on the table (include all the table fields you need)
    - open the query in datasheet view
    - if you can enter valid data in all your query fields, then create a form based on this query and add your data through the form

    Based on the (still) scant information you've provided, I see no reason for a combo box versus a text box, but if you know how to bind a combo to a table AND create its row source, then by all means, do so if that's what makes sense. ***What doesn't make sense*** - having a different combo box for each of 20 records for one field. 20 combos would be 20 fields, not records.
    i don't how to write a code using loop field name + number adding a record
    The meaning of that statement is still unclear. I/we are supposed to guess what field name? What number? I can't help if you can't provide enough information. Not much of this is making sense.

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

Similar Threads

  1. What would you do? Simple for a expert!
    By QuickJeff in forum Database Design
    Replies: 2
    Last Post: 07-04-2016, 01:52 AM
  2. expert of access please help me..
    By noel17m in forum Access
    Replies: 1
    Last Post: 02-20-2012, 08:57 AM
  3. Access Expert
    By golfit007 in forum General Chat
    Replies: 1
    Last Post: 08-14-2011, 10:01 PM
  4. Replies: 3
    Last Post: 08-02-2011, 01:44 PM
  5. Need Expert Help!! Thank you!
    By Antflash in forum Access
    Replies: 3
    Last Post: 08-18-2010, 04:09 PM

Posting Permissions

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