Search:

Type: Posts; User: BygAuldByrd; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Yippee!! I found a solution to my issue. ...

    Yippee!!

    I found a solution to my issue.

    Well I thought I had by using the following:

    I've inserted the following Macro in the Report "On Close" event:

    41893
  2. Hi Royce, Thanks for your suggestion,...

    Hi Royce,

    Thanks for your suggestion, unfortunately I don't see how it can apply as the database is not on a network and is not shared. It is single user on a single laptop.

    Cheers

    Trevor
  3. Hi Wendell, Thanks for your response. However...

    Hi Wendell,

    Thanks for your response. However I am unclear as to what you are suggesting. Below is more detail on the process being pursued in creating the Report for viewing only.

    The Query...
  4. Access 2010 VBA error message when closing report

    I call a Report from a Form (that provides filters for the underlying Query) which then displays an Excel Chart via a linked OLEUnbound object. The Excel Chart is updated by data from an Access Query...
  5. Access 2010/Excel 2010 OLE Server Not Registered - Cannot insert Excel Chart in Access Report

    I have serious issue when trying to insert a linked Excel 2010 chart into an Access 2010 Report.


    I have:


    created the chart in Excel 2010 (32 bit on Windows 7 Ultimate 64 bit)
    selected...
  6. Thanks Mark, Your simple suggestion worked...

    Thanks Mark,

    Your simple suggestion worked just fine.

    I put the Eval("...") statement in the Query that referenced the Query (strTQName).

    Cheers
  7. Access 2010 Query Filters - "Too few parameters. Expected 7"

    I have an Access 2010 Database I use for trading commodities.


    From my primary Table ([Tbl Evaluations and Trades]) I have a Query that summarizes commodities into markets and works perfectly...
  8. There's more info on this issue in "The Microsoft...

    There's more info on this issue in "The Microsoft Support Team Excel Blog" at...
  9. Thanks for the suggestion. WeFi looks...

    Thanks for the suggestion. WeFi looks interesting. I'll give it a try on my laptop and my Samsung phone for a few days and see how it performs.

    Cheers
  10. Changing the SSID goes against the grain of...

    Changing the SSID goes against the grain of recommended practice for maintaining seamless extended coverage - doing that is breaking the WLAN coverage into two coverage areas, thus requiring...
  11. Router/Repeater Connection to Strongest WiFi Signal

    I have a Cisco EPC3825 Cable Modem/Gateway/Router in the condo I'm staying in with weakish signal (typically -65dBm according to inSSIDer) in the study where my laptop is located. Being in a large...
  12. Seems this thread I started is heading in a...

    Seems this thread I started is heading in a different direction, although the information on heat sink grease is useful. I will get some and try it when I get home from my travels - not interested in...
  13. Hi Rory, Thanks for the prompt and very...

    Hi Rory,

    Thanks for the prompt and very helpful response. I went to your post at http://excelmatters.com/2014/12/10/office-update-breaks-activex-controls/ and your instructions resolved the issue...
  14. Excel 2010 - Button on All Worksheets Stop Working - Excel Update Problem?

    :mad::mad::mad:

    Today, after doing a Windows 7 and Microsoft Office Update, none of the ActiveX Control Buttons that select macros or VBA procedures on any of my Excel 2010 Workbooks work any...
  15. Re booting and working in Safe Mode - haven't had...

    Re booting and working in Safe Mode - haven't had a black screen while in Safe Mode with Networking, but then don't stay there that long as the frequency of the problem is too intermittent to allow...
  16. Hi Coochin, I have me doubts about the Sleep...

    Hi Coochin,

    I have me doubts about the Sleep Timer having an impact - on Battery (which I'm presently running without awaiting delivery a new one) it's set for "40 minutes" and "Plugged In" Never.
  17. Hi Sudo15 and Coochin, Thanks for your prompt...

    Hi Sudo15 and Coochin,

    Thanks for your prompt responses.

    I'm presently in Bangkok where the ambient temperatures (around 33C) are similar to those at home in Bogangar (located in northern NSW...
  18. Black screen and instantaneous total shutdown

    Hi,

    I hope someone can shed some light on a solution to my BLACK screen, instantaneous total shutdown (only the mains power LED active), then on restart, part way through the boot process, after...
  19. Hi Maudibe, As far as I'm concerned at this...

    Hi Maudibe,

    As far as I'm concerned at this time I've resolved the issue as noted in my post of 18 Nov.

    Thanks for your input. It is appreciated.

    Cheers


    Trevor
  20. Hi HTH, Thanks for the suggestion. It is...

    Hi HTH,

    Thanks for the suggestion. It is similar to one that I had tried and didn't really meet my requirements. I've also tried, in the past, having the charts on a separate sheet and using a...
  21. It is quite a big spread sheet. It starts out at...

    It is quite a big spread sheet. It starts out at about 50 narrow columns wide and 45+ rows which increases forever as more data is added daily.

    The top 30 or so (now reduced to 21) rows are taken...
  22. Problem resolved;) It was not the Scroll Lock...

    Problem resolved;)

    It was not the Scroll Lock key - thanks for pointing it out for me to check.

    The problem was that the top 31 rows of the Sheet are frozen and on my friend's computer, even at...
  23. Excel 2010 Workbook not scrolling nor Pageup/PageDown

    I have created an XLSM workbook using Excel 2010 (32 bit) that has two Password Protected Worksheets. It works perfectly on my Windows 7 64 bit computer and my Windows 8.1 32 bit computer, both using...
  24. Excel 2010: Visual Basic Error on Closing Excel

    Hi All Excel Experts,

    I have just edited an xlam file and reinstalled it. The VBA procedures within that file are working as expected.

    However, now every time I close (exit) Excel I get the...
  25. Hi RetiredGeek, Thanks, yes that does exactly...

    Hi RetiredGeek,

    Thanks, yes that does exactly what I desire - it toggles the Subscript on and off depending on how the last character in the string is set.

    Cheers

    Trevor
Results 1 to 25 of 128
Page 1 of 6 1 2 3 4