Search results

@arnelgp I don't have pdfToPrinter.exe on my PC and IT most likely wont install....

@oleronesoftwares I got it to close the reader with: Private Declare Function FindWindow Lib "user32.dll" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long Private Declare Function SendMessage Lib "user32.dll" Alias "SendMessageA" (ByVal hwnd As Long, ByVal...

@oleronesoftwares I open a .pdf and it opens prints and closes but it leaves the reader behind open. I attached a image of my tasks after its done. I did try a word document like in your video and everything was fine its just with a .pdf

Yes, it opens the file prints the file and closes the file BUT leaves Acrobat Reader open in my system tray. How do I get that to close as well? Thanks,

@Gasman I get that it opens I did read it, what stays open is acrobat reader but the doc does close.

@oleronesoftwares your code does work but just like the other one the doc closes but acrobat stays open? Dim docpath As String docpath = Me.txtUnboundSafetyCPath CreateObject("Shell.Application").Namespace(0).ParseName(docpath).InvokeVerb ("Print")

I found some code HERE from arnelgp that works but it opens the pdf and prints then closes. Is there a way I can hide the opening of it?

Hello, I have a textbox (txtUnboundSafetyCPath) that displays the full path to a .pdf document I selected. How can I print the .pdf using that path? I also need it to print it hidden.... Thanks,

@arnelgp Thanks I got it working with your example, I see how its working now! Before I thought I had to still enter a year every year but now its pulling from the table until 2050... Good one! Thanks again!

@arnelgp I checked out your example (Thank You), basically that's exactly what I'm doing now in my original database. What I originally do is for each employee I add the year each year and whether or not they bought a vacation and the data I need will show but who wants to do that every year...

@pbaldy I thought I had it but it seems I don't. I made a test query and if you run the test query it asks for a year. If I enter 2021 then I get the results I'm after BUT if I enter 2022 then I only get 3 results from employees who have no entries in the table (tbluBoughtVacation) and everyone...

@pbaldy I got it with your is null.... Thank you! SELECT tbluEmployees.EmployeeID, IIf([BoughtVac]=True,40,0) AS test, IIf([BoughtYear]=True,[BoughtYear],0) AS test2 FROM tbluEmployees LEFT JOIN tbluBoughtVacation ON tbluEmployees.EmployeeID = tbluBoughtVacation.EmployeeID WHERE...

@pbaldy I get the same results..... The problem I'm having is if I never entered a [boughtYear] or [boughtvac] for an employee then it wont display any result at all for that employee. If I go and enter lets say the year [boughtYear] in the table for the no result employee then it will show...

Hello, I need to create an query expression from my table that checks if there is a year [boughtYear] and if so is the yes/no field [boughtvac] true or false using a criteria and if there is a year then under my expression give a number 40 and if there is no such year then give a 0 for each...

Ok here ya go... I made it so if you wanted to set a supervisor inactive instead of moving all their employees you could and if you did move their employees then it sets them as inactive.

I got it worked out to where I choose a replacement supervisor and it moves all the employees that are under them to the new supervisor and then sets the old supervisor status to inactive. If anyone wants to see how I did it I can make up a test DB.... But wont be till NW Thanks All for the help!

@The_Doc_Man Im going to try that.... @pbaldy , sorry I fixed it and reuploaded it in the post.

@pbaldy I attached two forms one for supervisors and one for employees. I set Chuck Norris as inactive in the supervisor form.

I want to exclude their names in the cascading combos because there no longer active. I have a form that you can add/edit and set an supervisor inactive and on that form after setting them inactive they still show but show grayed out (disabled). I want to be able on that form to be able to have...

I just had a question and wanted some ideas or thoughts on how to handle this. Lets say I have a supervisor and for that supervisor they have employees. Now what can I do for the employees that are under a supervisor if I set that supervisor as an inactive? As it is now if I set an supervisor as...