Search:

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

Page 1 of 11 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    18
    Views
    26,674

    Launchy - the Start menu killer

    A good article, for those who are still using the start menu ;-).

    Since I discovered http://www.launchy.net/ I've had very little use for the start menu. I'm not sure if you've already covered...
  2. Replies
    16
    Views
    2,266

    I also use Paint.NET for almost all work I do...

    I also use Paint.NET for almost all work I do with images. It's an excellent and completely free application. I have GIMP as wel for more advanced needs but I rarely ever need to use it. Paint.NET...
  3. Replies
    1
    Views
    338

    Re: find with 2 param (2000)

    Add a third column with the formula =A2&"|"&B2 and then search for "0500|puglia".
  4. Re: 'running' an excel file from command prompt? (

    The macros security warning dialog can be omitted by signing the workbook with a certificate created using selfcert.exe and then telling Excel to trust that certificate. That way you can still keep...
  5. Re: Set Up Terminal Services (Access 2000 and Windows 2000 Server)

    What exactly are you trying to acheieve? You say you want to 'get an access database running on Terminal Services'. If the Windows Server in question has Access installed then you can just do...
  6. Re: 'running' an excel file from command prompt? (2000/sp3)

    Ah, I see... it's shame that you're forced to do it this way... <img src=/S/boxedin.gif border=0 alt=boxedin width=25 height=20>.

    Is something like Windows Scripting Host not even an option?
  7. Re: 'running' an excel file from command prompt? (2000/sp3)

    I doubt you will be able to read the command line passed to excel.exe from the code within your excel workbook. Any command line switches (listed here) are for the consumption of excel.exe and I'd...
  8. Re: Obtain window 2000 userid (not username) (XP)

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

    You should not be deriving the path of the My Documents folder using the username. There are other methods which return the...
  9. Replies
    25
    Views
    3,419

    Re: Excel VB Constants (2003 and before)

    OK, I can understand why it makes things more convenient.

    I previously thought that the main purpose was to list all the numeric values and I couldn't see a reason for that, but point 3 shows why...
  10. Replies
    25
    Views
    3,419

    Re: Excel VB Constants (2003 and before)

    Can I ask what the purpose of having this list is?

    The whole point of having constants and enumerators is that you can reference them by name and not have to worry about the underlying value they...
  11. Re: UserForm_Activate() event not in object browser (2000 SP3)

    Add a UserForm to you project and MSForms will appear in the library dropdown in the object browser. UserForm is a class in that library.
  12. Re: UserForm_Activate() event not in object browser (2000 SP3)

    Events are definitely listed in the object browser.

    Look under MSForms, then the UserForm class. All the other events seem to be there, e.g. AddControl, BeforeDragOver, BeforeDropOrPaste, Click,...
  13. UserForm_Activate() event not in object browser (2000 SP3)

    Has anyone any idea why the UserForm_Activate() event does not appear in the object browser?
  14. Replies
    4
    Views
    456

    Re: versions of DAO (2000)

    Thanks to you all.

    The problem was that installation of a new product on our corporate network removed DAO3.5 and a legacy product broke which was using that version.

    We were wondering if it...
  15. Replies
    4
    Views
    456

    versions of DAO (2000)

    Hi,

    Can someone please tell me which version of DAO is installed with office 2000? I'm suspecting it's 3.6 but I'm struggling to find definitive confirmation of this.

    Thanks in advance,
  16. Replies
    3
    Views
    432

    Re: Looping (Excel XP)

    You're welcome! <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
  17. Replies
    3
    Views
    432

    Re: Looping (Excel XP)

    You don't need a loop, you can just write that forumla into the whole column at once, like so:-

    Range(ActiveCell,Cells(65536,ActiveCell.Column-1).End(xlUp).Offset(0,1)).FormulaR1C1 = "=LEN(RC[-1])"
  18. Replies
    9
    Views
    1,220

    Re: moving calendar items (XP SP2)

    I am using XP, yes. I checked help and the property is, indeed, Read/Write.

    I tried that line of code in the immediate with a calendar item open and, alas, the same error occurs.

    I'm totally...
  19. Replies
    9
    Views
    1,220

    Re: moving calendar items (XP SP2)

    Thanks John. This is exactly the approach I was trying and I've even written the VBA already. However, when I try and change the AllDayEvent property, or the Start or End properties, I get the...
  20. Replies
    5
    Views
    386

    Re: creating text boxes (2000 SP3)

    Thanks to both Brooke and sdckapr.

    I'm sure I'll be able to figure it out with the pointers you've given me.
  21. Replies
    5
    Views
    386

    Re: creating text boxes (2000 SP3)

    OK, I found out how to set it's text at last. It's the Shape.TextFrame.Characters.Text property.

    Still no idea how to add the connectors though.
  22. Replies
    5
    Views
    386

    creating text boxes (2000 SP3)

    I have an interesting project at hand.

    I have a system which is represented by a hierarchial object structure in VBA classes.

    The client would like to see a diagramatic representation of this,...
  23. Replies
    9
    Views
    1,220

    Re: moving calendar items (XP SP2)

    Is there any way of writing VBA code that automatically 'fixes' the items?
  24. Replies
    9
    Views
    1,220

    Re: moving calendar items (XP SP2)

    On further inspection, this has nothing to do with synch'ing with a Palm.

    It applies to any all day event in Outlook. If you create an all-day event and then change the timezone, the all-day...
  25. Replies
    9
    Views
    1,220

    moving calendar items (XP SP2)

    I have the following problem:-

    I synchronise Outlook with my Palm Vx. I have recently changed timezones by 1 hour (European to UK) and now, after changing the timezone on my PC and the time on my...
Results 1 to 25 of 271
Page 1 of 11 1 2 3 4