Posts by max_lux

    Re: Saving over VPN


    Why dont you have the book remain open and retry the server at timed intervals with ontime?


    or, use sheduling agent to open the book at intervals to retry if required, and close if not? You could set a tag so it would retry if required and close if not

    Re: Combobox repeating options


    and what happened to?


    White European
    White North American
    White South American
    White Central American
    White South American
    White African
    White Pakistani
    White Indian
    White Asian


    Black European
    Black North American
    Black South American
    Black Central American
    Black South American
    Black African
    Black Pakistani
    Black Indian
    Black Asian


    Asian European
    Asian North American
    Asian South American
    Asian Central American
    Asian South American
    Asian African
    Asian Pakistani
    Asian Indian


    Pakistani European
    Pakistani North American
    Pakistani South American
    Pakistani Central American
    Pakistani South American
    Pakistani African
    Pakistani Indian
    Pakistani Asian


    Indian European
    Indian North American
    Indian South American
    Indian Central American
    Indian South American
    Indian African
    Indian Pakistani
    Indian Indian
    Indian Asian


    Native European
    Native North American
    Native South American
    Native Central American
    Native South American
    Native African
    Native Pakistani
    Native Indian
    Native Asian


    Not Stated

    Re: Saving over VPN


    Something like?


    Re: Saving over VPN


    You could have it go to email client as an attachment easy enough, but setting up the email to not open is difficult to do, as email proggies are set up to alert if being used.


    I set up something similiar, so a report is saved to the hardrive and sent to default mail program as an attachment. I then (only works if email is not pass-protected for default user at startup) run the email prog and have it send receive automatically.

    Re: save as conflict


    make sure and use


    Code
    Application.DisplayAlerts = False


    to turn this feature off, and then


    Code
    Application.DisplayAlerts = True


    to turn it back on again

    Re: Time mask problems


    something like?


    =If (original formula, answer,(LEFT(A1,LEN(A1)-4)+(MID(A1,LEN(A1)-3,2)+RIGHT(A1,2)/100)/60)/1440)


    use your original formula because it worked under 1 minute, and Derks if it goes over the 1 minute?

    Re: Enabled/Disable Button


    You have to reference properly, in two different places.
    Check the vb editor for the actual sheet name. Each sheet should show as something like:
    Sheet1(WEEK)
    Sheet2(MONTH)
    etc. ---> use the actual sheet name, not the one on the tab.


    ... so therefore should be something like:


    Code
    If Sheets("WEEK").Range("C62").Value = "Admin" Then 
        Sheet1.CommandButton6.Enable = True 
    Else 
        Sheet1.CommandButton6.Enable = False 
    End If