Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    New Lounger
    Join Date
    Aug 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Forms (Access 2000)

    I have forms that when i view them I can see the header, but I can not see any of the fields. When I change to the details view all the fiels are there and i can modify. This started when i fixed my relationships issue.

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

    Re: Access Forms (Access 2000)

    Welcome to Woody's Lounge!

    What do you mean by 'details view'? Is that datasheet view, or something else? And can you tell us something more about the design of a a problem form and its record source?

  3. #3
    New Lounger
    Join Date
    Aug 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Forms (Access 2000)

    I mean the design view. I apologize I am trying to teach myself. I am not sure what you mean in the second half of your response. I created a data base with multiple tables and one of the table has a key field. That table is the mother field. i then created multiple forms for each table. I then created a main page that upon clicking on the button {button contains close,openform (opens the mother form and adds a form for entries)}.The mother page opens fine. on the mother page i created tabs with sub forms on each tab. at that point i only have two of the ten forms that are visible, but like I said I can see all the forms in design view but i can only see the headers in normal view. Thank you for the quick response.

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

    Re: Access Forms (Access 2000)

    If I understand correctly, you have a form (the "mother form") that contains several subforms, but the subforms don't show any records. I assume that the "mother form" does display records, and also that the subforms do display records if you open them by themselves, directly from the database window. It so, there must be a problem with the way the subforms are linked to the "mother form". This is regulated through the Link Child Fields and Link Master Fields properties of the subform as a control on the mother form. You will find these properties in the Data tab of the Properties window. You can check if these are filled in correctly.

  5. #5
    New Lounger
    Join Date
    Aug 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Forms (Access 2000)

    There is no data in the forms yet. The forms are just a blank gray sheet with a header.

  6. #6
    New Lounger
    Join Date
    Aug 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Forms (Access 2000)

    I have to go so i will pick this up tomorrow morning thanks again.

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Forms (Access 2000)

    Did the Allow Additions property from the subforms are set to yes ?
    Francois

  8. #8
    New Lounger
    Join Date
    Aug 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Forms (Access 2000)

    Yes the allow additions is set to yes. Any other ideas. I will be sending screen shots of my problems in a few minutes.

  9. #9
    New Lounger
    Join Date
    Aug 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Forms (Access 2000)

    Here are a few screen shots of my problem. tell me what you think and if there are anyother shots you need to see.There are 4 emails coming with attachments on all.

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

    Re: Access Forms (Access 2000)

    Your second attachment is identical to the first one. You can edit it to replace it by the one you intended.

  11. #11
    New Lounger
    Join Date
    Aug 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Forms (Access 2000)

    Sorry the attachments are going out yet.

  12. #12
    New Lounger
    Join Date
    Aug 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Forms (Access 2000)

    <P ID="nt"><font size=-1>(No Text)</font>

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

    Re: Access Forms (Access 2000)

    I'm afraid these screenshots are not going to help us solve the problem. Could you post a stripped-down copy of the database? See <post#=401925>post 401925</post#> for instructions.

  14. #14
    New Lounger
    Join Date
    Aug 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Forms (Access 2000)

    Thanks I am working the issue with zipping it.

  15. #15
    New Lounger
    Join Date
    Aug 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Forms (Access 2000)

    I am having trouble with making it fit to 100 k the smallest i got it down to is 8 mb.

Page 1 of 2 12 LastLast

Posting Permissions

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