Results 1 to 4 of 4
  1. #1
    nYgus is offline Novice
    Windows 8 Access 2016
    Join Date
    Feb 2018
    Posts
    2

    form designe

    At the beginning sorry for my english. It can be incomprehensible and my problem can be impossible to understand, a and that's why I enclose a screenshot to illustrate the goal.


    Could you tell me if there is any way to do this and how?
    A form shoud look like datasheet (the ability to change the size of the columns), and row record would be like one element ( not like editable text boxes, even though they are blocked for editing) which i can select with a hover and do operations like delete (after select and choose menu button) or edit (after double click/menu button) from a submenu.

    Click image for larger version. 

Name:	screen.png 
Views:	12 
Size:	205.5 KB 
ID:	32702

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    if you view as a continuous form, then user can select a record, click a button in the Form Header to open a detail form

    docmd.openform "frmDetail",,,"[id]=" & txtID

  3. #3
    nYgus is offline Novice
    Windows 8 Access 2016
    Join Date
    Feb 2018
    Posts
    2
    Quote Originally Posted by ranman256 View Post
    if you view as a continuous form, then user can select a record, click a button in the Form Header to open a detail form

    docmd.openform "frmDetail",,,"[id]=" & txtID
    Yes in continuous form user can select record by default selector but cannot resize columns at real time. I want hide selector and do a whole row to be able to click and select it

  4. #4
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,800
    I want hide selector
    A datasheet has record selectors as you probably noticed, and there's a reason for that. It's so that you don't have to go to a lot of effort to be able to select the entire row and press Delete to delete the record. To want to disable or remove the selector and still select the entire row for deletion makes no sense. You could do something with a continuous form view, but as you noted, changing column widths isn't possible. I see no way to do what you want, which as I said, makes no sense based on the information you provided. If you're simply trying to make your form look like some other application, then I'm afraid you're out of luck.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. How to designe Database
    By waqas in forum Database Design
    Replies: 2
    Last Post: 09-15-2011, 12:34 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