I am trying to build a personal check register application and I need to write a DSum statement with two criteria as the control source of an unbound text box control which give me a running balance and I can't get the syntax correct. TransactionAmount and TransactionNumber are both number...
I finally discovered the solution to my problem. When connecting to my network I must check the Connect Automatically box. When I do this there is no delay in displaying PDF's.
Thanks to all who replied.
Thank you for your reply.
I tried your code but unfortunately the result is the same. I get a not responding message with a delay of about 10-12 seconds.
Thank you for your reply. Sumatra is a light weight PDF reader that I have used for quite a while. It doesn't have the bloat of some others and pops up instantly outside of Access. This issue is specifically to do with Access. I'll try reporting the issue to MS.
A command button on my form runs the Shell function to open a PDF viewer which displays the PDF file associated with the current record.
Dim strClickScan As String
strClickScan = Shell("C:\Program Files\SumatraPDF\SumatraPDF.exe ""D:\Periodical Reference Index\" & txtRecordID.Value &...
Sorry for the delay in replying. I had to be away for several hours.
I did just as you advised and did not get the error so I figured it must be syntax issue. I took a really close look at my variables and their assigned values and I found the problem. The code now works as I intended. I also...
I want to rename a report by clicking a command button on a form. I have this simple code in the click event:
Dim strReportNameNew As String
Dim strReportNameOld As String
strReportNameNew = txtChangeTo.Text
strReportNameOld = txtChooseReport.Text
DoCmd.Rename strReportNameNew, acReport...