Search results

  1. Jason Lee Hayes

    Stop User entering a "Bad" value. Serial Numbers

    I believe the solution is simple and its procedural as mentioned above. " Since this is such a problem, I'm not sure why you are not validating the SN as you accept the device for repair. Wouldn't it be better to know that you have a bad SN up front?"
  2. Jason Lee Hayes

    Counter that counts the number of printed copies of report

    Hi, yes, i fully understand the complexity and i also believe its likely impossible to be 100% accurate unless you have a dedicated printer as you refer to with the capability built in. Even then there's no guarantee the end result is legible due to fuser failure for laser printers of clogged...
  3. Jason Lee Hayes

    Counter that counts the number of printed copies of report

    Yes; i am aware and have successfully programmed a raspberry pi to do just this using the Unix print system CUPS software when the printer is not capable of storing such information or i need to enable a printer to work wirelessly when wireless capability is non existent out of the box...
  4. Jason Lee Hayes

    Counter that counts the number of printed copies of report

    This is something I will need in my application. Its a necessity not a nicety. The issue can also be linked to the inaccuracy of a printer being reported as on line when it's not. I am going to work on a solution for this; I cannot accept that we are unable to identify with accuracy the printer...
  5. Jason Lee Hayes

    Counter that counts the number of printed copies of report

    Sure you can easily count the number of times the Print button is clicked as well as recording the date/time, workstation, username on each occasion. However it may not always physically get printed if e.g. "There is a paper jam or ink has run out.." Can you not just interpret the print spooler...
  6. Jason Lee Hayes

    Solved Error 2023 & 3075 relating to SQL Statement

    Thanks Gasman... I was so focused on the TempVar believing it was this i could not see the wood for the trees.... I should have known really as the value was being returned and stored in the table.... I have corrected this now to the following:- strSql = "SELECT tblDataChanges.* FROM...
  7. Jason Lee Hayes

    Solved Error 2023 & 3075 relating to SQL Statement

    I am using some code that simply populated a table when a form is opened and closed which populated some fields. I am trying to insert the current value of a TempVar declaired as [TempVars]!TempLogonName] to the field UserName however i cannot seem to get the formatting write. The TempVar holds...
  8. Jason Lee Hayes

    Update Front End

    Never really liked the batch file approach; wrote my own application in AutoIT a few years ago which is self contained only to find your example which is even better... Perfect.... Thanks for sharing...
  9. Jason Lee Hayes

    setting colour scheme and logos in all forms/reports through table

    I have a table that contains details about users and includes fields to store specific information set in a settings form. The attached gives you an idea of what settings i have personalised per user such as Audio Feedback, Report Banner Colour, Mug Shot on Report Footer amongst other things. I...
  10. Jason Lee Hayes

    Deployment package for Access

    I use Advanced Installer 18 Enterprise... Supports MSIX. Not cheap but available to download & use free if you know where to look... https://www.advancedinstaller.com/versus/installshield/adminstudio.html
  11. Jason Lee Hayes

    Solved Catch 2501 Error Message (DoCmd.SendObject) Not Working

    Just an update... I think I've finally identified what the issue was... Sure, some slight coding oversight which i will take on the chin and learn from highlighted by members of this very helpful group. Don't know if anyone here has run into problems with the Outlook Programmatic Access...
  12. Jason Lee Hayes

    Solved Catch 2501 Error Message (DoCmd.SendObject) Not Working

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

    Solved Catch 2501 Error Message (DoCmd.SendObject) Not Working

    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...
  14. Jason Lee Hayes

    Solved Catch 2501 Error Message (DoCmd.SendObject) Not Working

    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.
  15. Jason Lee Hayes

    Solved Catch 2501 Error Message (DoCmd.SendObject) Not Working

    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...
  16. Jason Lee Hayes

    Solved Catch 2501 Error Message (DoCmd.SendObject) Not Working

    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...
  17. Jason Lee Hayes

    How to determine whether a local printer is Online?

    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...
  18. Jason Lee Hayes

    How to determine whether a local printer is Online?

    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...
Back
Top Bottom