Search results

Please read about crossposts and why to avoid them. Also add link from here to SO Question and vice versa. In c:\windows\syswow64 ? Error raised during regsrv cmd or when access runs? Files don't have the mark of web? User has full permissions on the "C:\Klax\WKNL" folder/files? Or is it...

Show cmdline command! As you most likely use x64 OS, you need to use the SysWOW64 version of regsrv (c:\windows\syswow64\regsrv32). Elevated prompt? Full Paths (not only Filename) enclosed by dquotes? Office is x86? Maybe this helps: Unable to register dll using regsvr32 Windows Eventlogs may...

Try rubberduckvba, its Code Inspections will give you advice. Also read their blog (you may start with What’s Wrong With VBA? or OOP Battleship, but read them all)!

Please post only formated SQL (e.g. format with my link above), as not indendet Code is unreadable (what makes it unreasonable)!

@GaP42: Some typos and bad format. I used PoorSQL SELECT tblReservations.ID ,tblReservations.PropertyName ,tblReservations.GuestName ,tblReservations.CheckInDate ,tblReservations.CheckOutDate ,tblReservations.CleaningComments ,tblReservations.STATUS...

Found the "secret" Code for GetOpenFile_CLT. If you adapt it correct for x64 VBA (see How to convert Windows API declarations in VBA for 64-bit), it works, but what's wrong with Application.FileDialog (as moke had asked above)? Working x64 Code for GetOpenFile_CLT (only tested with standard...

Now retry your code (with same cmd) as it works for me (suprisingly the docs are not wrong ;) )

Ok, I beautified my original code (and didn't test it :( ) Try:wsh.Run cmd, 1, 1maybe waitOnReturn isn't a boolean, but an integer (then True is converted to -1) .

Use WScript.Shell and the .Run method with last parameter true and your code will pause till merge is finished. No need for user action or a timer!

I use PDFtk Server via commandline: Public Function MergePDFDocuments(ByVal pdfMaster As String, ByVal pdfChild As String, ByVal pdfMerged As String) As Long Dim wsh As Object Set wsh = VBA.CreateObject("WScript.Shell") Const pathToPDFtkExe As String = "path\to\pdftk.exe" Const...

As guessed button.enabled = false! Enable the buttons to use them.

Wrong DB attached? "greyed out" text indicates button not enabled.

Adding the demo from the-bang-exclamation-operator-in-vba can show what can get wrong, when using Bang. Also adding the explicit .item call, when referencing a collection member may be useful. Overall a hard task to explain this to non programmers, keep working on it (and then the same for...

Did you read Connect to an Access Data Source (SQL Server Import and Export Wizard) ? If you use SSMS without having SQL Server installed on the same machine, it uses SSMS x86, where you don't see x64 Data Sources. Or try SQL Server Migration Assistant for Access and if Access ist still your...

What about http://www.vbaexpress.com/forum/showthread.php?66081-PDF-Save-as-xlsx&p=395571 ? Both, Excel and Access, use VBA so code should work with minimal changes in Access too. Depending on Excel is installed too, you have to create an Excel instance and use the worksheetfunction with that...

Size can be set by defining Scrollbar.Min, Scrollbar.Max Properties.

And declares rsGuruChants and tb as Variant, what may prevent the unkown property error message. @cheekybuddha: I think we shouldn't show the Bang Operator to beginners, as it can cause errors, if one doesn't know what it does.

Why not use a timer with the build-in scrollbar and check if position changed, similar to https://isladogs.co.uk/subform-sync-scroll/index.html ? MS-Forms Scrollbar has a ProportionalThumb property.

The images are stored as attachments. To access them you need to know that they are stored as a recordset in the "Data" Field of MSysRecources. See Work with attachments in DAO. Sub ExportAttachmentsFromMSysRessources() Dim db As DAO.Database Set db = CurrentDb Dim mSysResources As DAO.Recordset...

So why not use them via VBA? E.g. you can run js, php and python code by using the command line via VBA. That should simplify signing/encoding as you can use their sdk. As you need webrequest, you should be aware of VBA-Web, what simplifies using request in VBA. If you open an issue there...