S
seeker
I would like a form to open in a new record. How can that be done.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
KARL DEWEY
Set the Data Entry property to Yes.
Bear in mind that this will only allow entering new records, no viewing or
editing.
Bear in mind that this will only allow entering new records, no viewing or
editing.
D
Douglas J. Steele
For the form's Load event, use code like:
Private Sub Form_Load()
DoCmd.GoToRecord, acActiveDataObject, Me.Name, acNewRecord
End Sub
Private Sub Form_Load()
DoCmd.GoToRecord, acActiveDataObject, Me.Name, acNewRecord
End Sub
A
Access WannaBe
This works great with Access 2003, but when I try it with Access 2007 it
gives me a VB error. I've tried several different metthods, each give me a
VB error.
gives me a VB error. I've tried several different metthods, each give me a
VB error.
D
Douglas J. Steele
What error(s) are you getting? (pretty hard to diagnose problems without
knowing...)
knowing...)
L
Larry Linson
Douglas J. Steele said:What error(s) are you getting? (pretty hard to
diagnose problems without knowing...)
What's the matter, Doug, did you let your membership to "Access Psychics"
lapse? <GRIN>
Larry
D
Douglas J. Steele
Larry Linson said:What's the matter, Doug, did you let your membership to "Access Psychics"
lapse? <GRIN>
I had to make a decision. I couldn't handle being in both "Access Psychics"
and "Access Psychos". <g>
J
John W. Vinson
I had to make a decision. I couldn't handle being in both "Access Psychics"
and "Access Psychos". <g>
Oh no... we've gone on from being junkies to being psychos!
We're up to six or eight Normal Forms - do we need a twelve-step program
instead?
A
Access WannaBe
Visual Basic Run-Time Error--you can't go to the specified record.
I changed the code to:
Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub
It works great with Access 2003, but I get the run time error with Access
2007.
I make fun of people when they come into my store and expect me to read
their mind....I now know how it happens. I'm glad to see everyone has a good
sense of humor, but are you still willing to help me.
Thanks.
Chad
I changed the code to:
Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub
It works great with Access 2003, but I get the run time error with Access
2007.
I make fun of people when they come into my store and expect me to read
their mind....I now know how it happens. I'm glad to see everyone has a good
sense of humor, but are you still willing to help me.
Thanks.
Chad
D
Douglas J. Steele
Are you sure the form's updatable? If it isn't, you can't go to a new
record.
record.
A
Access WannaBe
It was a "read only" setting on a network forlder. Thanks for your help.