Recent content by howardjones

Cheers your comments are noted, but the mail session is open. I think it is somthing to do with Lotus notes and that it is trying to invoke outlokk instead, we don't use outlook so therefore it is failing. I beleive that there is some code that related to Lotus Notes If any further ideas they...

I wonder if anyone can help me with a solution. I need to automatically send Access reports out a specified time to a group of people. I can soert out this part no problem but, I need to know the code to send this through Lotus Notes. Every time I try to invoke this code: [DoCmd.SendObject...

Hi I wonder if anyone could help me with an e-mail problem? Ever since I joined up with Freeserves anytime tarriff I have had trouble receiving e-mails on my old address. Everytime I try to retrieve them It requests my user name and password and no matter how many times I enter them it will not...

I have some problem with cancelling a report once an error has occurred. I have trapped the error but I also need to stop the preview of the report DoCmd.Close acReport, "RprQryTeamScores2" this code give me a runtime error 2585 I need to suppress this messege and stop the report...

Neil why not try making the report visible in the detail for example try if blah = 1-3 then report1.visible = true elseif blah = 4-5 then report2.visible = true and so on hope it helps

Any Ideas on creating a password in Access, must be 2 dimensional ie must look up wage and password not just record set on password ie table Agents, Fields WageNumber, Password