Tags: access, auto, database, form, microsoft, mysql, number, oracle, producing, record, records, showing, sql, thesequence, time

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

On Database » Microsoft Access

6,059 words with 6 Comments; publish: Sun, 01 Jun 2008 14:57:00 GMT; (250265.63, « »)

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!!

All Comments

Leave a comment...

  • 6 Comments
    • 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

      "pgarcia" wrote:

      > 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!!

      #1; Sun, 01 Jun 2008 14:58:00 GMT
    • 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

      "pgarcia" <pgarcia.ms-access.todaysummary.com.discussions.microsoft.com> wrote in message

      news:33A052BF-CA42-4370-B9D0-F3B01542676E.ms-access.todaysummary.com.microsoft.com...

      > 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!!

      #2; Sun, 01 Jun 2008 14:59:00 GMT
    • 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?

      "Hunter57" wrote:

      [vbcol=seagreen]

      > 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

      > "pgarcia" wrote:

      #3; Sun, 01 Jun 2008 15:00:00 GMT
    • See reply to Hunter27

      Thanks

      "Jeff Boyce" wrote:

      > 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

      > "pgarcia" <pgarcia.ms-access.todaysummary.com.discussions.microsoft.com> wrote in message

      > news:33A052BF-CA42-4370-B9D0-F3B01542676E.ms-access.todaysummary.com.microsoft.com...

      >

      >

      #4; Sun, 01 Jun 2008 15:01:00 GMT
    • 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

      "pgarcia" <pgarcia.ms-access.todaysummary.com.discussions.microsoft.com> wrote in message

      news:0CD3F660-7AD6-46C8-91C3-DA00008A1FE2.ms-access.todaysummary.com.microsoft.com...[vbcol=seagreen]

      > See reply to Hunter27

      > Thanks

      > "Jeff Boyce" wrote:

      #5; Sun, 01 Jun 2008 15:02:00 GMT
    • 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

      "pgarcia" wrote:

      [vbcol=seagreen]

      > 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?

      > "Hunter57" wrote:

      #6; Sun, 01 Jun 2008 15:03:00 GMT