Search results

Ok the listbox doesn’t literally contain A1 A2 A3 etc. It contains a filename, date and description in each of the 3 columns. I do not know what it will contain until some other VBA code populates it. The number of rows also varies. How do I reverse the rowsource property in the manor described?

I have a 3 column list box in the format: A1 A2 A3 B1 B2 B3 C1 C2 C3 The rowsource for this contains A1;A2;A3;B1;B2;B3;C1;C2;C3 I want to reverse the order so I have C1 C2 C3 B1 B2 B3 A1 A2 A3 Which would give a row source of C1;C2;C3;B1;B2;B3;A1;A2;A3 Does anyone have a piece of VBA code...

That fixed it. What a stupid mistake to make. I think I am having one of those days.

I have quite an extensive form linked to a table. When I add new columns to the table I seem to have a problem getting the form to read the data. I have just added a numerical column to the table and added a text box on the form that is bound to it. When I try to pull up the value using VBA it...

They have changed the website. Replacing: "td class='address'>" with "td class='js-ont-full-address ont-hidden-on-smaller-than-tablet'>" in the code fixes the issue. I think there are 3 that need to be changed. As for Mintys post, cheers I will have a look as that sounds interesting...

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 '" &...