Search results

I have a database that stores documents in pdf, docx and jpg form in an encrypted state. When I want to view one it unencrypted them and places them in a temp folder to be viewed, and then they are deleted once viewed. This has just affected the jpg files, but the above code is working fine...

It took a bit of work but I now have: Call Shell("cmd.exe /c" & Chr(34) & "C:\ProgramData\folder\temp." & filetype2 & Chr(34), vbNormalFocus) which is working. EDIT: Call Shell("cmd.exe /c" & Chr(34) & "C:\ProgramData\folder\temp." & filetype2 & Chr(34)) and the command window doesn't flash up.

How frustrating. I note IE11 will be retired on 15 June, so maybe it's got something to do with updates relating to that. Hopefully when it is shut down this problem will disappear.

I logged into my work PC and it is having the same issue. Trying to open .jpg via Application.FollowHyperlink invokes internet explorer 11 (and asks to set it up as I've never used it before). Clearly an MS update has borked something as usual. Does anyone know a workaround for .jpg? Can I use...

I've got the urls working again. I had to add IE back and then select chrome as default. Oddly it doesn't work without IE being installed for some reason. I have another PC at work with a similar setup, so will see what's going on with that when I'm next in work. My last system restore...

It lists paint, paint 3d, photos, snip and sketch. Clicking on it in explorer works fine. It's just the access code that doesn't work. Saying that now my .url files are playing up. They used to open in chrome but now they just open to show text: [InternetShortcut]...

I have used the code below for many years without issue Application.FollowHyperlink "C:\ProgramData\folder\temp." & filetype The files it opens are either jpg, pdf or docx. Previously they would just open in windows explorer as if you have clicked on them. As of today for jpg the code just...

Many thanks for the replies. Of course I am being stupid. The count for my function starts at 1 whereas as mentioned the array starts at 0, so will always be 1 less than my method. I think running DeDupe after mine with it counting in a "0", thus returning the same count number was throwing me...

Dim NumberList() As String Dim NumbersString As String */ repeated several times to build up string of numbers. no comma at end /* If NumbersString Like "" Then NumbersString = Left(Replace((rs![Mobile No]), " ", ""), 11) Else NumbersString = NumbersString & "," & Left(Replace((rs![Mobile No])...

I want to remove duplicates from an array. I came up with my own method before finding one, which involved setting duplicate entries 0 and just ignoring them. Mine was: NumberList() = Split(NumbersString, ",") For x = 0 To UBound(NumberList()) For j = 0 To UBound(NumberList()) If Not x = j...

Thanks. Can't believe it was so simple.

I'm trying to match a number with a string that may contain the number. e.g. Hi = "07123456789" Bye = "07098765432, 07123456789, 07102938475" so if Hi is anywhere in Bye it returns true. e.g. If "*" & Hi & "*" like Bye then msgbox "bingo" However it never works and is always false, unless...

I have this set up now and it works fine. I just used the "convert.exe" from the portable version of imagmagik, so no installation required. There doesn't appear to be anything suspicious about it so far.

I've searched and found a few programs, but nothing that seems suitable. I will have a look at imagemagick thanks. EDIT: Thanks that looks good so far. I'm interested in the portable version but a bit bamboozled by all the different options. EDIT2: Can't seem to download: Your connection...

I'm loading some images into access image process. They are signatures on a pure white background. I want to remove the excess white area around the signature so it is cropped to just the size of the signature. Is there a way to do this with VBA? If not are there any utilities that can be run...

The first signature box is 17mm in height so 48.2 points. Specifying the vertical size seems to work as the horizontal size scales by itself. I can't believe it was so simple. Left:=128 + HorizCor, Top:=650 + VertCor, Height:=48.2)

textboxcount is just the shape number. Originally I was just using textboxes only. I think I can set the shape to have a particular vertical size when I define it, so will try that and see if it scales the image vertically and horizontally to fit.

Properties of original 2047 x 1017 dpi not shown. New image is 1280 x 704 96 dpi.

Hi. Thanks for your reply. I tried the above code but it results in an image that is too big. I then thought to set to the original image size and the convert from that. Sadly that makes the image too small. I feel there is something I'm missing. Could dpi be causing an issue? SigScale =...

I capture signatures using an android device and put them in a publisher document that is printed onto a template form. I want to be able to use different devices for signature capture. The problem is the images then have different resolutions. I altered my code to scale the images based on the...