Recent content by dibby44

Using simple Mapi with Access 2000 Just picked up this thread as I have a new client who does not have Outlook. Your Thunderbird code does exactly as you said, displaying [but not actually sending] emails via Thunderbird, but I have to program in Access 2000 up to 400 addressees, so clicking...

Sorry guys and girls - still playing around with the code [2 days on] and found an answer [sort of !]. For some odd reason, my assigning the attachment file name to the variable MyStr worked for the export of the file, but was not recognised later in the code for .attachment.add(MyStr) I...

For many years I have used the following vb code to create an Outlook email from Access, add an attachment, and display it in Outlook before sending. Now that I have Office 2007 Pro under Vista HP, it no longer works under Access 2000, nor 2007. Either the process stops after the attachment is...

I generally use the following, ============================================ Set objOutlook = CreateObject("Outlook.Application") Set objOutlookMsg = objOutlook.CreateItem(olMailItem) With objOutlookMsg Set objOutlookRecipTo = .Recipients.Add(whoever or no-one)...

Restricting each user to one database open The easiest way would be to add a users table, and, by means of a workgroup file, make users log in. In the autoexec, run a query that adds each user to a 'users logged in' table [in the back-end]. Before that query runs, add another query or run...

References I have experienced similar problems when an Access 2000 user opens a 97 database. My cure is to include vb code to confirm the correct references exist on opening, and to run that code in the autoexec macro. Public Function SetRef(strFileName As String, libPath As String) As...

Thanks - I'll be seeing the customer on Friday 10th, so I'll be trying to resolve this then.

Have already tried moving front-ends to client pc and forms designed using selection queries - neither seems to improve the problem. Any thoughts on the expanding number of linked documents that I mentioned?

Over a year ago, I created an Access 2000 database split front/back end, both on server and run on client pc's. It ran very fast when built, but now, over a year later, it has slowed a lot. It was designed according to Access guidelines, eg indexed fields, vb code not macros, etc. Some forms...