Search results

I'm using win 10 64 and have access to a win 7 64 pc. I'm running office 2016 32bit. I tried the 2010 code version to. In the past I ran office 2010 64 and the declare function would turn red if not compatible. Currently that doesn't happen so I assume that part is OK.

[Solved] Retrieve paperbin info - I can't get this code to work I have tried to use the code here to retrive the paperbin info from my printer, but it just gives me an error. https://msdn.microsoft.com/en-us/library/office/ff197339.aspx It seems to fail on: lngBinCount =...

I recently figured out how to select and manipulate a printer in VBA. I have 2 printer/scanners installed. I would just like to use one to scan. Whenever I try to scan using WIA a dialog box pops up asking which scanner to use. Is there a way I can select the one I want to use automatically or...

Got there as below. Just tried with the hidden property and it worked. (And managed to delete my original post in process :/)

Ok I can select tray 2 using code. I have tried various iterations of the below code. I now know that print settings have to be saved to the report itself. I have done this manually and got it to work. I am now trying with VBA. Dim iSelectedPrn As String Dim strReport As String Dim strCrit As...

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