Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Datasheet form (Access 2000)

    I have a datasheet form based on a query.

    1. How can I change the column headings? (Changing the field labels in form view, or using the Caption fields in the field properties in the query didn't work, and using alias names in the query worked in the query only.)

    2. Why does the form open in form view when I access it with a shortcut that I have created on the desktop, even though Datasheet is set as the default view? I have other Datasheet forms with shortcuts and they don't do this.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Datasheet form (Access 2000)

    Heavens to Murgatroyd! Yet another thread!

    1) Open the form in design view. If the text boxes bound to the query's fields have a label attached, change the caption of the labels. If one or more text boxes do not have an attached label, proceed as follows:
    - Create a label with the desired caption.
    - Cut the label to the clipboard (Ctrl+X)
    - Select the text box it should be attached to.
    - Paste the label (Ctrl+V)
    The captions of attached labels will act as column headings.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Datasheet form (Access 2000)

    Murgatroyd,
    Even though the default view for your form is Datasheet, when opened from another location (ie another form), the view must be specified as acFormDS.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Datasheet form (Access 2000)

    I don't know of a way to make a desktop shortcut to a form open it in datasheet view. As a workaround, create a macro that opens the form in datasheet view, and put a shortcut to the macro on the desktop.

  5. #5
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Re: Datasheet form (Access 2000)

    1. The text boxes bound to the query's fields do have labels attached, and as mentioned I tried changing the caption of the labels, but it didn't work. However, I have now tried changing the Name property of the fields themselves, and that does work.

    2. Are you able to advise what could cause the form to open in form view when accessed via a shortcut from the desktop even though the default is set as datasheet view, and it opens correctly in datasheet view when opened from within Access?

  6. #6
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Re: Datasheet form (Access 2000)

    That works fine, thanks.

Posting Permissions

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