Re: Checking for value in a table
- From: "tina" <nospam@xxxxxxxxxxx>
- Date: Fri, 23 Dec 2005 03:17:09 GMT
suggest you try using a DLookup() function, rather than opening a recordset
based on a SQL statement. see Access Help for more information on the
function. and btw, if you really have a field in your table named "Value",
suggest you change it. Value is a property of controls in forms and reports,
and using it as the name of something you created (a field in a table) may
very likely cause problems.
hth
"BobbyS" <BobbyS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4DD68FEB-20B9-4FF4-97C2-48178A4043CC@xxxxxxxxxxxxxxxx
> How would I write an SQL statement that would find the value (from a
variable
> strCheck) in a table (tblNames) in field named [Value]? and if that exists
> then GoTo GetMeOut?
>
> Thank you.
.
- Prev by Date: Re: Add Record with multiple textboxes
- Next by Date: Re: Background colors
- Previous by thread: Re: Distributing and updating application for market
- Next by thread: Re: Checking for value in a table
- Index(es):
Relevant Pages
|
