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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.