Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: quepi
  • Order by date
  1. quepi

    Weird autonumber issue

    Thanks Joe, That makes sense, but is there any way to get "10" back? or is it doomed to eternal data limbo? Even if we escaped out of it, shouldn't we still see it in the datasheet view as a "deleted" record? Thanks again for your advice. - Kris
  2. quepi

    Weird autonumber issue

    I've developed a simple form that uses an autonumber as the key field. For reasons I don't understand, when we finished entering the 9th record and went to enter a new record, the autonumber skipped "10" and went straight to "11" so that now the number of records doesn't jive...
  3. quepi

    Recordset error

    Dear Frustrated Student, Thank you so much!! You have solved my problem. Your first response did the trick. I had menu that allows people to rank five different opinions on a scale of 1 to 5. The last of these opinions is "other", which not everyone will choose and which I had left...
  4. quepi

    Recordset error

    Well, I checked the code, but it seems to check out ok. It reads as follows: Private Sub Addrecord_Click() On Error GoTo Err_Addrecord_Click DoCmd.GoToRecord , , acNewRec Exit_Addrecord_Click: Exit Sub Err_Addrecord_Click: MsgBox Err.Description Resume Exit_Addrecord_Click...
  5. quepi

    Recordset error

    Kathryn, Thanks for your response. Yes, the master table is the record source for the form. The form consists of about 6 tab sections that accommodate the different sections of a questionnaire. When the user reaches the end of the questionnaire, there are buttons to go back to the main menu...
  6. quepi

    Recordset error

    I'm getting the following error when trying to do test data entry on a form that incorporates several combo boxes based on tables that feed into a "master" table: "You can't go to the specified record. You may be at the end of a recordset." I have checked the properties of...

Part and Inventory Search

Back
Top