Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    5
    Views
    1,948

    Dang... what a way to get recognition in the...

    Dang... what a way to get recognition in the Windows Secrets newsletter. Oh well...
  2. Replies
    5
    Views
    1,948

    Mea culpa - a typo in a fieldname explains the...

    Mea culpa - a typo in a fieldname explains the problem.
    Also, DLookup fails "quietly" if a fieldname is entered incorrectly. Rather than crashing in VBA, or giving a meaningful error message in the...
  3. Replies
    5
    Views
    1,948

    DLookup failure in Access 2003

    A section of an Access 2003 VBA project spontaneously stopped working. After some trouble-shooting, I isolated the problem to a DLookup function. Then operating from the Immediate Window, I found...
  4. Replies
    6
    Views
    1,184

    It worked. I removed McAfee using Control Panel,...

    It worked. I removed McAfee using Control Panel, and Windows Defender became activated. There was a bit of futzing to get everything to work properly (e.g. *something* turned off the WiFi, and it was...
  5. Replies
    6
    Views
    1,184

    confused about security options

    just purchased a new Acer Win 8 notebook computer that came with McAfee security installed. I intend to delete it -- I've always used MS Security Essentials on my other computers. Do I understand...
  6. Quick Steps in 2010 - how to get additional commands

    Trying to add a new Quick Step to my Outlook 2010, but the list of available commands is limited. Is there a away to add "Edit Message" to the list of commands that can be put into a custom Quick...
  7. Replies
    2
    Views
    3,009

    Martin - thank you for your thoughtful response....

    Martin - thank you for your thoughtful response.


    Jack
  8. Replies
    2
    Views
    3,009

    Solver: 2007 vs 2010

    A colleague developed and Excel 2007 spreadsheet that uses the Solver Add-in. His computer was recently upgraded to Excel 2010 while mine remained on 2007. We both made copies of the same file and...
  9. Replies
    4
    Views
    1,731

    chowur and Jock Older Inspiron computer that...

    chowur and Jock

    Older Inspiron computer that is not on the list at the URL listed. None of the keystrokes had any effect.
    Tried using Device Manager to disable the touchpad, but it only has...
  10. Replies
    4
    Views
    1,731

    Further info. Using the keyboard and Device...

    Further info. Using the keyboard and Device Manager, I can delete the HID-compiant mouse entries. The deletion survives a Windows logoff and logon. However, if I restart Windows, then the multiple...
  11. Replies
    4
    Views
    1,731

    How to delete mouse

    The mouse cursor on my Dell Inspiron notebook computer started going ballistic... it jumps all over the screen. With much difficulty, I can go into Device Manager and find there are three instances...
  12. Thank you!

    Thank you!
  13. Clear all paragraph formatting (PPT 2007)

    I understand that the Clear All Formatting button in the ribbon clears the TEXT formatting, and allows the Slide Master text format to prevail. However, it leaves the Paragraph formatting intact....
  14. Ian and Joe - you are both correct, of course....

    Ian and Joe - you are both correct, of course. It's just like deleting a shortcut from the desktop. I should have realized that myself!
  15. The Options checkbox is checked, as suggested,...

    The Options checkbox is checked, as suggested, but it still does not delete the file.

    On the other hand, when I go to the Music > Artists section of the WMP, and press Delete, a confirmation...
  16. I've created an Auto Playlist that shows all the...

    I've created an Auto Playlist that shows all the files with "+" in their Genre. Now I want to delete all those files from the hard drive. Pressing "Del" on the file in the playlist simply removes it...
  17. Replies
    103
    Views
    12,158

    Very late to this, but it finally occurred to me...

    Very late to this, but it finally occurred to me after posting my first question in many months: "waitasec... there's no answer from HansV". So I looked around and found this thread.

    Let me add my...
  18. Replies
    10
    Views
    1,328

    Back to this problem after putting it on the...

    Back to this problem after putting it on the backburner for a while. Tried a number of different approaches, but nothing that I could devise using a conventional SQL and JOIN worked with acceptable...
  19. Replies
    10
    Views
    1,328

    Sorry for the confusion. I forget how difficult...

    Sorry for the confusion. I forget how difficult it is to look at someone else's work.

    Yes, you are correct about the objective.

    The ZoneID and DayNo fields are used to pare down the list to a...
  20. Replies
    10
    Views
    1,328

    Mark It is an update query. I've tried all sorts...

    Mark
    It is an update query. I've tried all sorts of stuff to speed it up, including exporting the critical data into new tables in a new, temporary MDB file so it is always compacted when the query...
  21. Replies
    10
    Views
    1,328

    It's "wait till the end of the workday and set it...

    It's "wait till the end of the workday and set it up for overnight processing" absurd!
    I'll take your point about SQL Server under advisement, but this particular process is governed by a...
  22. Replies
    1
    Views
    678

    Details... The Int(StartTime) function was the...

    Details... The Int(StartTime) function was the culprit. Worked OK with the hardwired version, but failed with the parameter version. Changing it to CLng made it work.
  23. Replies
    1
    Views
    678

    Still working on the same problem as my earlier...

    Still working on the same problem as my earlier post today. Trying to avoid calling the query optimizer so many times in a VBA loop by using a parameter query. Tried two versions of a stored query:...
  24. Replies
    10
    Views
    1,328

    Might be exactly the opposite problem. Using the...

    Might be exactly the opposite problem. Using the JETSHOWPLAN item in the Registry shows that the optimizer is being invoked every time the db.execute statement is run. Looks like it might be too many...
  25. Replies
    10
    Views
    1,328

    Do "built on-the-fly" queries executed using VBA ...

    Do "built on-the-fly" queries executed using VBA "db.execute sqlString" syntax use the Jet Optimizer, or do they examine every record in the underlying tables?

    I've got a VBA process that uses a...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4