Form only show one record at a time, what gives?

P

pgarcia

Form has auto number and it's still producing the next number in the
sequence. There is around 1600 records but it's only showing 1. If you close
and open the form, it's show 1 again. My user my have done something to the
settings, but know, they said they did not touch the settings. Help!!
 
H

Hunter57

Hi Pgarcia,

It may be that the form has been set to open in data entry mode. You can
check it by opening the Form's Properties sheet, clicking the Data tab and
look to see if Data Entry is set to Yes. If it is, change it to No and that
should take care of the problem.

If that does not work you can open the form in design view and check the
Form Open, Form Load, Form Activate events to see if you see something like
this:

DoCmd.GoToRecord , "YourFormName", acNewRec

The acNewRec is what you are looking for. You can delete the whole line of
code or replace acNewRec with acLast which will open the last record.

Please let us know if you solve the problem.

Hunter57
 
J

Jeff Boyce

If a form's Data Entry property is set to yes, it only shows a blank/empty
form ready for data entry.

If a form's navigation property is turned off, it only shows the first
record in the underlying data set.

Do either of these offer an idea?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
P

pgarcia

Ah, yes, my user change the view to Data Entry. Change it back an now it's
fine. Can I lock down the form so that I am the only one that can change the
settings?
 
P

pgarcia

See reply to Hunter27

Thanks

Jeff Boyce said:
If a form's Data Entry property is set to yes, it only shows a blank/empty
form ready for data entry.

If a form's navigation property is turned off, it only shows the first
record in the underlying data set.

Do either of these offer an idea?

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
J

Jeff Boyce

One approach would be to convert the front-end to an .MDE file, which
removes the user's ability to modify the forms, etc.

Or you might look into removing the user...<g-just a joke!>

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
H

Hunter57

Hi,

Glad it was easy to fix.

Here is what I know and I am NOT an expert:
The answer to your question is yes, but to truly lock it down you would have
to use VBA code (not recommended if you are not very good at VBA or Access)
or Access Security. But you have to be very careful lest you lock everybody,
including yourself, out of the DB! If you want to go this route I suggest
you do some research first until you understand the process.

In the meantime, and this may be adequate for your needs, you can open the
Form's Properties Sheet, click on the Other tab, and down at the bottom of
the sheet set the "Allow Design Changes" to "Design View Only".

This will mean that you cannot just right click on the form or a control and
change its properties. You have to use the menu or a toolbar.

And the most important thing of all: Make a copy of your DB and keep it
somewhere safe!

Then if someone changes one of your forms or reports you can delete that
form or report and import it back in from your copy. Importing Forms and
Reports will have no effect on your actual data. But if you import a table,
you will loose any data in that table that was added after you made your copy.

Someone else may have a better solution about your DB security.

Hunter57
 
Top