Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Thanks for all the comments responding to my...

    Thanks for all the comments responding to my post.

    To comment on various points raised:


    Yes, my Thinkpad W541 is going to Airplane mode because it turns OFF both my Wifi and Bluetooth. The...
  2. Windows 10 Always Reboots to Airplane Mode

    Hi All,

    Every time I reboot my Lenovo Thinkpad W541 running Windows 10 (64 bit) it restarts in "Airplane Mode", draining the battery even when connected to the external AC supply.

    By the time...
  3. Hi Rory, :fanfare:Your's is a truely brilliant...

    Hi Rory,

    :fanfare:Your's is a truely brilliant bit of code:clapping: It's so fast I can't even measure the time it takes!

    As always, I'm learning how to improve my coding by the help and...
  4. Hi Zeddy, Many thanks for your code and the...

    Hi Zeddy,

    Many thanks for your code and the suggested refinements therein. It's given me some new techbiques to apply in future:)

    I've run your code against my data and your code runs in about...
  5. Hi RetiredGeek, I'm running 32 bit Excel 2010...

    Hi RetiredGeek,

    I'm running 32 bit Excel 2010 on windows 7 Ultimate 64 bit.

    Data is contained in about 10,000 rows and 17 columns.

    I can't work out where you saw "Integer" because "Find"...
  6. Thanks for the prompt responses and suggestions....

    Thanks for the prompt responses and suggestions.

    Excel shouldn't be running out of resources as my computer has 15.6GB of useable RAM with an IntelCore i7 CPU.

    I seriously doubt that cutting...
  7. Excel 2010 Hangs with Problem Event Name: AppHangB1

    I am using VBA in Excel to clean up an imported CSV file with nearly 10000 rows of data.

    Sometimes the procedure runs to completion without hanging:) Other times it gets about 6% through the rows...
  8. Outlook 2010 & MailWasherPRO: Errant Dialogue from System Tray

    Hi All,

    I'm using MS Outlook 2010 (version 14.0.7153.5000 (32 bit) and FireTrust's MailWasherPRO (version 7.5.0) and on my previous Lenovo Thinkpad T500 (Windows 7 64 bit) they worked together...
  9. Hi RetiredGeek & Rory, Thanks for your help....

    Hi RetiredGeek & Rory,

    Thanks for your help. The suggestions both of you made have guided me to success:clapping:

    Thanks heaps.

    Cheers

    Trevor
  10. Hi RetiredGeek, Many thanks for the Code...

    Hi RetiredGeek,

    Many thanks for the Code suggestions.

    Maybe I'm thick, but I can't see the point of the “Sub CompareWkBks()” procedure when I know already that I want to import some, but maybe...
  11. Hi RetiredGeek, Everything is in Excel VBA....

    Hi RetiredGeek,

    Everything is in Excel VBA. Why am I using ADO? Because that was code I found on the web that worked when I tested it. Can you suggest alternative code that will do the job.
    ...
  12. Excel 2010: Cannot update. Database or object is read-only

    I have an Excel (2010) Workbook with a command button on a Sheet containing the following code:


    Private Sub CommandButton1_Click()

    Dim TestCol As Collection
    Dim ThisWorkbook As String

    Dim...
  13. 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
  14. 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
  15. 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...
  16. 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...
  17. 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...
  18. 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
  19. 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...
  20. 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...
  21. 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
  22. 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...
  23. 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...
  24. 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...
  25. 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...
Results 1 to 25 of 140
Page 1 of 6 1 2 3 4