Recent content by mearle

I guess that some of the "top level" members return other COM objects whose members you want to appear in intellisense. So, if they work anyway, then they must be late binding. Check the following in case it is relevant: http://support.microsoft.com/kb/813809

You can only use Tools-References if the library implements COM. You'll soon find out by trying to add it. With references, you get intellisense, type checking, event hooks.... With declare, there is no safety net - get a parameter type wrong, and you can crash your application. Tangentially...

Is CustomerID the primary key in the Customers table? If not, you will get this error.

You might find the following worth reading: http://vbnet.mvps.org/index.html?code/internet/dofiledownloadcustom.htm

On the other hand, I'd forgotton you can step through the merge records one by one, so the following might work for the way you intended: ActiveDocument.MailMerge.ViewMailMergeFieldCodes = False ActiveDocument.MailMerge.DataSource.ActiveRecord = wdNextRecord

The merge documents might have been created, but as far as I can tell, I don't think you are doing a merge in Word, which is needed to create the separate documents that you need to attach - and this is your problem. You are only selecting the merge template, not the new merged documents. Is...

Ah, I see, so you haven't actually done the merge yet ? Opening the query on it's own won't do it for you. I guess what you need to do is to record a macro in word of you manually doing the merge, and then look at the code produced to get a clue as to how to do it. Use the key lines of code from...

You can't reference one recordset from another, however you can do what you want using a subquery as follows: SELECT COUNT(Subject) FROM (Select DISTINCT Subject FROM Customers WHERE Product = xxxx)

It looks like you are mixing .NET style VB with classic VB/VBA, used by Access. You can't use the ToCharArray method - the nearest equivalent in VBA is to use StrConv to convert to a byte array. Similarly chrArray.Length should be len(strAddr). Break is not needed, and neither, in this case, is...

A few comments: strEmail = strEmail - this does nothing Set oDoc = CreateObject("Word.Application") - this opens a fresh copy of word each time,which is never closed. I would put this outside of the loop, and use the document Open and Close methods in the loop. DoCmd.OpenQuery...

Just an educated guess, but does the index file exist for this table, which I think ends in .px ? Otherwise try linking the table, and see if you get the same error.

Hi, I had a spare few hours and enough curiosity, so I've attached how i would do it, which is to create a new table to store each word of each title into a seperate row, so that a query can be used to compare how many words match for different titles. Common words (and, the etc) and punctuation...

DELETE Orders.* FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE Country = 'USA'

In the case that the database is not already open, the user would enter the password in the access dialog box that automatically appears, in just the same way as when somebody manually opens the same database through Access.

A neater alternative might be to use the GetObject function, eg Dim acc As Application Set acc = GetObject(strDatabasePath) I believe this will return a reference to the instance of access which has this database file open, or if not already open, it will start a new instance of access, and...