Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post
    I'm having a devil of a time with Access 2007. I'm trying to insert a datasheet view subform into a form, and It just doesn't work. I created the datasheet form, but upon dragging it onto my main form it changes the format from datasheet to tabular (or something similar).

    Another bothersome change from previous Access versions is that when adding a field to a form I cannot delete the field name separate from the field itself. If I try to delete the field name it also deletes the field. What am I missing here?

  2. #2
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi Chuck,

    I'm not having the same issue dragging the DS onto another form, I guess you've set the default view to 'datasheet' and that's the only thing I can see that determines how it displays. There is no subform property that changes its behaviour.

    As for the second, you can still create DS forms the old way using Create>From Design. The method you used here where you selected Create>More Forms> Datasheet creates a form where the controls act differently.

    The labels are part of the control and determine the column header (no difference there) but you can't delete them. All the controls are the same width and evenly spaced but here is the 'useful' bit - you can drag a control up or down and Access automatically rearranges all the other controls so it fits nicely and they are all equally spaced. This also changest the order of the columns in the DS view.

    So you can still use the old way but once you get used to then new DS you will find it quite nice.

    One thing that still annoys me is that setting the controls visible property to false doesn't stop it showing in DS view. You need to set its ColumnHidden property in the open event.

  3. #3
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post
    I discovered Ihad to turn off the Layout feature before 2007 acts like the older versions. I sometimes get very frustrated with Access's attemps to "help" me. Many of these built-in feature are more hinderance than help. I recall the Main Menu feature which I found terribly complicated and confusing whereas a little VB coding on my part would result in a very simple, straightforward main menu.

  4. #4
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    I sometimes get very frustrated with Access's attemps to "help" me.
    Many of these built-in feature are more hinderance than help.
    Very True.
    Andrew

Posting Permissions

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