Posts by DonLennon

Re: Pulling Back Entries From A Table That Contain One Of The Words In Another List

Thanks! It works! I can't believe it was so easy to do after all that. I think as you say it was that link between the two tables that was causing me the problem.

Thanks,

Don

Hi,

Hopefully I can explain this properly..

I have two tables: NAME & DETAILS

NAME just contains a list of names e.g.

Bob
Dave
Mike
Steve

then DETAILS contains a field which may contain these names, although this could be anywhere in the field, and some of the data won't contain any of the names from the original table e.g.

Bob Johnson
Mark Dave Roberts
Mike
Steven
Philip [Don't want]
Chris [Don't want]

What I want to do is produce a select query which will pull back all of the entries from the DETAILS table where it contains one of the names (i.e the first four entries in the above example.

I'm sure ths must be possible somehow but I can't for the life of me think of a way to do it.

Any help would be much appreciated.

Thanks,
Don

Hi All,

I am trying to create an Excel function that can query an oracle database, using the data in a cell in Excel. For example:

I have an oracle database with a table CustDetails containing all customer names and their addresses.

I then have an excel spreadsheet containing various customer names in column B. I want to be able to enter in column C "=GetPostcode("B2"), and then this will pull back the information from the Oracle database using SQL such as

Select PostCode From CustDetails Where CustomerName = [the data fed to function]

Is anyone able to point me in the direction of some code to help with this? My general VBA skills are pretty good, but i just have no knowledge of ADO, and not much SQL.

Any help would be much appreciated.

Thanks,

Don

Re: If file is Read Only then don't prompt save?

How's this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If ThisWorkbook.ReadOnly = True Then ThisWorkbook.Saved = True
End Sub

Regards,

Don

Re: Issue with Worksheet button with "Activesheet.Protection = True"

Hi,

I think what you are looking for is

"ActiveSheet.Protect" or "ActiveSheet.Unprotect"

that should do it

Don

Re: VBA code for "contains"

Brilliant set of answers guys - thanks a lot!

I'm getting quite addicted to this VBA stuff at work. Give it a few more months, and my whole job will be a case of pushing one button!

Hi,

I'm hoping this is a pretty simple question. I am basically looking for some code that can look if a cell contains a certain string.

To date I have only been able to look for exact strings e.g.
If UserName = "Bob Jones"....

What I am looking for is:
If UserName contains "Bob" ...

Thanks for your help