Date enty form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a form and I want to see all previous items in the form. Exampel 1
of 31 records but when I select Data entry No the 1 of 31 appears for a brief
moment. When I close the form and go back in to look at it again, the form
shows 1 of 1 again. How do I fix this to stay at 1 of 31. I do not have
problems with any of the the other forms I have have created.
 
I don't believe data entry allows you to view records, only add them. So
just set data entry to No.
 
If a form is set as data entry, then that is the correct functionality.

If you want to see all records, then turn off the data entry property.
 
The response did not help at all. Let's try it again. History - I have
several forms where I can see 1 record of 28 and I can scroll through and
view all records. This new form will not stay in the data entry mode. When
the form comes up, I see a new form ( 1 of 1 record) - this is not what I
want to see. I want to see 1 of 27 records because I have users that has to
add data to this form and need to see the amounts that has already been
entered in Oct, Nov, Dec, etc. and not start a new form over again. I want
the form to come up with filled information and show the fiields that need to
be filled also.
 
You say there are 27 records. Do you want to pull up the form with a
particular record displayed?

You say you want them to see the information filled in and also show fields
that need to be filled in. That does not make much sense. In any given
record, there are fields. If a record is added to the database and some
fields are filled in, but some are not the record can be saved (unless you
have required the fields). If you have 27 records in your table and each
has some data missing, what do you want the user to see?

You can code your form to jump to a specific record, but you are not making
it clear which record you want.

To have the user see 1 of 27, simply turn off the data entry property and
add code to jump to the first record (number 1) when the form opens.

Note that the record number is not something you should be using to identify
which record you need. Normally you would have some other unique field in
your table to help you identify the appropriate record.
 
Yes, I have 27 records and I want the form to display the 1st record - (1 of
27). I want to be able to display the data in the next record (2 of 27). I
have a table that shows a list of employees with monthly payments for Health
Insurance - Oct, Nov, Dec, Jan, Feb- ( Amounts filled in). Mar, Apr, May
(pending payment - blanks, to be filled). I want the user to be able to pull
the form up with the data that they have already entered and fill in the
payment for Mar and then next month pull the form up again (able to see Oct,
Nov, Dec, Jan, Feb, Mar) and filled in Apr, and so on. Not pull up a new
form an type all information over again which creates another entry line and
no data for Oct, Nov, Dec, Jan, Feb, Mar.
 
I will let someone else jump in here. It sounds to me like your table is
poorly designed. Are you saying that your table has a field for each month
in which a payment should be made? If so, your design is wrong. Your field
names should never contain data (like the name of a particular month).
Maybe I misunderstand though.

To answer your underlying question though, turn off data entry mode. That
way all records will be displayed. In the open event of the form, simply
tell it to go to the first record...

DoCmd.GoToRecord ,,acFirst
 
adarr said:
The response did not help at all. Let's try it again. History - I
have several forms where I can see 1 record of 28 and I can scroll
through and view all records. This new form will not stay in the
data entry mode. [snip]
Click to expand...

The problem is that your definition of "Data Entry Mode" is not what Access
means by "Data Entry Mode".

To Access, "Data Entry Mode" means you want the form to be used to enter new
records ONLY and have no interest in seeing previously entered records. If
you DO want to see previously entered records then you need to turn that
feature off.
 
Adarr,

I can't comment on your table structure, but I don't think you are
understanding Jay and Rick's recommendation.

Access objects, including Forms and Controls, have Properties that can be
set that affect how the object behaves. Forms have a Data Entry property,
that, if set to Yes, opens with a blank record. To set it to No, which will
let you browse through existing records, open the form in Design View and
choose View, Properties from the menu.

Choose the Data tab, move to the DataEntry field, and select or type No, and
save the form.

Hope that helps.

Sprinks
 
Back
Top