Restore size Datasheet View Form on top of Maximized Form

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Alan Forsyth
    #1

    Restore size Datasheet View Form on top of Maximized Form

    That rather long subject says it.
    In Access97 running on XP - I want to display a Maximized size Form01, then
    open a Restore size Datasheet View Form02 on top of the first Form.

    PopUp won't give me Datasheet view.
    Dialog mode won't give me Datasheet view

    I could make Form01 Restore size and expand it to fill the Window in
    Restore size (maybe DoCmd.MoveSize Right, Down, Width, Height) - I don't
    want this.

    I could imitate a Datasheet with Form02 in Form Display mode - I don't want
    to do that.

    Access97 doesn't have WindowMode:=acD ialog
    Pity.

    OK, where am I wrong or what have I missed? It can be done?

    Thanks,
    Alan Forsyth
    Tags: None
    • Tom van Stiphout
      #2
      Re: Restore size Datasheet View Form on top of Maximized Form

      On Fri, 23 May 2008 02:16:31 -0500, Alan Forsyth <Not@iHome.nzwr ote:

      You have some unusual requirements. What exactly is the difference
      between a maximized form and a form of maximum size?

      Anyway, you can always have datasheet view if you put a subform in
      datasheet view on an unbound form.

      -Tom.

      >That rather long subject says it.
      >In Access97 running on XP - I want to display a Maximized size Form01, then
      >open a Restore size Datasheet View Form02 on top of the first Form.
      >
      >PopUp won't give me Datasheet view.
      >Dialog mode won't give me Datasheet view
      >
      >I could make Form01 Restore size and expand it to fill the Window in
      >Restore size (maybe DoCmd.MoveSize Right, Down, Width, Height) - I don't
      >want this.
      >
      >I could imitate a Datasheet with Form02 in Form Display mode - I don't want
      >to do that.
      >
      >Access97 doesn't have WindowMode:=acD ialog
      >Pity.
      >
      >OK, where am I wrong or what have I missed? It can be done?
      >
      >Thanks,
      >Alan Forsyth

        Comment

        • Alan Carpenter
          #3
          Re: Restore size Datasheet View Form on top of Maximized Form

          Comments inline.
          On Fri, 23 May 2008 02:16:31 -0500, Alan Forsyth <Not@iHome.nzwr ote:
          >
          You have some unusual requirements. What exactly is the difference
          between a maximized form and a form of maximum size?
          "A Form of Unusual Size." :-)

          A distinction I should have made more clear, perhaps with:
          "Full Screen" to mean Maximized.
          "Very Large Form" to mean a form in Restore View, made as large as
          possible. (That's not an option for my "background " Form.)

          Anyway, you can always have datasheet view if you put a subform in
          datasheet view on an unbound form.
          You're right. It still won't look or act the same as a Restore Size
          Datasheet View form (User resizing is an issue) and I may be able to get
          closer to that appearance with the continuous form (which also has resize
          issues.)
          Users expect EXACTLY the same as a Query Datasheet.

          Thanks, Tom. that's something I hadn't considered.

          Alan Forsyth
          >
          -Tom.
          >
          >
          >>That rather long subject says it.
          >>In Access97 running on XP - I want to display a Maximized size Form01,
          >>then open a Restore size Datasheet View Form02 on top of the first
          >>Form.
          >>
          >>PopUp won't give me Datasheet view.
          >>Dialog mode won't give me Datasheet view
          >>
          >>I could make Form01 Restore size and expand it to fill the Window in
          >>Restore size (maybe DoCmd.MoveSize Right, Down, Width, Height) - I
          >>don't want this.
          >>
          >>I could imitate a Datasheet with Form02 in Form Display mode - I don't
          >>want to do that.
          >>
          >>Access97 doesn't have WindowMode:=acD ialog
          >>Pity.
          >>
          >>OK, where am I wrong or what have I missed? It can be done?
          >>
          >>Thanks,
          >>Alan Forsyth
          >

            Comment

            Previous template Next
            Working...