 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / April 2007Programing a database to use in business
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 > 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!?!? 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 > 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 [quoted text clipped - 4 lines] > Thank you, > Tonya 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. > Tonya, > Within in my contactdatabase I often use this feature. Entering a new [quoted text clipped - 13 lines] > > Thank you, > > Tonya I highly reccomend that you look at Access Data Projects MDB isn't reliable enough for real world usage > 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 [quoted text clipped - 4 lines] > Thank you, > Tonya |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.