Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. To answer some points in more detail. Access...

    To answer some points in more detail.

    Access SQL / ANSI SQL / T-SQL
    There are as many flavours of SQL as there are SQL database systems. ANSI is in theory the "standard" and most SQL dialects...
  2. The articles others have referred you to should...

    The articles others have referred you to should help, but a few other suggestions.

    Use Windows Authentication. SQL Server authentication is insecure in a networked environment. Windows is more...
  3. Replies
    4
    Views
    242

    I only included the ldb bit because that has been...

    I only included the ldb bit because that has been the cause of more than one support issue - damn MS for defaulting Windows to hiding the file extensions and then naming .ldb so it appears above .mdb...
  4. Replies
    4
    Views
    242

    How unresponsive? Do they give a context menu if...

    How unresponsive? Do they give a context menu if you right-click? If not, I have no ideas. If they do, here are some avenues to explore.

    I suggest it is the Access application that is...
  5. Replies
    4
    Views
    819

    Connecting to a domain server from a workgroup PC...

    Connecting to a domain server from a workgroup PC is straightforward, including mapping drives. You just need appropriate credentials. I've been doing it for years and it is common for clients moving...
  6. Replies
    5
    Views
    2,009

    Depends on what you are trying to achieve. As the...

    Depends on what you are trying to achieve. As the Turkish President found out when trying to ban Twitter, there are ways around anything on the Internet. You don't need DNS or HOSTS to surf the net,...
  7. Replies
    3
    Views
    306

    Would that be 8 inch, 5 1/4 inch or 3 1/2 inch?...

    Would that be 8 inch, 5 1/4 inch or 3 1/2 inch? Cue stories about users folding the disk to fit in the smaller slot. A few years ago firmware updates on a Windows Server required a floppy disk. And...
  8. Replies
    3
    Views
    306

    Useful tips from Microsoft!

    Hi all

    While researching an Excel problem just now I came across this Microsoft tips article from a few years back:

    http://support.microsoft.com/kb/843504/EN-US

    Some of the tips will be well...
  9. Replies
    3
    Views
    591

    "as a simple internet search will reveal" -...

    "as a simple internet search will reveal" - actually quite a complicated internet search but I did find it. And I assume you've read the causes and tried the solutions. The page Microsoft support...
  10. Replies
    4
    Views
    315

    =IF($A5*(1+HighPercent/100)

    =IF($A5*(1+HighPercent/100)<LowSalary,HighPercent,IF($A5*(1+LowPercent/100)>=LowSalary,LowPercent,(LowSalary-$A5)/$A5*100))

    Formula in Col B alongside the old salaries in Col A, HighPercent is 15,...
  11. Partial answer. The problem is maybe that your...

    Partial answer. The problem is maybe that your values are text but you want a numeric comparison "11.37" is alphabetically less than "7.60" but numerically greater. I tried the following:

    Enter...
  12. Replies
    2
    Views
    310

    As with all things Microsoft, the later the...

    As with all things Microsoft, the later the version the deeper the useful controls!

    File->Options->Trust Center->Trust Center Settings->Macro Settings

    You might like to instead add the location...
  13. A couple of points on longevity. It is my firm...

    A couple of points on longevity. It is my firm belief that writing with good ink on a good substrate, and making many copies, is a reliable way to preserve information. It has been proven to work for...
  14. Indexes. Don't go wild, as maintaining...

    Indexes.

    Don't go wild, as maintaining indexes on big tables can be slow, but well chosen indexes can make all the difference.

    Obviously the primary key field(s) in your tables are...
  15. The trouble with constantly backing up all data...

    The trouble with constantly backing up all data rather than using an incremental scheme is that you are regularly backing up maybe 100 or 1000 times as much data, because the vast majority of your...
  16. Replies
    29
    Views
    7,538

    Very good advice that can't be publicised enough....

    Very good advice that can't be publicised enough. For the paranoid, I'm 99% sure that a malicious web page can't intercept <alt>F4.

    And while on the subject of "don't click":

    When downloading...
  17. Have you defined indexes on the fields the...

    Have you defined indexes on the fields the shfQBOrderInfo queries use for linking/sorting? Doing so might speed them up enough that you don't have to do these manipulations.

    Once upon a time...
  18. Replies
    18
    Views
    1,769

    I know this is an old thread but... Everyone...

    I know this is an old thread but...

    Everyone is fixed on the "empty" field being NULL, but what if it is just blank? Testing for nz(dlookup(...), '') = '' (count those quotes) instead of...
  19. I fundamentally disagree with Fred's assessments....

    I fundamentally disagree with Fred's assessments. Here's why

    First, is speed really the most important factor? I think not. Convenience and reliability are most important. The world's fastest...
  20. Replies
    2
    Views
    1,728

    It affects specifically Chrome version...

    It affects specifically Chrome version 32.0.1700.76 m (as displayed if you click the Chrome menu button on the right and then About Chrome). It also apparently only affects HTML scrollbars such as...
  21. Replies
    2
    Views
    1,728

    Chrome v32 scrollbar problem

    Hi Loungers. Hope some of you find this useful.

    When Google launched Chrome v32 last week they changed the scrollbars to a Windows 8 look. In the process they introduced a serious bug. I spent...
  22. Replies
    20
    Views
    4,430

    20 years ago we'd just got the first Pentium...

    20 years ago we'd just got the first Pentium processors and compression meant WinZip so it would be slow. Nowadays Windows opens compressed archives without even blinking. I said I don't compress,...
  23. Replies
    20
    Views
    4,430

    Although I've never compressed a drive, I've seen...

    Although I've never compressed a drive, I've seen conflicting views on this one. I strongly suspect this should just be "It's not a good idea to compress your swap file" and Windows doesn't do that...
  24. Replies
    12
    Views
    1,313

    Hi Jean. A bit of googling suggests other users...

    Hi Jean. A bit of googling suggests other users had the same issue as my wife. The windows key gets you back to Windows and you can do stuff, but the banner remains in the front of everything. And...
  25. Replies
    12
    Views
    1,313

    Windows 8.1 - have I bypassed it?

    Sorry for the non-specific thread title, I couldn't think of a concise description of my problem.

    I bought my wife a new laptop for Xmas. So she would be able to use it right away I set up Win 8...
Results 1 to 25 of 115
Page 1 of 5 1 2 3 4