Search results for query: *

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

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

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

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

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

I have a large taqble of telephone calls which consists of phone number dialled|time of day|Duration. I have a separate table which consists of Country code|Country Text|Rate per minute. I would like to create a join between these two tables so I can do some what if analysis with different...