Search results

I read your post about 20 free hits a day. I don't get any results anymore at all. It has only stopped working over last couple of days on 2 separate computer. It was working fine prior to this and I wasn't registered. I wonder if they have modified the website code to block it? Can someone...

[SOLVED] Postcode lookup stopped working EDIT: 22/05/18 This has stopped working on a window 7 machine. Can anyone help? Please see posts lower down. The excellent piece of code contained here that allows uk postcode address lookup...

Thank you. I have started looking at zip and it also has the advantage of compression. Most examples I can find don't include password which is what I want.

I am looking for a function that will allow me to encrypt/decrypt single image files as and when required. I have built my own simple one to encrypt a string that will be stored in a filename as all the ones I found created unusable filenames. However I don’t know where to start with the image...

After some extensive research found a way with ImageProcess to reduce the file size. Dim IP As ImageProcess Set IP = CreateObject("WIA.ImageProcess") IP.Filters.Add (IP.FilterInfos("Convert").FilterID) IP.Filters(1).Properties("FormatID").Value = wia.FormatID.wiaFormatJPEG...

I have found a reference to Compression = 4107. This seems to be set at 0. Any other values I try to enter produce an error. Does anyone have an idea of what values I can use before I just try loads? There is also: Bits Per Pixel = 4104 Bits Per Channel = 4110 Channels Per Pixel = 4109...

That is something I didn't think of. I didn't write the code so don't have a full understanding of what can be set but I will now search along those lines.

[Solved] Microsoft Windows Image Acquisition Library very large scan file size I am using the Microsoft Windows Image Acquisition Library to scan directly from a button in an access form. I am using this to scan A4 files at resolution 200dpi in greyscale to jpeg. The scans captured by my...

I build the query with SQL in VBA. Using wilcards "*" works fine in access but then word reports no data. Using "%" instead of "*" shows no records in access but when word loads the query all the records are there. I have just created 2 versions of the query. One I can open in access and the...

I should have been quicker to search for an answer. It seem replacing "*" for "%" in the query solves the issue. Mods please delete if you feel the need.

I have a query in Access and a word document that opens up the query. Currently the query contains every record in the database. If I alter the query in Access to select a certain set of records (based on dates) when Word opens the recipient list is empty. Checking for errors it says there were...

Cheers all. I thought as much but wondered if there was a way round it. I will just add a field to the table and included it in the query.

I have some VBA code that generates a query and saves it. The query is a list of people who will be sent a communication along with the formatting for the communication. After producing the query I want to look through it and decide if there is anyone I don’t want to send the communication to. I...

I'm currently using the following to edit a publisher document using access VBA. For Each pubShape In pubDoc.Pages(1).Shapes If pubShape.HasTextFrame Then If pubShape.Name = "Text Box 440" Then pubShape.TextFrame.TextRange.Text = Item1 If pubShape.Name = "Text Box 441"...

You sir are a bona fide genius. That appears to work perfectly. Thank you very much. I will have a good look at what you have written to see if I can work out where I was going wrong but in case I can’t could I be a pain and ask you to fix this one also. Me.Filter = "[surname] LIKE '" &...

Thanks but this results in no current record so I guess I'm not implementing it correctly. Me.Filter = "[Surname] LIKE '"" & lastStr & ""*' And [First Names] LIKE '"" & firstStr & ""*'"

I either get errors when the code runs or it just results in no current record for any search. I am not sure where to place them correctly so have played around quite a bit but none of what I have tried works.

I've had a play around with double and double-double quotes and char(34) etc. but nothing seems to be working.

Sorry to open this up again but I have hit a snag. The code is working great apart from one issue. If I search a name such as Paul O'Callaghan by typing "o'c pa" I receive a Run-time error. It says Syntax error (missing operator) in query expression '[surname] LIKE 'o'c*' And [First Names] LIKE...

Thanks for your quick reply. Post edited. Just tried and works perfectly.