Re: VBA: Function Help... Search?/Match?/Vlookup?/

From: MJ (mj1299_at_excite.com)
Date: 10/28/04 

Date: 28 Oct 2004 14:56:53 -0700

Can you post the solution? I am trying to do something similar...
look at a value in a cell and see if it already exists in another
column.

Thanks!

Mcasteel <Mcasteel.1eu7de@excelforum-nospam.com> wrote in message news:<Mcasteel.1eu7de@excelforum-nospam.com>...
> Im trying to look up a specific SSN from Column F. The End-User will
> input a Customer SSN that they are looking for into a text box
> (txtCustSSN).
>
> If the SSN is found, I want to return the customers Lname, Fname,
> Info1, and Info2 back to my customized form. If the SSN is not found I
> want to return msgbox "Customer Data not Found".
>
> _Data:_
> Column A = Date
> Column B = Type
> Column C = Lname
> Column D = Fname
> Column E = Mname
> Column F = SSN
> Column G = Info1
> Column H = Info2
>
> ANY IDEAS ON HOW TO SEARCH A COLUMN OF OR 300+ SSN'S TO \"MATCH\" THE
> SSN THAT THE END-USER INPUTS INTO THE TEXT BOX TXTCUSTSSN?
>
> Ive been having a really hard time with this, please respond with as
> much info as you can.
>
> Thank you!

Relevant Pages

  • Re: Im a crosstab dummy
    ... just a simple totals query. ... GROUP BY SSN, LNAME, FNAME ...
    (microsoft.public.access.queries)
  • Re: Help w/ writing a If Statement
    ... On your form add a combobox with the rowsource the above query. ... You can now select the SSN ... Since the social and Fname and> last name are always connected. ...
    (microsoft.public.access.formscoding)
  • Re: Help w/ writing a If Statement
    ... >On your form add a combobox with the rowsource the above ... >when you select a SSN. ... >> for Ssn# FName, Lname. ... >> automatically entered into their feilds. ...
    (microsoft.public.access.formscoding)
  • Re: Help w/ writing a If Statement
    ... In the query for the combobox, sort SSN ascending. ... Since the social and Fname and>>> last name are always connected. ...
    (microsoft.public.access.formscoding)
  • RE: VBA: Return Searched Value Inputed by End-User
    ... "Mcasteel" wrote: ... > input a Customer SSN that they are looking for into a text box ... > If the SSN is found, I want to return the customers Lname, Fname, ...
    (microsoft.public.excel.worksheet.functions)