Search results

I used printer.mdb and manually set the paper tray to tray 2. I then queried the printer number and it came up as 9. Adding a select case for "Tray2" and setting it to 9 still doesn't bring about use of tray 2 though.

That bit of code is where I tried to change it. MS site only gives numbers 1-14. I have a HP printer with only 1 tray that for some reason is set to 15, so I guess other number are available. I can manually select tray 2 with a preview report and it prints from tray 2. When I open the printer...

Well that's frustrating. The example printer.mdb does show my available paper bins. The problem is that selecting any of them still results in the use of tray 1.

I spoke to brother tech support. They suggested it is not possible as the printer is GDI rather than postscript. I have no idea why this would affect paper tray selection. I though it was how printouts were sent to the printer. Surely if I can choose different trays using printer properties this...

I just though I would post a follow up to this. After extensive code alteration I thought I had cracked it. I then however slowly found various issues with parts of the database e.g creating a document using a publisher template and then saving and opening it as a pdf. I decided to just move on...

I have a Brother MFC-J6920DW Printer. It has 2 main paper trays. I am trying to select each one for various reports. No matter what I do it always just takes paper from tray/bin 1. Set Application.Printer = Application.Printers("Brother MFC-J6920DW Printer") MsgBox...

Ok I think I have this sorted now. I have manged to remove Excel, Publisher and Word libraries and it still works on the Windows 10 machine. Just need to test it on the others and hopefully it will be ok.

Thanks, I will research that now that I know about it.

The problem is even if I don't make any changes, just open, save and close in 2016 it replaces the libraries. Is there no way to lock it to the 14.0 versions? This is going to be a real pain as I can't change some pc's up to 2016. I don't watch to downgrade office on my new pc. Can I actually...

I recently upgraded my PC and installed office 2016 (or 365). I have a database that I use across multiple PC’s. Most of these still use office 2010. When I have opened and saved the project in access 2016 it replaces some object libraries with version 16.0. The 2010 office only has version...

Yes I have posted in two places to see if I get more responses.

Please delete. Now solved.

I had a play around with my code and figured out a way to do it by building the rowsource in reverse instead of using additem. I think I was just having a brain freeze moment about how to do it. Call ListFiles("C:/files", , , Me.lstFileList) 'function contained in module 'MsgBox...

I admit it's not the most polished code but rather than completely rebuild it if I could just sort this one thing it would work perfectly.

I have a module that populates the listbox from files contained in a specific folder. I have then written my own code that adds a date and description to each row and produces a 3 column listbox with the first column hidden. All I have to work with is the rowsource. There must be a simple...

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...