Search results

  1. R

    Syntax Error with DSum Statement

    You're right, I did this with a query and it works perfectly. Thank you.
  2. R

    Syntax Error with DSum Statement

    Thanks for your reply. I'll try this.
  3. R

    Syntax Error with DSum Statement

    Thanks for your reply. Your code does not produce an error but does not give me the running total.
  4. R

    Syntax Error with DSum Statement

    TransactionNumber is a number stored in a Number field. Account is a text string stored in a text field.
  5. R

    Syntax Error with DSum Statement

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

    Shell function slow response whne PC is connected to router

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

    Shell function slow response whne PC is connected to router

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

    Shell function slow response whne PC is connected to router

    Thank you for your reply. The delay is in the range of 8 to 12 seconds but never as long as 30 seconds and occurs only when Access is running.
  9. R

    Shell function slow response whne PC is connected to router

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

    Shell function slow response whne PC is connected to router

    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 &...
  11. R

    Cannot Rename a Report

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

    Cannot Rename a Report

    Yes, I have closed the database, reopened it and get the same result. Thank you for replying.
  13. R

    Cannot Rename a Report

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

    Insert special characters with command button

    Thanks jdraw and GalaxiomAtHome for your response. I think I've about got this figured out.
  15. R

    Insert special characters with command button

    I often use a few special characters when entering data, characters not found on the keyboard and that cannot be entered by the Alt+keystroke method. At present I use the Windows Character Map to copy and paste them, but this is inefficient. I want to create small command buttons for each...
  16. R

    Calculate total value of items in a list box

    Thanks, Steve R.
  17. R

    Calculate total value of items in a list box

    I am a VBA novice and am trying to create a simple household inventory application for personal use. I have categorized household items into Appliances, Furniture, Housewares and so on. A table called tblItemInfo includes the fields Category, Item, Location, Cost, TaxRate, and DeliveryCost. My...
  18. R

    Delete files with command button

    Thank you very much, David. This worked like a charm. Just what I needed. Rod
  19. R

    Delete files with command button

    Thank you, DCrake, for your suggestions. You have given me much to consider. I am aware of Kill but I can't quite figure out how to write code to make it grab the ItemNumber stored in the record to be deleted. I tried the following but it didn't work: Kill "D:\HHInventory\" &...
Top Bottom