Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    13
    Views
    2,661

    Keith, Getting back to the original issue.......

    Keith,

    Getting back to the original issue.... I would take a serious look at printer drivers, at least to eliminate that as a possible cause. (No, really. It sounded to me at the time, at best,...
  2. Replies
    6
    Views
    545

    Re: Drawing multiple borders (2003 SP1)

    So upgrade it to SP1 and let's see if it breaks the drawing borders function! <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/wink.gif border=0 alt=wink width=15...
  3. Replies
    6
    Views
    545

    Re: Drawing multiple borders (2003 SP1)

    >Ive managed to get to a 2003 PC.
    >My pencil stays on when I draw borders.

    <img src=/S/shocked.gif border=0 alt=shocked width=15 height=15>

    Is your 2003 installation SP1? Maybe that's a...
  4. Replies
    6
    Views
    545

    Re: Drawing multiple borders (2003 SP1)

    Double-clicking doesn't seem to work. I see what you mean about double-clicking the Format Painter icon...that does work. But I tried double-clicking everything I could in the borders toolbar, and...
  5. Replies
    6
    Views
    545

    Drawing multiple borders (2003 SP1)

    In Excel 2002, when you select the border drawing tool, it 'stays on'--you can keep drawing borders with the pencil cursor until you click it off. But in version 2003, it clicks off after you draw...
  6. Replies
    3
    Views
    1,321

    Re: Windows Explorer

    Just a note to say that it takes effect immediately. No reboot required.
  7. Re: Explorer's 'file tips' info box (XP vs. XP SP1)

    Outstanding, Hans! Way to go!

    Thank you for taking the time to follow-up in this thread, many months later!

    And our estimators thank you too! Their file names are like this: 0302038.Est. ...
  8. Re: Return to record after re-sorting (2002 (SP2))

    Thanks everyone. I finally figured it out!

    Mark tried to spell it out for me, but I still missed one important step. It only took me a couple hours to catch it. :~|

    Here's the code I was...
  9. Re: Return to record after re-sorting (2002 (SP2))

    I'm just modifying the form's Order By property and Refreshing.

    Would that fall into the category of requerying? Or invalidate the bookmarks?
  10. Re: Return to record after re-sorting (2002 (SP2))

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    Thanks, Hans. That works too, and I may end up using that.

    But, I'm afraid I didn't ask the right question.The really...
  11. Return to record after re-sorting (2002 (SP2))

    I'm hoping there might be a more elegant way to do this.

    I have a form which looks like a datasheet. I have the "column headings" on the form set so that if you click a column heading, it re-sorts...
  12. Re: Explorer's 'file tips' info box (XP vs. XP SP1)

    More info ...

    I've since found that, on the affected workstations (those with SP1), if I move the file to a local drive, the additional information shows in the InfoTip box. The additional...
  13. Re: Explorer's 'file tips' info box (XP vs. XP SP1)

    If you wouldn't mind, could you try moving your file to a network drive to see what happens? Can you see the additional info?
  14. Explorer's 'file tips' info box (XP vs. XP SP1)

    In Windows Explorer, if you take your mouse and hover over a file (note, for this problem use a file, not a folder), a "file tips" box pops up with information about the file. At a minimum, the file...
  15. Re: INSERT INTO, eliminating confirmation prompt (2002, SP2)

    Here's the exact code I used:

    Set dbsNorthwind = CurrentDb
    SQL1 = "INSERT INTO tblCylinders(SampleID, CylinderNumber) VALUES([SampleID],'A');"
    dbsNorthwind.Execute SQL1,...
  16. Re: INSERT INTO, eliminating confirmation prompt (2002, SP2)

    Same thing. I get RTE 3061. "Too few parameters. Expected 1."
  17. Re: INSERT INTO, eliminating confirmation prompt (2002, SP2)

    This works (I had to omit the equals sign). I'll use this method for now, since I've not been able to figure out the Execute method.

    Thank you.
  18. Re: INSERT INTO, eliminating confirmation prompt (2002, SP2)

    >>CurrentDB.Execute SQL1

    I can't seem to get the syntax (or something else) right...

    I get Run-time error '3601', Too few parameters. Expected 1.


    I found the "Execute Method Example" in...
  19. INSERT INTO, eliminating confirmation prompt (2002, SP2)

    When I use the "INSERT INTO" SQL statement in combination with DoCmd.RunSQL to add a row to a table, for each row I add, I get the confirmation prompt "You are about to append 1 row(s) ... Are you...
  20. Replies
    15
    Views
    725

    Re: Use code to define a range (2002, SP2)

    I'm using Showcase Query to get the data from the AS400 and drop it into Excel. Showcase Query is using ranges actually named "LinkedArea1" ... "LinkedArea10".

    It looks like that NameManager...
  21. Replies
    15
    Views
    725

    Re: Use code to define a range (2002, SP2)

    Yes, exactly. The result is the same as using Union(R1,R2,...). Thank you.

    <rant on>
    And this is an excellent example of my frustration with the new Help systems in Office/VB. How am I...
  22. Replies
    15
    Views
    725

    Re: Use code to define a range (2002, SP2)

    The hidden question within the question ....

    Is there no way to extract the address of the first and last cell in a named range? Because even the Union(R1, R2, R3, etc.) seems ungainly---having...
  23. Replies
    15
    Views
    725

    Re: Use code to define a range (2002, SP2)

    I had stumbled across Application.Union(R1,R2...) in Help, but I completely missed the "..." in the example, to indicate you could string together more than just two ranges.

    Making a new range...
  24. Replies
    15
    Views
    725

    Use code to define a range (2002, SP2)

    This seems like it should be easy, but I have not been able to figure out how to do it ....(Since they moved everything to Visual Basic, the help system seems so useless to help you figure out...
  25. Re: Add BCC recipients & attachments list to hardcopy? (2002 SP1)

    Well, since you brought up the cosmetic things .... :-)

    The vbCrLf and vbLf are ignored when the message is in HTML format (all the attachments appear on one line, with no line feeds separating...
Results 1 to 25 of 37
Page 1 of 2 1 2