Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Forms help

Discussion in 'Information Technology' started by chantalbertrand1@gmail.com, Oct 28, 2005.

Tags:
  1. chantalbertrand1@gmail.com

    chantalbertrand1@gmail.com
    Expand Collapse
    Guest

    I have created a form in Access Design View that links to a couple of
    tables; however, when I look at it in form view, it appears to be
    blank. Can someone tell me why this may be happening?
     
  2. Loading...

    Similar Threads Forum Date
    USA Akaal Takhat Forms Committee to Represent US Sikhs Breaking News Sep 13, 2013
    India Poll reforms on crash course Breaking News Sep 7, 2013
    General A Conversation about the Grammatical Forms of Raam and Simran Hard Talk Dec 1, 2011
    India Anna Says Fast Only "Suspended", Wants Electoral Reforms Breaking News Aug 28, 2011
    India India Announces $5 bn Aid for Africa, Seeks Support for UN Reforms Breaking News May 24, 2011

  3. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    Do you mean blank as in text boxes etc. are empty, or blank as in text boxes
    etc. are not visible at all?

    If the latter, this happens when the form's recordset returns no records,
    and the AllowAdditions property is set to 'No'.

    --
    Brendan Reynolds


    <chantalbertrand1@gmail.com> wrote in message
    news:1130427820.616817.63750@g44g2000cwa.googlegroups.com...
    >I have created a form in Access Design View that links to a couple of
    > tables; however, when I look at it in form view, it appears to be
    > blank. Can someone tell me why this may be happening?
    >
     
  4. Rick B

    Rick B
    Expand Collapse
    Guest

    oops. pressed enter too soon...

    also, there are no records to be displayed.

    --
    Rick B



    <chantalbertrand1@gmail.com> wrote in message
    news:1130427820.616817.63750@g44g2000cwa.googlegroups.com...
    >I have created a form in Access Design View that links to a couple of
    > tables; however, when I look at it in form view, it appears to be
    > blank. Can someone tell me why this may be happening?
    >
     
  5. Rick B

    Rick B
    Expand Collapse
    Guest

    Do a search. This is asked and answered all the time.

    Your data set is not updateable, and you have the form set to not allow
    additions.


    --
    Rick B



    <chantalbertrand1@gmail.com> wrote in message
    news:1130427820.616817.63750@g44g2000cwa.googlegroups.com...
    >I have created a form in Access Design View that links to a couple of
    > tables; however, when I look at it in form view, it appears to be
    > blank. Can someone tell me why this may be happening?
    >
     
  6. Sprinks

    Sprinks
    Expand Collapse
    Guest

    By "links to a couple of tables", I presume you mean the form's RecordSource
    property is set to a query containing the two tables. If this is the case:

    - Run the query itself to see if it is returning any records.
    - Check the form's Data Entry property. If it is set to Yes, the form will
    display no existing records.

    Sprinks

    "chantalbertrand1@gmail.com" wrote:

    > I have created a form in Access Design View that links to a couple of
    > tables; however, when I look at it in form view, it appears to be
    > blank. Can someone tell me why this may be happening?
    >
    >
     
  7. chantalbertrand1@gmail.com

    chantalbertrand1@gmail.com
    Expand Collapse
    Guest

    I have set the Allow additions to "Yes", however, the form continues to
    be blank. The entire form is blank. I cannot see any of the text
    booxes or labels I have created.
     
  8. Rick B

    Rick B
    Expand Collapse
    Guest

    Is the query updateable? If you open the query can you add a record?

    Are there any records in your query. If you open the query, do you see any
    existing records?

    "allow additions" was only ONE of the issues.

    --
    Rick B



    <chantalbertrand1@gmail.com> wrote in message
    news:1130431340.856603.91080@z14g2000cwz.googlegroups.com...
    >I have set the Allow additions to "Yes", however, the form continues to
    > be blank. The entire form is blank. I cannot see any of the text
    > booxes or labels I have created.
    >
     
  9. chantalbertrand1@gmail.com

    chantalbertrand1@gmail.com
    Expand Collapse
    Guest

    It's not a query, it's a form. I haven't yet created the query. I
    also have no data in the tables yet. I am creating a form for other
    users to input the data.
     
  10. Rick B

    Rick B
    Expand Collapse
    Guest

    Okay, a form is normally based on a query. What is the record source for
    this form? Are you basing it directly on a table? Typically, you would not
    do this. In most cases, you'd filter the data down in a query first.

    If your form is only based on a table, then make sure the form allows
    additions. Also, make sure the user who is signed on can insert data into
    that table.

    If all else fails, just go add a record in the table to get the ball
    rolling, then try to open your form.

    --
    Rick B



    <chantalbertrand1@gmail.com> wrote in message
    news:1130432805.819498.25960@g14g2000cwa.googlegroups.com...
    > It's not a query, it's a form. I haven't yet created the query. I
    > also have no data in the tables yet. I am creating a form for other
    > users to input the data.
    >
     
  11. Rick B

    Rick B
    Expand Collapse
    Guest

    Ummmm. You said it links to "a couple of tables". How'd you pull that off
    if you are not using a query as your record source?


    --
    Rick B



    <chantalbertrand1@gmail.com> wrote in message
    news:1130432805.819498.25960@g14g2000cwa.googlegroups.com...
    > It's not a query, it's a form. I haven't yet created the query. I
    > also have no data in the tables yet. I am creating a form for other
    > users to input the data.
    >
     
  12. chantalbertrand1@gmail.com

    chantalbertrand1@gmail.com
    Expand Collapse
    Guest

    I guess I may have gone about this a little backwards, I am trying to
    create a form that allows data entry into the table, without having to
    use the actual table. THis is so that the employees entering the
    information will not be able to move to the next field without filling
    in each required field. Right now the table is empty, as I am not the
    one that holds the required information.
     
  13. Rick B

    Rick B
    Expand Collapse
    Guest

    Requiring the employee to make entries as they move from control to control
    has nothing to do with whether or not your form is bound to a table.

    That would be accomplished by using code in your control's exit events or
    enter events. Probably a bad idea unless you really want to force them to
    enter data in exactly the order you require. (In my opinion)

    Unless you are a very advanced Access developer, step back and start from
    the beginning. You are trying to build an aircraft carrier when you've
    never even build a dinghy. :)

    Build a form based on your table (or a query). If you require the data in a
    particular field, set it as required in your table. Once you do this, and
    use it a time or two, then you can start tweaking the form.

    (In my opinion)

    --
    Rick B



    <chantalbertrand1@gmail.com> wrote in message
    news:1130440378.346449.230370@g44g2000cwa.googlegroups.com...
    >I guess I may have gone about this a little backwards, I am trying to
    > create a form that allows data entry into the table, without having to
    > use the actual table. THis is so that the employees entering the
    > information will not be able to move to the next field without filling
    > in each required field. Right now the table is empty, as I am not the
    > one that holds the required information.
    >
     
  14. chantalbertrand1@gmail.com

    chantalbertrand1@gmail.com
    Expand Collapse
    Guest

    That is great advise. I will surely use it. I am still at a loss in
    reference to my first question though; and that is, why is my form
    blank when I go from Design View to Form view. I have changed my Allow
    deletion field to "Yes", and still nothing. I have tried deleting the
    form and creating a new one, and still, my Form view remains blank. I
    have also, after reading your previous answer, tried to create a query
    (although I do not yet have any information in my tables to pull) and
    then creating the form from the query. Yet, the form remains
    completely blank in Form view. What am I missing?
     
  15. Rick B

    Rick B
    Expand Collapse
    Guest

    What is the data source of your form? Is it bound to a table?

    You said you allowed "deletions". That is not important. Can you ADD data?

    If the form is based on a table, can the user add records to that table?

    --
    Rick B



    <chantalbertrand1@gmail.com> wrote in message
    news:1130441700.241016.182900@g14g2000cwa.googlegroups.com...
    > That is great advise. I will surely use it. I am still at a loss in
    > reference to my first question though; and that is, why is my form
    > blank when I go from Design View to Form view. I have changed my Allow
    > deletion field to "Yes", and still nothing. I have tried deleting the
    > form and creating a new one, and still, my Form view remains blank. I
    > have also, after reading your previous answer, tried to create a query
    > (although I do not yet have any information in my tables to pull) and
    > then creating the form from the query. Yet, the form remains
    > completely blank in Form view. What am I missing?
    >
     

Share This Page