ACCESS FEED: RE: [MS_AccessPros] Required fields when using CurrentDb.Execute INSERT

Rabu, 26 Oktober 2011

RE: [MS_AccessPros] Required fields when using CurrentDb.Execute INSERT

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