Choosing what information to filter from SQL in VBA

[Guest]

Hello,

I have recorded a macro that connects to the SQL warehouse for a specific
ClientID.

Is it possible to alter the VBA so that I can choose what ClientID I want to
retrieve? I was thinking of using an input box

 

[paul.robinson]

Hello,

I have recorded a macro that connects to the SQL warehouse for a specific
ClientID.

Is it possible to alter the VBA so that I can choose what ClientID I want to
retrieve? I was thinking of using an input box

Hi
A bit vague
Is the ClientID a text string, a number...
Is the ClientID on a worksheet, in a database, a parameter in another
sub, part of an SQL string...

At the moment, the answer to your question is "yes, probably"
regards
Paul

 

[Guest]

ClientID is a text string in an SQL server table.

Here is the SELECT statement from the VBA


"SELECT Account.AccountID, Account.ClientID, Account.Forename,
Account.Surname, Account.Address1, Account.PostCode, Account.DateOfBirth,
Account.AccountStatus FROM Warehouse.dbo.Account WHERE
Account.ClientID='FTC001'"

 

[Guest]

Ive done it.

Hi
A bit vague
Is the ClientID a text string, a number...
Is the ClientID on a worksheet, in a database, a parameter in another
sub, part of an SQL string...

At the moment, the answer to your question is "yes, probably"
regards
Paul