Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mygmat123

    Parse elements in string with limits

    I have a string that I need to parse based on the number of elements. Using the string.... string="a,abc,car,bread,number,the,word,world,never,before" I would want to parse the string into three items per parsed string, then display. the end result would be.... msgbox("a,abc,car")...
  2. mygmat123

    dbDriverNoPrompt with no DSN problem

    thank you got it.
  3. mygmat123

    dbDriverNoPrompt with no DSN problem

    Does any one know how to check is a OBDC connection string is good and can connect? thanks If connection good, then 'do something else 'do something else end if PLEASE HELP!
  4. mygmat123

    dbDriverNoPrompt with no DSN problem

    Please help I really need a solution
  5. mygmat123

    dbDriverNoPrompt with no DSN problem

    I tried that too, and I still get the prompt when the password is incorrect. I've been trying to figure a solution all night and I am stumped. PLEASE HELP!
  6. mygmat123

    dbDriverNoPrompt with no DSN problem

    I have a problem trying to link my access table using VB I can connect using the below connection string .... Driver={SQL Server};SERVER=MYSERVER;UID=MYUSERNAME;PWD=myPASSWORD;DATABASE=myDATABASE; WHEN I USE.... Set dbsODBC = OpenDatabase("",False, False, strConnect) BUT IF I try...
  7. mygmat123

    online backup though dsl

    Thank you for helping me out. Exmerge might work, I just googled it. It looks like it merges two exchanges servers. But will it work over DSL and how much data is two much? In addition, can exmerge be automated, and what is the process?
  8. mygmat123

    online backup though dsl

    Any help is apprecaited!!
  9. mygmat123

    online backup though dsl

    I just ordered Small business server 2003 and I need a backup solution to backup the delta's(changes) to a remote server also with Small business server 2003 through a dsl line. What is the best/least expensive way to backup just the changes of the exchange server and SQL server to my remote...
  10. mygmat123

    reset page number

    THANKS TO ALL. I got mine working. I used the instructions from Microsoft, except, I needed to add, me.page=1 in the onformat code of the group header. It solved my problem. Thanks again to all. I hope this helps anyone with the same issue.
  11. mygmat123

    Auto Insert Date and Time

    I would create a table called "audit". with "audit_id"(auto-number) as primary key, "Field_name", "Old_value", "New_value". Then make an run an "insert" SQL command to the table. It will give you a nice audit trail.
  12. mygmat123

    reset page number

    If any one has any ideas, please post them. I could really use the help. Thank you
  13. mygmat123

    reset page number

    I followed the directions to start new pages numbers per group, but a very weird thing it happening. Check out this page on MS's Knowledge base: http://support.microsoft.com/default.aspx?scid=kb;en-us;306127 When I followed these directions, I don't get group1 1 of 2 2 of 2 group2 1 of 3 2...
  14. mygmat123

    remote procedure call failed(PLEASE HELP)

    yes, it worked after a opened outlook, but in the past my outlook was closed and it sent just fine. Why would that be? Maybe, when I quit outlook in the past it did not fully clear from the memory? What code should I use to open outlook and close outlook? Since this seems to be needed now...
  15. mygmat123

    Email Message is gone after choosing to preview using SendObject

    Try this........ Private Sub cmdSubmit_Click() On Error GoTo Err_Mail_Cancel Dim intSeeOutlook As Integer Dim intOption As integer intSeeOutlook = MsgBox("Preview e-mail message?", _ vbYesNo, Me.cboCaseName & Me.Caption)...
  16. mygmat123

    remote procedure call failed(PLEASE HELP)

    But if I click on any of the objects like .to, .cc, .bcc,.subject,.body etc. then I see that the .body=<variable or with block variable not set> With MailOutLook .TO = strTO .CC = strCC .BCC = strBCC .Subject = Subject .Body = Body End With
  17. mygmat123

    remote procedure call failed(PLEASE HELP)

    the error occurs happens at "mailoutlook.send".
  18. mygmat123

    remote procedure call failed(PLEASE HELP)

    Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook = appOutLook.CreateItem(olMailItem) I think the mailoutlook object is not getting set for some reason, but I don't know why PLEASE HELP I REALLY...
  19. mygmat123

    Email Message is gone after choosing to preview using SendObject

    does your send button on the preview form have the default message? Check to make sure your using the same code on the preview form as on the other form
  20. mygmat123

    remote procedure call failed(PLEASE HELP)

    ...Optional Subject As String = "Report (bla bla)", Optional Body As String = "Attached please find reports", Optional ByRef path1 As Variant) '********************************************************* ' TURN ON CLICK_ YES Dim wnd As Long Dim uClickYes As Long Dim Res As Long 'Register a...

Part and Inventory Search

Back
Top