You have to make use of references, in this case the
Microsoft Internet Controls REFERENCE. Once that has been
done its a matter of declaring the correct objects.
Sub ShowTekTips()
Dim IE As InternetExplorer
Set IE = New InternetExplorer
IE.Visible = True
IE.Navigate...
1. Make sure that the fields you are joining your tables on are of the same data type.
2. Have you tried using a Passthrough query? This is probably much faster than joining the Access tables.
Firstly you need to link your SQL server database to the access DB. eg call it SQLversion. If you already have a table called Version - all you need to do is run a query
that updates the number:
UPDATE SQLversion SQL_V, Version V
SET V.Version = [SQL_V].[Version]
WHERE V.Version <...
How do you set a DB variable to an open Database
that has its own workgroup file without getting any errors?
For example:
If 'C:\Temp\Temp.mdb' is a secured DB and has its
own workgroup file called 'C:\Temp\WKS_Temp.mdw' -
is it possible to maybe pass the Workgroup filename
with a username...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.