John and all,
1. Listings form is open. Add Xtra Parcel box is checked.
2. When focus is lost on that box, the unbound form "XtraParcelEntry" opens prompting the user for the HomeInfoID per John's suggestion.
3. On closing the XtraParcelEntry form, the code enters the ListID from the still open Listings form and the HomeInfoID from the XtraParcelEntry form into the ListingsHomeInfo table.
4. The Form ListingsHomeInfo is opened so they can see what they entered and make changes as needed.
Is step 3 above a good way to do it? My concern is relying on the "still open Listings form". I have my code below. I will be duplicating this type of event several times (replacing more risky code) so I want to be sure that I'm doing it right :-)
Thanks!
Connie
On Error GoTo Proc_Err
If (Me.XtraParcelNbr <> "") Then
'Create a new record
CurrentDb.Execute "INSERT INTO ListingsHomeInfo (ListID, HomeInfoID) VALUES (" & Forms!Listings.ListID & ", " & Me.XtraParcelNbr.Column(0) & ")", dbFailOnError
End If
If (Me.HomeID <> "") Then
'Create a new record
CurrentDb.Execute "INSERT INTO ListingsHomeInfo (ListID, HomeInfoID) VALUES (" & Forms!Listings.ListID & ", " & Me.HomeID & ")", dbFailOnError
End If
'Open form
DoCmd.OpenForm "ListingsXtraParcel", acFormDS, , "ListID = " & Forms!Listings.ListID
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Connie-
>
> I suppose you could prompt the user for the HomeInfoID with an unbound dialog
> form, then insert both values.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
> Sent: Wednesday, October 26, 2011 6:13 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Required fields when using CurrentDb.Execute INSERT
>
> John,
> I opened the form to a new record having the the ListID entered using code and
> then the user entered the HomeInfoID.
> Connie
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Connie-
> >
> > Do you not have the HomeInfoID to do the INSERT of both fields? How were you
> > doing it when you used a form?
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
> > Sent: Wednesday, October 26, 2011 5:55 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Required fields when using CurrentDb.Execute INSERT
> >
> > I am going through my code trying to change instances where I was opening a
> form
> > in order to create a new record to the better method of using the
> > CurrentDb.Execute INSERT method.
> >
> > I have a table ListingsHomeInfo where I had ListID and HomeInfoID as required
> > fields. Therefore when I entered the ListID using the CurrentDb.Execute
> method
> > it was asking for the HomeInfoID. So I'm guessing that I need to not require
> > HomeInfoID in the table but rather check to make sure that it is entered in
> the
> > Form's BeforeUpdate event. Is this correct?
> >
> > Thanks!
> > Connie
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar