Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    5
    Views
    1,454

    Re: Conditional Form Background (VBA Access 2003)

    This is really helpful Hans. Many thanks

    one last quick question, how would I adapt if I were wanting to apply it to a continuous form?
  2. Replies
    5
    Views
    1,454

    Re: Conditional Form Background (VBA Access 2003)

    Hi Hans.

    It's just a single form.
  3. Replies
    5
    Views
    1,454

    Conditional Form Background (VBA Access 2003)

    Hi everyone.

    I was wondering if it's possible for the background of a form to change depending on the value of a control... i.e. if the value is null, then a colour, but if any other value or name...
  4. Replies
    4
    Views
    271

    Re: email from Access 2000 (2000/sp3)

    One last quick question. If I have access to a shared mail box, is it possible to have it sent from that, i.e. From:="myshared@myshared.com".... though I know that there doesn't work!!?
  5. Replies
    4
    Views
    271

    Re: email from Access 2000 (2000/sp3)

    Brilliant Hans. Works a treat. I had a feeling it would be simple.

    Many thanks

    Thom
  6. Replies
    4
    Views
    271

    email from Access 2000 (2000/sp3)

    Hi. i saw this in a previous thread.....

    Private Sub Command393_Click()
    On Error GoTo ErrHandler

    DoCmd.SendObject _
    To:="someone@somewhere.com", _
    Subject:="Your...
  7. Replies
    2
    Views
    841

    Re: Active Printer question (VBA/Word/2000)

    Brilliant

    Thanks Rory, works a treat

    Take care
  8. Replies
    2
    Views
    841

    Active Printer question (VBA/Word/2000)

    Hi everyone.

    I'm having a bit of a problem with default printers.

    I'm using the following code in a document to print a document to distiller but after it's done, the default printer for all...
  9. Re: Populate Word VBA Userform with Excel Value (VBA/Word/2000)

    Hi.

    It a prepopulated dropdown that the user selects from. i.e. Monday, Tuesday, Wednesday. Then if Wednesday is selected, a greyed out textbox on the form shows the value of A$1$ from the...
  10. Populate Word VBA Userform with Excel Value (VBA/Word/2000)

    Hi.

    I'm trying to have a value from a specified sheet/cell in excel appear in a userform textbox depending on the value of a dropdown list the user has already selected... if that make sense.......
  11. Re: ChangeFileOpenDirectory (VBA/Powerpoint/2000)

    It nearly works a dream, but for some reason it doesn't recognise if it's just about to overwrite a file with an existing name!!
  12. Re: ChangeFileOpenDirectory (VBA/Powerpoint/2000)

    Thanks Hans.

    Wow, that's an awful lot of code for something seeming so simple!!
  13. Re: ChangeFileOpenDirectory (VBA/Powerpoint/2000)

    Maybe there could be a work around. I've created code to open a new presentation, but because I want to keep the "Drawing Guides" setup that I want the user to see, i'm having the code open a...
  14. Replies
    4
    Views
    887

    Re: Cascading Combo Boxes (VBA/Word/2000)

    I spoke to soon. Got it.

    Thanks
  15. Replies
    4
    Views
    887

    Re: Cascading Combo Boxes (VBA/Word/2000)

    Hans. This is great, but i've been fiddling and trying to add another level, so if Lyon was selected, for example, then some more options will appear in a third combo box.
  16. ChangeFileOpenDirectory (VBA/Powerpoint/2000)

    Sorry for all the questions today!!

    But one last one. I know that in Word you can use the ChangeFileOpenDirectory to help direct a user to where you want a document saved, but is there a...
  17. Re: Remove all coding and Macros (vba/powerpoint/2000)

    Thanks Hans. Finally got it. I'd uncheked "Lock project from viewing" but forgot to remove the passwords. did the trick.

    many thanks

    Thom
  18. Remove all coding and Macros (vba/powerpoint/2000)

    I'm not sure how to do this but i'm wanting to purge a document of all coding and macros. But after deleting all the Modules and userforms etc, and closing down the VBA editor, closing the file and...
  19. Replies
    4
    Views
    887

    Re: Cascading Combo Boxes (VBA/Word/2000)

    thanks Hans.

    This is a very useful starting point.
  20. Replies
    4
    Views
    887

    Cascading Combo Boxes (VBA/Word/2000)

    Can anyone point me to any information or relevant posts here (i can't seem to find any) regarding Cascading Combo Boxes. I'm needing to create a Userform in Word which acts much as iTunes with a 3...
  21. Replies
    3
    Views
    294

    Re: Excel Line Chart (2000)

    Thanks Hans. As ever, this works really well. Something slightly different, but related to what i'm trying to achieve. Say I have a long list of dates in a column, A1 downwards, I want B1 to be a...
  22. Replies
    3
    Views
    294

    Excel Line Chart (2000)

    I was wondering if its possible, when formatting the X axis, in the Format Axis Dialog, Scale tab, rather than manually punch in numbers, have the number referenced from a specific cell for the...
  23. Replies
    1
    Views
    283

    On Entry (Access 2000)

    I know things like Private Sub Name_MouseDown(etc etc) or Private Sub Name_DblClk(etc etc), but what is the one for when you just simply enter or browse for a record? or am i barking up the wrong...
  24. Replies
    14
    Views
    564

    Re: Create Folder from field entry (2000)

    Brilliant. thanks Hans. Works a treat now.
  25. Replies
    14
    Views
    564

    Re: Create Folder from field entry (2000)

    Private Sub Cmd_Create_Folder_Click()
    On Error Resume Next
    MkDir "C:" & Me.DateYear
    MkDir "C:" & Me.DateYear & "" & Me.DateMonth
    MkDir "C:" & Me.DateYear & "" & Me.DateMonth & "" & Me.ID...
Results 1 to 25 of 88
Page 1 of 4 1 2 3 4