Recent content by Hamish 237

  1. H

    Maximise a power point show when it opens from command button in access

    Hi i have a access db that opens various power point ppsx files via hyperlinks is there any simple code i can add after the hyperlink that will open them maximised? the ppsx files are all set to open as kiosk view and work fine when opened directly but not from the hyperlink Private Sub...
  2. H

    Checking if file exists Type mismatch

    Hi All im having issues with this bit of code can anyone assist with what i'm missing / doing wrong hopefully its something simple im just over looking or not familiar with I'm getting a Type Mismatch alert when i run the code. checking for a vbstring in the directory is where i think i'm...
  3. H

    Attach multiple files from a directory folder to email .pdf & .jpg or other image files

    OH and If anyone knows how to force the opening folder containing the attachments to open in large thumbnail icons that would be fantastic making image selection very easy
  4. H

    Attach multiple files from a directory folder to email .pdf & .jpg or other image files

    Thanks All, Selecting the Files was a great Idea I managed to get this to work great Code below which should be much quicker for the users but is there anyway i could add script to control any selected image file size before its attached like windows would normally do if your selecting image...
  5. H

    Attach multiple files from a directory folder to email .pdf & .jpg or other image files

    Hi Again thanks for the help earlier to yes Picking the files would be a workable option though hopefully they will have only placed the required files in the folder in the first place
  6. H

    Attach multiple files from a directory folder to email .pdf & .jpg or other image files

    Hi all im sure there is posts out there that cover this but everything i found was very old or seemed overly complex so i thought id ask the question fresh. My Case file i have a simple database that stores vehicle data and repair history new repairs are documented and the report / workcard is...
  7. H

    Solved Report will not save as PDF

    Thank you gentlemen that was my blind spot 🤪
  8. H

    Solved Report will not save as PDF

    Hi all would appreciate any advice I'm having issues with saving a report to a path "i'm creating path if its not there" then using the docmd.outputTo to save the file as acformatPDF the path all works fine and saves the file but its not being saved as a PDF just a generic file now the...
  9. H

    Command Button msgbox only works once

    Thanks guys i’ll Certainly Try the SOTV=Null as well and I’m thinking that could be very useful in future for me ... I have always referred to the control value previously and had my share of hurdles now I think those were likely caused by the “” value
  10. H

    Intro

    Hi isladogs No problem to explain that I’m a grandpa of 1 x 2yo and there is one still cooking in the oven due just before Xmas so it’s probably only a .3 at the moment :-) and I got to say it can’t come quick enough for me I’m a real softy for fresh out the oven muffins lol
  11. H

    Command Button msgbox only works once

    Thanks Micron, I wanted the code to also clear the control SOTV.Value TO “” so users didn’t have to clear the field on return to the search form which has multiple search criteria they can select from ...the IF NZ (SOTV,””)= “” worked a treat in this case thanks
  12. H

    Intro

    Thanks Doc Man I’m a Grandpa of 1.5 so far but a ways from retirement yet unfortunately. So I got a good laugh at your post can still teach the young bucks eh! The wisdom of years only held back by the wanting of youth lol :)
  13. H

    Command Button msgbox only works once

    [SOLVED] Re: Command Button msgbox only works once Thanks Gasman NZ() worked a treat
  14. H

    Command Button msgbox only works once

    Ok I can see that thank you... I didn’t cotton on that it changed when I added the set value command I will try that in the morning
  15. H

    Command Button msgbox only works once

    Hi Have a small issue with a command button it works fine and gives the desired message if there is no content in the referenced control but the message box changes to a syntax error warning if the button is pressed a second time without data in the control is there and easy code line to reset...
Top Bottom