 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / January 2008New Record question
DoCmd.Close acForm, "Invoice Database Launch", acSaveYes DoCmd.OpenForm "Invoice Tracker New Entry", acNormal Application.Forms("Invoice Tracker New Entry").Caption = "CREATE INVOICE" DoCmd.GoToRecord , , acNewRec When I use the above code. It creates a blank record in the datasheet. Is there a way to delete the record if it is blank and keep the record if there are data in it? There is always a new, empty record at the end of a datasheet unless you have set AllowNewRecords to False, or your query is not updateable.  SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > DoCmd.Close acForm, "Invoice Database Launch", acSaveYes > DoCmd.OpenForm "Invoice Tracker New Entry", acNormal [quoted text clipped - 6 lines] > there > are data in it? Thanks Arvin. So, how would I delete empty records from the database using code when the form closes. I would like to delete any blank records that are created in the datasheet when the form used to add records to the datasheet is closed. > There is always a new, empty record at the end of a datasheet unless you > have set AllowNewRecords to False, or your query is not updateable. [quoted text clipped - 8 lines] > > there > > are data in it? The empty record I am talking about is a placeholder, not a real record. SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > Thanks Arvin. > So, how would I delete empty records from the database using code when the [quoted text clipped - 15 lines] >> > there >> > are data in it? Thanks Arvin. I found another post on here that kinda show me how to do what I needed to do, using DoCmd.RunCommand. > The empty record I am talking about is a placeholder, not a real record. > > Thanks Arvin. [quoted text clipped - 16 lines] > >> > there > >> > are data in it? |
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
|
©2009 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.