Recent content by cjsorel

Generally these are errored email messages that need to be deleted using something otherthan Outlook. I use MFCMapi utility from Microsoft to remove these emails. Download here : http://support.microsoft.com/?id=887724 MFCMapi can be run on your exchange server and do not be alarmed if your...

Take a look at Exchange 2000\2003 static port mappings (Microsoft KB270836) Related resource is: Windows 2000 Connectivity through Firewalls KB280132 I have figured out that some of the port mappings I setup in Exchange 2000 are now not usable with Exchange 2003. Use RCPDUMP.EXE from...

Alshrim, You have to be logged in as a full admin to delegate that rights with system manager. I am having this same problem after upgrading from Exchange 2000 to 2003 with my backups. Veritas tech support is not sure what is wrong and waiting for conference call with Microsoft to figure this...

Duane, Works great after placing in a [ your missed on the sum line Sum(Abs(ExpiredDate>=[For... Thank you very much and a star for this help. No I can stop pulling out my hair Chris

I had to move the group by to the end for it to work but still not giving me any results. This is the sql that I started with SELECT qryrptOver_time.ContractTypeDesc, Count(qryrptOver_time.ExpiredDate) AS ExpiredDate, Count(qryrptOver_time.TerminatedDate) AS TerminatedDate...

Duane, I have been trying to do a reference to controls on another form and when I try like you mention I get this error. Invalid bracketing of name '[Forms!Chart_OverTime!txtStartDate]'. I have tried putting in the brakets but no help. Here is the SQL statement: PARAMETERS...

Jmeadows7 - your welcome and thanks for the star.

I had this problem with reports that I want in landscape and they would get messed up by the users. So instead I set the default printer's orientation to landscape each time a report is opened. Put this in on a open event as VBA code. Application.Printer.Orientation = acPRORLandscape

Do do as a macro you use SendObject and fill in the fields Or you can use this code on a button. Dim emailList As String Dim subject As String Dim messageText As String Dim txtdate As String emailList = "email@domain.com" subject = "Report" txtdate = Now() messageText =...

Golom, Thank you for the information but I tried this in Access XP and get a error 'Join expression not supported'

I am creating a Contract information database and have broken information into multiple tables as to no have duplicate addresses for Company and contacts. Since there are multiple contacts for each company coule have the same address as the company. I have run into a problem trying to pull the...

Just open up your VBA editor, go to the Tools menu, choose References, check off the ADO entry, find DAO 3.x, check it on, and exit the dialogue box. Now the code will work.

Well I guess I did not come right out with a question. So here is my question. How to get a textbox to represent a description for another field? For instance if the status is 2 and that means Active. If I use this as a list box and set the Column Widths to 0";1" I see my...

I am not sure which one of these to use for a form where I do not want a user to change it. Code will change the value. Basically the field is Status which is stored as a number and I want the field to show only the description. I have tried a number of ways but can not get it to work beyond...