Hi Crystal
I wrote that while I was meditating.
"Ommm...." Or maybe it was just fat-fingering the keyboard. It's hard to tell in that state.
Bill
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> Hi Bill,
>
> speaking of "ommission" ... you can omit an "m" from that word ;)
>
> Warm Regards,
> Crystal
>
> *
> (: have an awesome day :)
> *
>
>
>
> ________________________________
> From: Bill Mosca
>
> You're welcome, Connie. I've noticed a few places where you added parens that aren't necessary, but better over-kill than ommission.
>
> Bill
>
> --- mrsgoudge <no_reply@> wrote:
> >
> > Bill and John,
> >
> > Thank you! I don't know what got into me. I must have gotten bit by the bug parentheitis. Your responses helped me to understand the use of quotes etc. Hopefully it will stick in my brain ;-)
> >
> > Connie
> >
> > --- mrsgoudge <no_reply@> wrote:
> > >
> > > Good morning/whatever it is where you are!
> > >
> > > I'm getting Type mismatch error.
> > >
> > > The code:
> > > -HomeInfo form
> > > -ParcelNbr textbox
> > > -AfterUpdate event
> > > -Goal of the code is to check to see if there's another entry in the HomeInfo table with the same County and ParcelNbr and if so give a message saying that this property is already in the database.
> > >
> > > ParcelNbr is text field
> > > ContactID is a long integer in both the HomeInfo table and the County_List table.
> > >
> > > When I hover Me.ParcelNbr = "12-0045-000" and Me.CountyID.Column(0) = "1" If I change it to Me.CountyID then when I hover Me.CountyID = 1. Either way I get the message.
> > >
> > > Many thanks!
> > > Connie
> > >
> > > 'If ParcelNbr in the same County exists in the HomeInfo table
> > > If Not IsNull(DLookup("ParcelNbr", "HomeInfo", ("ParcelNbr = """ & Me.ParcelNbr & """") And ("CountyID = " & Me.CountyID.Column(0)))) Then
> > > MsgBox "This Parcel Nbr is already in the database." & vbNewLine & _
> > > "Use Ctrl F to find the property."
> > > Me.Undo
> > > DoCmd.GoToControl "ParcelNbr"
> > > End If
> > >
> >
>
> [Non-text portions of this message have been removed]
>
Rabu, 12 Oktober 2011
[MS_AccessPros] Re: Type mismatch that I can't figure out
__._,_.___
MARKETPLACE
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar