Recent content by dkellygb

Thank you! At first this did not work. I gave up after monkeying with every setting I could find. The next day it started working. I assume that I had to close Outlook and reopen it to make it work. Regards, Dave

I am pretty good with VBA from within Access or Excel but I am struggling with Outlook. What I am trying to do is execute code whenever an email message is received or sent. Specifically, when a message arrives, I would like to check the email address against a field in a Jet table. If it...

The way I am doing seems to match the help and works in several other programs. The question is why does this work for two weeks and then stop working with a runtime error 59? Why can I fix it by importing the program and objects into a new database?

The AuditTrail type is the file layout for the random access file. It requires no reference. Here it is for your information: Type AuditTrail ID As String * 1 AudDate As Date AudTime As String * 5 CostCentre As Integer User...

I need to read from random access files and write them to access to do analysis on a legacy system's data. I have written the code and all seems to work fine for about a week and then bingo! I start getting run-time error 59 bad record length on a GET statement. Repairing and compacting the...

Thanks! That's a good tip. Dave

Thank you for your advice. I was struggling with adding the document to a bound object frame. However, I think I found a solution. On Error GoTo NoOleObject Dim ctl As Control Dim wrd As Word.Application Dim fname As String Dim sal As String Dim add As String...

I am struggling with automation with office XP. I have an Access database where every time a user communicates with a customer, it is logged with the date and time. I am trying to create a facility where the user can select from a list of about 5 word templates to create a letter to a...

Yes, I have put docmd.setwarnings false in the close and the unload events separately. It stops the dialog box which asks you whether you want to save but then gives you the form name dialog box. I don't want either.

How do you remove the close button from the application? How do you handle the situation where the user is shutting down Windows which then tries to close the appliction generating a dialog box which prevents Windows from shutting down?

I have no problem closing a form without the dialog box from another form or from code, what I am trying to do is not have the dialog box when the user closes the application or form - either by closing the entire application or when windows is shutting down. If the user clicks the X in the...

Hello, I am creating a temporary form programmatically with a large number of controls to interact with the user. I do not need to save the form when the user exits the application or if he decides to close the form. However, when I try to docmd.setwarnings false in the unload event, the form...

Yes, a crosstab query will do that but I would like to have it on a form. Are there any activeX controls which changes a tabular forms orientation from up/down to left/right? Thanks, Dave

You have the right idea about the organisation. However, I would like the columns record1, record2, record3... recordn to be able to scroll to the right infinitely. This is how the access form works in an up and down direction, I just want it to work in a left to right direction. Dave

As we know, tabular forms scroll vertically. I want to invert the columns and rows so that the columns run down the left and the records scroll to the right. Is this possible? Maybe with an ActiveX control? Your help is appreciated. Dave