Search results for query: *

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")...

thank you got it.

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!

Please help I really need a solution

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!

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...

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?

Any help is apprecaited!!

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...

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.

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.

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

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...

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...

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)...

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

the error occurs happens at "mailoutlook.send".

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...

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

...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...