Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Aug 2003
    Stroud, United Kingdom
    Thanked 0 Times in 0 Posts

    Datasheet view Qs (97)

    Morning all, hope peeps is well

    What i am wondering is if there is anyway to do the following with a form in datasheet view...

    1. Double click on the record selector on the side of the form to fire an event, ie using the double click rather than selecting the record and then using a command button to open another form with that record in it.

    2. Stop users being allowed to resize the widths of the form?

    btw, if Charlotte reads this - thanks for a previous thread that you wrote on Public variables in other forms. I now know they have to be referenced from other forms! Cheers [img]/forums/images/smilies/smile.gif[/img]

    ok, thanks


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Datasheet view Qs (97)

    1. When the user double clicks a record selector, the On Dbl Click event of the Form is fired.

    2. If you mean the form as a whole, set the border style of the form to something else than Sizable. If you mean the column widths, don't use datasheet view. You can create a continuous form that looks like a datasheet view.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts