Why can I not see my data in record form?`

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rhianne - 26 Sep 2007 16:48 GMT

I have noticed that I can only continue to see my data in record form prior
to when I save and close my database.
It does not show in the table until I have saved and closed, either.
This is not such a huge problem because at least the data is being stored in
the table. However I did think it would be possible for me to view the
records in Form view - is there a way inwhich I can do this?

Reply to this Message

SteveM - 26 Sep 2007 19:48 GMT

Data does not get written into tables until you save, move to another record
or close the form. This is by design.

I don't understand what you are trying to do...

Can you explain that a bit clearer?
What data in what tables?

Steve

> I have noticed that I can only continue to see my data in record form prior
> to when I save and close my database.
> It does not show in the table until I have saved and closed, either.
> This is not such a huge problem because at least the data is being stored in
> the table. However I did think it would be possible for me to view the
> records in Form view - is there a way inwhich I can do this?

Reply to this Message

Linq Adams - 26 Sep 2007 23:36 GMT

It sounds like he has the DataEntry for the form set to Yes, in which case
the data is visible until it's saved and then *Poof!*

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Reply to this Message

Rhianne - 27 Sep 2007 14:23 GMT

yes "she"(!) does. That's what happens - I enter my info in form view and
then once it's saved and I close it down it poofs!!

So do I alter Dataentry to NO then?

Thanks! Rhianne

> It sounds like he has the DataEntry for the form set to Yes, in which case
> the data is visible until it's saved and then *Poof!*

Reply to this Message

John Spencer - 27 Sep 2007 17:25 GMT

If you have DataEntry set to yes on a form, it opens the form to a new
record (and does not show any prior existing records). It does "keep" the
records for the current entry session, but when you close the form and open
it again, the process starts over.

The records are saved.

If you wish to see ALL the records then set Date Entry to NO.

Signature

John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

> yes "she"(!) does. That's what happens - I enter my info in form view and
> then once it's saved and I close it down it poofs!!
[quoted text clipped - 6 lines]
>> case
>> the data is visible until it's saved and then *Poof!*

Reply to this Message

John W. Vinson - 27 Sep 2007 17:58 GMT

>yes "she"(!) does. That's what happens - I enter my info in form view and
>then once it's saved and I close it down it poofs!!
>
>So do I alter Dataentry to NO then?

Exactly. The purpose of the DataEntry property of a form is to make the form
useful *ONLY* for entering new records. Old records are there in the table,
just not displayed on the form.

If you want the form to routinely open to the new record so you can add data,
but allow you to view old records as well, put the following code in the
form's Load event:

Private Sub Form_Load(Cancel as Integer)
DoCmd.GoToRecord acForm, Me.Name, acNewRecord
End Sub

John W. Vinson [MVP]

Reply to this Message

Rhianne - 28 Sep 2007 10:37 GMT

Thank you for your help -

but where do I find Form Load event to enter that code?

Plus where is the Datatype so that I can alter it to no. Thanks!!

> >yes "she"(!) does. That's what happens - I enter my info in form view and
> >then once it's saved and I close it down it poofs!!
[quoted text clipped - 14 lines]
>
> John W. Vinson [MVP]

Reply to this Message

John W. Vinson - 28 Sep 2007 21:21 GMT

>Thank you for your help -
>
>but where do I find Form Load event to enter that code?

Open the Form in design view. On the Menu select View... Properties; or right
mouseclick the little square at the upper left intersection of the rulers and
select Properties.

On the Events tab one of the events is the Load event. Click the ... icon next
to it after selecting it, and choose Code Builder. Access will put you into
the VBA editing window, with a Sub and End Sub line. Just edit it to what I
posted. The actual event should show

[Event Procedure]

when you're done.

>Plus where is the Datatype so that I can alter it to no. Thanks!!

Data Entry - not datatype - is one of the form Properties. Scroll down the
list.

John W. Vinson [MVP]

Reply to this Message

Linq Adams - 29 Sep 2007 14:33 GMT

Sorry about the "he" Rhianne! The circus (6 kids plus 13 grandkids) was
swirling around me and I was having a problem focusing!

Have a great weekend!

Linq

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Reply to this Message

Rhianne - 01 Oct 2007 10:36 GMT

I have done all that - thanks for your help!

Another question though - is there anyway that I can now have my already
existing information showing in record form? Obviously that is all in table
form, but I would like it to appear in record form also - so as to make it
more user friendly.

> >Thank you for your help -
> >
[quoted text clipped - 19 lines]
>
> John W. Vinson [MVP]

Reply to this Message

John W. Vinson - 01 Oct 2007 18:30 GMT

>I have done all that - thanks for your help!
>
>Another question though - is there anyway that I can now have my already
>existing information showing in record form? Obviously that is all in table
>form, but I would like it to appear in record form also - so as to make it
>more user friendly.

I guess I don't understand what you mean by "record form".

Data is stored in the table.

You can have one form, two forms, a dozen forms if you want, all bound to that
table. A Form can be in Single view (showing one record at a time), Datasheet
view (looking like a table datasheet), or Continuous view (showing multiple
records but with much more flexibility of layout than a datasheet).

If you want to see the data onscreen use a form.

John W. Vinson [MVP]

Reply to this Message

Rhianne - 02 Oct 2007 11:37 GMT

I want to be able to see what is stored in my tables through form view.

I have altered the database properties so new information I am inputting,
the form view still exists. But what I want to do now is have the info stored
in my table showing in form view also. So that I can open the form view and
see all the info from my table displayed - I use the terminology record by
mistake then. Sorry!

> >I have done all that - thanks for your help!
> >
[quoted text clipped - 15 lines]
>
> John W. Vinson [MVP]

Reply to this Message

John W. Vinson - 02 Oct 2007 18:11 GMT

>I want to be able to see what is stored in my tables through form view.

Fine. Base a Form on the Table and open the form.

>I have altered the database properties so new information I am inputting,
>the form view still exists.

I know of no "database property" which does this. What change did you actually
make?

>But what I want to do now is have the info stored
>in my table showing in form view also.

What ARE you seeing? What do you WANT to see? If you had 33182 records in the
table would you want to see 33182 records on the screen simultaneously? (good
monitor you've got there if so!) Or do you want to be able to scroll from one
record to another?

>So that I can open the form view and
>see all the info from my table displayed - I use the terminology record by
>mistake then. Sorry!

You CAN. But I do not know what you are doing, what you are seeing, or what
you expect to see.

Please post the following information:

The Recordsource property of the Form
The number of records in the table
The Default View property of the form
The Data Entry property of the form
The Filter property of the form
What you are seeing on the form (just describe it)
What you want to see on the form (and don't say "all the records", we know
that; describe how you want to see them)

John W. Vinson [MVP]

Reply to this Message