Results 1 to 7 of 7
  1. #1
    chetana is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2018
    Posts
    11

    By Selecting Shape of material automatically dimension should change according to shape

    Hi,
    How to design form for dimension of the shape.
    By Selecting Shape of material automatically dimension should change according to shape,Please refer images attached.In below images i mentioned about 3 shapes according to shape dimensions will change like for Round it shows Diameter and length,for Square Width and length, for Sheet Thickness,width and length.


    How to create this access forms?
    Click image for larger version. 

Name:	Round.JPG 
Views:	18 
Size:	19.6 KB 
ID:	41963Click image for larger version. 

Name:	Square.JPG 
Views:	18 
Size:	19.4 KB 
ID:	41964Click image for larger version. 

Name:	Sheet.JPG 
Views:	18 
Size:	21.4 KB 
ID:	41966
    Attached Thumbnails Attached Thumbnails Hexagonal.JPG  

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In the table that holds the shapes,other columns would be the dimensions:
    Round,diam,length
    Square ,wid,Len.

    All these are in the combo box as extra columns, when user picks shape.(but hidden)
    then in the AFTER UPDATE event,fill in the 'labels' of the entry boxes:

    Code:
    sub cboShape_afterupdate()
    Lbl1.caption=cboShape.column(0)
    Lbl2.caption=cboShape.column(1)
    End sub
    NOTE: in vb, columns begin with zero.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Maybe you would provide a little background on what you are trying to accomplish?
    You could use a tab control or a subform for each shape to be displayed. Are the controls bound or unbound?

    Have you created a dB that you would post?

    Really don't understand what you are trying to do.....

  4. #4
    chetana is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2018
    Posts
    11
    I'm trying to create form which includes material details in that by selecting shapes it should automatically select its dimensions . Form is unbound.
    Click image for larger version. 

Name:	shape.JPG 
Views:	11 
Size:	17.3 KB 
ID:	41984

    Insted of X Y Z, if i select round shape it should show to enter diameter and length ,if square width and length Ex:As shown in below picture..I want this kind of selection.
    Click image for larger version. 

Name:	Round.JPG 
Views:	11 
Size:	19.6 KB 
ID:	41985Click image for larger version. 

Name:	Square.JPG 
Views:	11 
Size:	19.4 KB 
ID:	41986

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I agree with Steve --some context would be helpful.
    What exactly does this mean
    automatically select its dimensions
    ?
    Perhaps you could give us an example or 2.
    Shape would not provide the weight unless you also gave specific gravity or density??
    And cost is very unlikely to be a constant?? Just look at the price of gasoline or lettuce at the moment.

  6. #6
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    How many shapes do you have? If only a few, I would use a main form with tabs for each shape. The subforms on the tabs would accommodate the peculiarities for that shape.

  7. #7
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    +1 for Ranman's solution. The combo box could even hold the filename of a shape diagram image file to swap out in an image control much like your examples show.

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

Similar Threads

  1. Shape of Buttons
    By tgall in forum Forms
    Replies: 7
    Last Post: 03-08-2016, 12:53 PM
  2. Setting the right shape of a form
    By Lou_Reed in forum Access
    Replies: 5
    Last Post: 09-25-2015, 11:41 AM
  3. Button ontop of a shape
    By Damo10 in forum Forms
    Replies: 2
    Last Post: 08-05-2015, 12:00 PM
  4. Hierarchical reports with ADO shape
    By schetlur in forum Reports
    Replies: 0
    Last Post: 07-30-2009, 12:21 PM
  5. Shape of data on report
    By stvgarner in forum Reports
    Replies: 0
    Last Post: 06-15-2009, 01:28 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
  •  
Other Forums: Microsoft Office Forums