Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 1.06 seconds; generated 40 minute(s) ago.

  1. Replies
    22
    Views
    12,206

    [SOLVED] When I was informed of this very sad news a few...

    When I was informed of this very sad news a few days ago, it came as a great shock. I met unkamunka a few times during Lounge get-togethers in London and Prague; he was a talkative person with a very...
  2. Thread: Missing Member

    by HansV
    Replies
    18
    Views
    3,723

    Hello http://www.wopr.com/S/hello.gif There's...

    Hello http://www.wopr.com/S/hello.gif

    There's no need to worry about me - I'm alive and well even though I have stopped posting here. (And no, this reply does not herald my return.)

    Thanks for...
  3. Replies
    103
    Views
    12,952

    To all who replied: I'm deeply moved by your...

    To all who replied: I'm deeply moved by your words - and also embarrassed, it's a bit like reading your own obituary...

    [hr]

    we'll wish and imagine
    for what could have been
    and quietly miss...
  4. Replies
    103
    Views
    12,952

    To end this confusion: Slinky (the Lounger...

    To end this confusion: Slinky (the Lounger formerly known as HansV) has retired from the Lounge.

    I may have a look around from time to time, but I will no longer participate actively, and I will...
  5. Replies
    12
    Views
    1,375

    Apparently something has been changed, without us...

    Apparently something has been changed, without us being told about it.

    I can upload a head shot too now. But I still can't remove it - that leads to the login prompt I originally got when I tried...
  6. Replies
    12
    Views
    1,375

    BTW, removing an existing head shot picture...

    BTW, removing an existing head shot picture doesn't work either.
  7. Thread: New Mail Message

    by HansV
    Replies
    7
    Views
    892

    Sorry, can't help then. I don't have Office 2007...

    Sorry, can't help then. I don't have Office 2007 myself.
  8. Thread: Damnable red X

    by HansV
    Replies
    24
    Views
    3,816

    See RED X instead of graphics...

    See RED X instead of graphics for some suggestions.
  9. Replies
    11
    Views
    2,514

    Can't you simply right-align the values?

    Can't you simply right-align the values?
  10. Thread: New Mail Message

    by HansV
    Replies
    7
    Views
    892

    The default template is named NormalEmail.dotm...

    The default template is named NormalEmail.dotm and it is stored in your user templates folder. The default path of this folder depends on the Windows version; %appdata%\Microsoft\Templates should get...
  11. Replies
    7
    Views
    938

    Whether the file size will be 0 depends on the...

    Whether the file size will be 0 depends on the way the POS application writes the file - in one chunk or in smaller steps. But it's worth a try.

    You can check the file size before opening the...
  12. Replies
    7
    Views
    938

    You might try opening the text file for output...

    You might try opening the text file for output first. As long as the POS application is writing the file, that should not be possible, so you should get an error that you can intercept using an error...
  13. Replies
    7
    Views
    900

    Try vartitle =...

    Try

    vartitle = DLookup("ISBN","tbl_main","Replace(Replace(Replace(ISBN,"" "",""""),""-"",""""),Chr(13),"""")='" & Replace(Replace(Replace(Me.ISBN_No," ",""),"-",""),Chr(13),"") & "'")

    This...
  14. Replies
    7
    Views
    900

    We'd have to see the actual values that the...

    We'd have to see the actual values that the scanner places into the table. Could you post a (zipped) database with a small sample table? (We don't need to see the entire database)
  15. Replies
    1
    Views
    1,296

    Only by changing the first line of the contents...

    Only by changing the first line of the contents of the note. The "subject" of the note is calculated dynamically, it cannot be set separately.
  16. Replies
    9
    Views
    1,656

    Which legit security software are you using at...

    Which legit security software are you using at the moment? I use Norton AntiVirus and I've never been infected with any of these rogue security programs. I once got a message that Windows AntiVirus...
  17. Replies
    9
    Views
    11,826

    No, not really. You'd have to turn on track...

    No, not really. You'd have to turn on track changes before sending the workbook, but this automatically turns on sharing the workbook. As mentioned, sharing a workbook is dangerous, it can easily...
  18. Thread: Top 2000 songs

    by HansV
    Replies
    2
    Views
    882

    Almost every year, "Bohemian Rhapsody" by Queen...

    Almost every year, "Bohemian Rhapsody" by Queen is #1, with "Hotel California" by the Eagles close behind. The only exception was 2005, when the fan club of Dutch singer Boudewijn de Groot managed to...
  19. Thread: Headshot

    by HansV
    Replies
    5
    Views
    847

    This is what I see: [attachment=87390:x.png] ...

    This is what I see:

    [attachment=87390:x.png]

    When I right-click the image and select Properties from the popup menu, the URL is reported as http://upload.windowssecrets.net/uploads/av-24786.gif...
  20. Thread: Headshot

    by HansV
    Replies
    5
    Views
    847

    I do see a new .gif under your user name on the...

    I do see a new .gif under your user name on the left hand side of your post. Perhaps you have to refresh your cache to see it.

    A picture in your signature cannot be uploaded from your hard disk....
  21. Replies
    9
    Views
    11,826

    Excel is very different from Word in many ways....

    Excel is very different from Word in many ways. It has been/is being developed by a completely different team.
  22. Thread: Counting addends

    by HansV
    Replies
    15
    Views
    2,904

    You can't use GET.CELL in a cell formula. You...

    You can't use GET.CELL in a cell formula. You have to use it in a defined name, as Rory explicitly stated.

    Select Insert | Name | Define... (in Excel 97-2003) or activate the Formula tab of the...
  23. Replies
    2
    Views
    661

    I once reassembled a keyboard too soon after...

    I once reassembled a keyboard too soon after wet-cleaning the parts. It never worked correctly after that.

    I'm not sure Jupiter will like his Christmas gift...
    [attachment=87385:Jupiter.jpg]
  24. Thread: Sums in a Report

    by HansV
    Replies
    2
    Views
    557

    To get the sum for "Timely Submission": ...

    To get the sum for "Timely Submission":

    =-Sum(([timelysynchtooffice]="Timely Submission")*[sumoftotal])

    or

    =Sum(IIf([timelysynchtooffice]="Timely Submission",[sumoftotal],0))

    Similar for...
  25. Replies
    6
    Views
    880

    Yes, the attachment is present....

    Yes, the attachment is present. http://windowssecrets.com/forums/images/smilies/smile.gif
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4