[lapsaj]

For this Im only using Excel and Access

Right got a query...

When I type 'x' in a text box in excel...then click a submit button....I want it to check a table for 'x'. although I only want it to search through the first column for 'x'. If it does find something then I want it to display YES in ths spreadsheet...if not then display NO.

its do able im not sure of the exact code for all of it, mostly how to open the database but the sql statement is

Code:

select count(*) as reccnt from table name where coulm like '% cell value %'

then you say if rs.reccnt > 0 then yes else no

i'll try and work something up tonight

[lapsaj]

Would it be do-able with an access DB?

yes that is very easy to do in access since it is database

[lapsaj]

so what would the VB code be? Ive got the code to connect to the DB but how do I search in one column and return the result?

can you post the code that you have as i only know how to search using a sql statement suchas

select column, column from table where column like '%words%'

[lapsaj]

Its alrite now, Ive done it a different way. I just ran a query.

thats where i was hoping you would go, sorry i wasnt more direct about that