Search results for query: *

Create a new query, UNION the fields together that you require and then create yet another query to sum the results of the UNION query. GOod Luck!

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...

Try this brother... http://www.mvps.org/access/general/gen0002.htm B-)

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...

How about something shorter and sweeter... If Len(Dir(strFilename)) <> 0 Then Kill strFilename End If