Re: Not in List

Tech-Archive recommends: Speed Up your PC by fixing your registry

You are mad... I'd go back to bed if I were you. I get in for 8:30am and that
is bad enough!

Sue

"David C. Holley" wrote:

> While you're out, can you pick up a girlfriend for me? And yes its 5:50
> am and I'm headed back out to work.
>
> hughess7 wrote:
> > Thanks guys, I will do some searching for more info and David's mind ;-)
> >
> > Sue
> >
> > "David C. Holley" wrote:
> >
> >
> >>You have to set the RESPONSE to the value telling Access what has
> >>happened (I've added data, ignore the error; I haven't added data,
> >>display the error; I haven't added data, don't display the error).
> >>Access VBA help has more specific information and the return values
> >>(possibly some code as well). Using the NotInList event is quite common,
> >>you shouldn't have problems finding how-to-articules and examples on the
> >>internet if you do a google.
> >>
> >>David H
> >>P.S. While you're in help searching for more info, could you check to
> >>see if my mind is in there somewhere? After working 42 hours in 3 days,
> >>I'm not certain where I left it.)
> >>
> >>hughess7 wrote:
> >>
> >>>Hi all
> >>>
> >>>I have the following code to deal with adding new values to a combo box:
> >>>
> >>>Msg = "Do you want to add a new Currency?"
> >>>
> >>>If MsgBox(Msg, vbQuestion + vbYesNo, "New Currency") = vbyes Then
> >>> DoCmd.OpenForm "frm Currency"
> >>> DoCmd.GoToRecord , , acNewRec
> >>>End If
> >>>
> >>>I have chosen to open a popup form to create the new record as the user
> >>>needs to enter details in two fields (one being a description eg British
> >>>Pounds).
> >>>
> >>>The form opens correctly but Access still displays the Not in list standard
> >>>error message - is there a way to stop this?
> >>>
> >>>Thanks in advance for any help.
> >>>Sue
> >>
>
.

Relevant Pages

  • Re: Custom Forms - Outlook 2003 - Help !
    ... Have you installed Office 2003 Service Pack 1? ... Sue Mosher, Outlook MVP ... "David" wrote in message ...
    (microsoft.public.outlook)
  • Re: ***Ping*** DavidL
    ... into 3rd place in the stats for the month. ... Sue ... Hey, it's still March..... ... Thank you, David, for your supreme effort to take over 3rd place. ...
    (alt.support.stop-smoking)
  • Re: ***Ping*** DavidL
    ... but if you make 10 posts really quickly you can move ... into 3rd place in the stats for the month. ... Sue ... Thank you, David, for your supreme effort to take over 3rd place. ...
    (alt.support.stop-smoking)
  • Re: OT: Today In History.
    ... at both of you, Sue & David. ... meters as much as we can because it keeps our fingers busy being ...
    (alt.support.stop-smoking)