Results 1 to 3 of 3
  1. #1
    arn0ldas is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Jul 2014
    Posts
    3

    Specisic user form

    Hello my friend i have some problem i need user form for table in access but i'm not sore can i create like this
    Click image for larger version. 

Name:	uotrauka2.jpg 
Views:	12 
Size:	158.7 KB 
ID:	17257
    In red column parameters for each row in green column. in access table its must be look like this


    Click image for larger version. 

Name:	Nuotraukos3.png 
Views:	13 
Size:	19.5 KB 
ID:	17259
    How to create this user form
    Attached Thumbnails Attached Thumbnails Nuotrauka 1.jpg  

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Interesting. What are you trying to do in plain English? There may be options. What is your database about? Please show us your table designs.

  3. #3
    thebigthing313 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2014
    Posts
    119
    From what I can gather, your database isn't normalized. You have the data in the top portion which should be stored in one separate table, and then the subrecords below which would be stored in another separate table, linked to the first table using the ID number.

    If you insist on keeping your structure, your form would need to use VBA code to store your data in that manner.

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

Similar Threads

  1. Replies: 6
    Last Post: 11-30-2013, 02:41 PM
  2. Replies: 10
    Last Post: 10-22-2013, 07:35 AM
  3. Import Word form to Access form as new record (user friendly)
    By bbrazeau in forum Import/Export Data
    Replies: 1
    Last Post: 04-30-2013, 12:00 PM
  4. Replies: 1
    Last Post: 12-11-2011, 11:48 AM
  5. Replies: 1
    Last Post: 03-07-2011, 10:48 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