Search results

Hi, Yes - I changed False to True just to check and it does the save; still offers the email edit function

Hi, Yes, i understand what you are saying, if False then it should simply open outlook and send the message without even presenting the email message..:unsure: To be fair i don't really wish to use the SendObject method as its too restrictive but this is my only option at the moment. Should i...

Hi, Just to be clear... See attached... If a choose [Allow]; works perfect... If i click [Deny] i get the additional message on which i am forced to click [OK} after clicking {OK} message box disappears and form is shown but is not responsive and only beeping when you type or click.

Jeez, i only posted a minute ago.. Super quick response that was :D Thanks.. I understand what you have posted and added the code above to the forms on orror property however the result is still the same... when i am taken back to the form anything i click or any key a press i get the default...

Hi, I am exporting a report as PDF and it works fine using the DoCmd.SendObject method... Report emails fine however if i cancel the outlook message and do not send i get the attached error as expected.. Anticipating this i thought my code would identify the code 2501 and ignore it (Ignore in...

Just thinking out of the box... Could we not monitor the print que "winspool.drv"; from there we could then determine if a print request has failed through event return or time out in which we could cancel the request in the print que to print and use this return value accordingly...

Hi, Yes, i spotted this code as well and did the same. as you... I think we have to communicate with the spool library to get true results... Regards...

So; been looking at this scaping the net and it seems hell of a job just to get the true print ready status of a printer.... Why its made so difficult i have no idea :mad:but the amount of time i need to invest in this to get a solution cannot be justified... Especially when i need to learn how...

[/code]

Hi, Yes; its definitely something i need to lookup.. Just by looking at Gasman reply i can now see why its absolutely necessary. I cannot believe how far I've got without it lol.. Will spend a few weeks getting familiar with it for sure...

Hi, Yes, I'm getting the same result... 3 even if printer is turned off and this is also a Wi-Fi Printer (Canon)... Maybe we can make use of the spool library:-

Sorry arneigp... As you can see i have much to learn.... You code refers to writing the output to a worksheet... I'm using Access VBA.. Don't understand the Debug.Print thingy... I just want the result to be represented in something like a messagebox "The Printer xxx you have selected is yyy"...

HI, Maybe i haven't made it clear or my lack of knowledge is showing through lol. I'm not checking to see if a printer is local but whether the printer status is any of the (1 to 7) results in a printer status. Maybe this is something that will give me what i'm after. It seems others have...

I appreciate your reply, I'm missing something somewhere. I am getting a result of "True" for all printers including a printer that is not turned on therefore I'm questioning what the True value actually represents. Sure, all the virtual printers give a result of "True" as expected. Maybe It...

Hi All... So, i have a routine that enables me to select a report from a populated ListBox then print it to a specific printer of choice .. Works fine for both physical & virtual printers.. I am anticipating the end user is not computer savvy therefore i wish to prevent the end user selecting...

I think I've found what I'm looking for; just need to tap user32 library and make use of SetWindowsPos Function... Declare Function SetWindowPos Lib "user32" Alias "SetWindowPos" (ByVal hwnd As Long, ByVal hWndInsertAfter As Long, ByVal x As Long, ByVal y As Long, ByVal cx As Long, ByVal cy As...

Thanks theDBguy... Will take a look...

Hi All, Is it possible to control the position of a File Dialogue Box so that when opened it can be placed centrally on the screen? I have searched but cannot find any resolve.. Just to be clear its not a form i am trying to centralise but the dialogue box or similar a system message. It's a...