Programing a database to use in business

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

Guest

Hello, we are creating a database to use in a Pawn shop business. All
required areas have been set up but somehow we are not able to get it to
create a new record after the intial record is input and saved. Can someone
please help guide me on this relatively simple process that I have to be
overlooking!?!?

Thank you,
Tonya
 
Tonya said:
Hello, we are creating a database to use in a Pawn shop business. All
required areas have been set up but somehow we are not able to get it to
create a new record after the intial record is input and saved. Can
someone
please help guide me on this relatively simple process that I have to be
overlooking!?!?
Click to expand...

You will have to clarify, in detail, what you have and how you expect it to
work -- you, of course, have the database at hand, and can see that. We, on
the other hand, are remote so you have to explain it to us, precisely and
concisely, if we are to be able to assist.

It may well be a "relatively simple process", but it is not obvious to us
what that process is.

Larry Linson
Microsoft Access MVP
 
Tonya,
Within in my contactdatabase I often use this feature. Entering a new
contact and after saving (and all errorchecking etc) move on to a new record.
I do use a button (save contact) and at the end of all vba I use the command
DoCmd.GoToRecord , , acNewRec
for me it works fine.
Good Luck
Harry
 
I highly reccomend that you look at Access Data Projects

MDB isn't reliable enough for real world usage
 
What I am doing is using a form to take in information, Customer Info, item
info, price etc... At the bottom of the form I have a button that is supposed
to go to the next record. The code is down below, but somehow it never goes
to a new line or anything. The code is:

Private Sub New_Record_Click()
On Error GoTo Err_New_Record_Click


DoCmd.GoToRecord , , acNewRec

Exit_New_Record_Click:
Exit Sub

Err_New_Record_Click:
MsgBox Err.Description
Resume Exit_New_Record_Click

End Sub

Any help would be greatly appreciated. Everything I read seems to say this
is how I move onto a new record but I can't seem to get it to do it.
 
Back
Top