Replies

Thanks Charlotte. Works great!!

Thanks Charlotte. Works great!!

Charoltte, thanks for replying.

I am not sure where to begin in implementing your suggestion… “Instead of doing that, why not just change the SQL property of the query on the fly. That will keep the existing permissions and not require special permissions on new queries for your users. ”

How do you change the SQL property of the query on the fly?

Thanks

Charoltte, thanks for replying.

I am not sure where to begin in implementing your suggestion… “Instead of doing that, why not just change the SQL property of the query on the fly. That will keep the existing permissions and not require special permissions on new queries for your users. ”

How do you change the SQL property of the query on the fly?

Thanks

Pat, could you give me an example of using alias?

Thanks

Pat, could you give me an example of using alias?

Thanks

The query should read:

SELECT dbo.tblMyTable.*
FROM tblFromAccess INNER JOIN dbo.tblMyTable ON tblFromAccess.PDATE = dbo.tblMyTable.PDATE;

I modeled the above query by joining two Access tables, running the query to make sure it worked and modifying and copying the SQL to the Passthrough query.

The below query returns records:

SELECT dbo.tblMyTable.*
FROM dbo.tblMyTable
WHERE dbo.tblMyTable.Product=’091503′;

My attempt was to create a way the user could enter a date and return records from the SQL Server. Charlotte how is a criteria from Access passed to SQL Server?

Thanks

The query should read:

SELECT dbo.tblMyTable.*
FROM tblFromAccess INNER JOIN dbo.tblMyTable ON tblFromAccess.PDATE = dbo.tblMyTable.PDATE;

I modeled the above query by joining two Access tables, running the query to make sure it worked and modifying and copying the SQL to the Passthrough query.

The below query returns records:

SELECT dbo.tblMyTable.*
FROM dbo.tblMyTable
WHERE dbo.tblMyTable.Product=’091503′;

My attempt was to create a way the user could enter a date and return records from the SQL Server. Charlotte how is a criteria from Access passed to SQL Server?

Thanks

Thanks!

Thanks again!

Got it!

I can get part of the Target of the shortcut with the following:

Set shrt = wsh.CreateShortcut(strDesktopPath)

strTarket = shrt.TargetPath

shrt.TargetPath is returning everything within the first set of quotes. Any ideas on how to capture the MDB and MDW information which are inclosed in quotes of their own?

Thanks again for the example and the information.

How would I modify the example to capture the current Target of a shortcut? I want to test for a string before I modify it.

Thanks

Thanks

Thanks