Recent content by Mae

This was the first time I ever try posting anything with an attachment. I have zipped it and have attached that one. Maybe that will work better.

I have a report that when I chose the option to email it, the headers end up dropping characters or inserting another line with some of the characters on the extra line. I choose rich text format. The odd thing is that it works fine on some of our PCs but not on some others. Is this related to...

I ran into this same error message and my problem was that I had myself in a loop. It was on a form, but I had a control that was being calculated automatically in the Enter event and I inadvertanly had code somewhere that cause the Enter process to execute again. In the Enter code I was doing...

Ahhhh, very clever. Thanks for the explaination; it does make sense now. This forum has been a tremendous help to me. I have found numerous solutions to problems and different ways to accomplish things. Thanks to all that take the time to share their knowledge. Mae

Can someone help me understand what the booCloseAccess thing is doing. I added a defintion for booCloseAccess and then added the IF NOT then CANCEL statement as described above to my Main Menu form (it is the one that is automatically opened on startup) in the UNLOAD event. Yes, the X button...

As I was searching for something else, I ran across mention of the OutputTo macro. This ended up being exactly what I was looking for. This macro allows you to output objects (not just a report) into different types of files. Works really great. I have set up my macro to output my report to a...

Yes, it is. But I am wanting to print to a file without any human intervention. I am wanting to do all of this from a bat file that I can schedule to run at certain times during the day automatically.

I have a report in my db that I would like to automatically have "printed" to a file. I have a macro set up that does an OpenReport that I am using in my startup options on my command line. Currently, the report prints to my default printer. Is there any way to get this to print to a file...