What is the purpose of pdftool.dll in Windows?
My event log records that pdftool.dll threw exception code 0x0000005 in an MS Access application. I would like to know what the code might have been trying to do. Does anyone know what pdftool.dll (in C:\Windows on Win 10) does? It does not seem to be from Microsoft or Adobe. Details tab of properties show no description, Product name, Version or file version.
See also questions close to this topic
Run a cron job for a Php script in localhost of windows when the default port is not used
I have a task written in a php script which should run daily at a specific time.The task is to call an API method and write the results in a mysql database. I'm using xampp. Since port 80 is occupied by another task I've changed the port Apache server is using by changing the httpd.conf according to How to change XAMPP apache server port?
To set up cron job for my requirements I followed the steps here: Run Cron Job on PHP Script, on localhost in Windows
But the cron job doesn't work. The same steps worked well when the default port (80) was used in another machine.
Could someone let me know where else should I modify the port number for the cron job to work?
How to code (in Node JS Application) to add a path to Windows System Environment Path variable
I need to code in Node JS something like which has been performed in via powershell in this link https://codingbee.net/tutorials/powershell/powershell-make-a-permanent-change-to-the-path-environment-variable
Similarly I also need to code to set the System Environment path variable in my NodeJS application.
How to pass relative path of R to batch file
I have a batch file with the following code:
cd "%~dp0" "C:\Program Files\R\R-3.4.2\bin\i386\Rterm.exe" --no-restore --no-save < app.r > "shiny.log" 2>&1
The path to R is hardcoded and it runs well executing my 'appr.r' script. However, I would like to use a dynamic path to R because R might be on a different directory depending on which laptop I am using. My question is: is it possible to get the relative path of R in a batch file? I have some code that I use in an R script to find the relative path to R but I am not able to implement it in a batch file. How can I use the following code in a batch file to find the path to R?:
system2(paste(R.home("bin"), "/R", sep=""), args="CMD BATCH app.r shiny.log")
How to delete a record using macro in Microsoft Access?
I'm trying to use this macro action:
Currently my actions (After Delete on TableB) look like this:
Look Up A Record In TableA Where Condition = Old.SomeId = TableA.SomeId DelteRecord()
I'm obviously doing something wrong. I know for sure the two values are the same, because when I replace DeleteRecord block with "Create a record in tempLog" where I set two fields to the numbers, I get them to match.
My problem is that when I want to TableA then the block should fire, lookup the value in the other table, and then delete the matching row. I just can't get this "DeleteRecord" thing to work. Am I using it wrong? How should the structure look?
Data entry form - company intranet and Microsoft access
I am hoping for some help or ideas to how I can create a data entry form in our intranet pages that is connected to Microsoft access.
Basically we have an intranet and we also have a Microsoft Sharepoint.
I would like to create a data entry form on our pulse site where everyone in the company can fill out the form. But I would like the data that is entered in the form to be saved in a Microsoft Access database in SharePoint, where only a few people have access to it. Basically the people fill in the form, click submit (i.e) then the data they inputted is saved in Access on Sharepoint for me to view.
Appreciate every help I can get or guidelines or suggestions to where I can read about this. Thank you.
VBA Exporting Access DB to Excel
I have recently built an MS Access database to hopefully streamline some paper based processes at work. I have never used Access before or done any coding in VBA so apologies in advance if my code looks awful.
The database is working as intended and now I'm working on exporting some management reports to Excel. The management team wants the data exported into a specifically formatted Excel sheet instead of an Access report.
The export is tied on the
onClickevent of the test buttton on this form
The idea is that each unique piece of equipment shown in the form subform is recorded in the cells
[C7:C14], in theory there will never be more than 8 unique pieces of equipment to record. Note: I'm not actually running any code against the subform, I have been using other tables to get the data I need using values on the form as keys.
I have been able to get the following code to perform this correctly
tagNo = """" + Tag_Number.Value + """" EqSQL = "SELECT Equipment.Equipment_Name,Equipment.Tag_No FROM Equipment WHERE (((Equipment.Tag_No)=" & tagNo & "))" EquipmentCell = 7 ResponseCell = 7 Set db = CurrentDb Set rs = db.OpenRecordset(EqSQL, dbOpenDynaset, dbSeeChanges) Do Until rs.EOF EquipmentCellSt = ("c" & EquipmentCell) With wsheet .Range(EquipmentCellSt).Value = rs![Equipment_Name] End With EquipmentCell = (EquipmentCell + 1) rs.MoveNext Loop
The next task is to export the response values, so the first piece of equipment would require all its response values to be inserted in order into
[J7:AF7]and the next piece of equipment to
[J8:AF8]and so on.
I have a table called Inspection_Detail that is updated via the subform and holds all the data I think I should need for this.
My thinking so far I need to nest another loop in my current loop and execute a SQL query that pulls the response values but for the life of me I can't figure it out.
I have written a SQL query that grabs the correct record (some values are hard codes right now)
SELECT Export_Table.Equipment_Name, Export_Table.Task_No, Export_Table.Response, Export_Table.Notes, Export_Table.Tag_No FROM Export_Table WHERE (((Export_Table.Equipment_Name)="Pipe") AND ((Export_Table.Task_No)="A.1 Equipment") AND ((Export_Table.Tag_No)="scriptTest"));
I'm not sure how to build a loop counter to iterate though
[J*:AF*]and I have no idea how to pull just the response value out of the SQL query
Apologies if I'm missing anything vital out or just flat out not making sense, I have been stuck on this all weekend and my brain is fried.