Search results for query: *

Does anyone know how to send an email with a custom Outlook form? I can send with the correct form, but I need to know the syntax on how to access the fields on the form. Here's what I have so far: Dim oApp As Outlook.Application Dim oItem As Outlook.MailItem Set oApp = New...

You could do something like this: If Hour(Now()) < 1 Then ' do something here End If drost

Hi, Lloyd It worked fine for me when I inserted information to my database. I did find this on the MS site that may be useful: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q197902

Hi, Lloyd What is the name of your Database? That's what would go in the &quot;Initial Catalog&quot; portion of your connection string. I am guessing that DailyMktSegnewSql is a SQL statement? drost

Have you tried using Outlook? Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Dim objOutlookRecip As Outlook.Recipient Dim objOutlookAttach As Outlook.Attachment Set objOutlook = CreateObject(&quot;Outlook.Application&quot;) Set...

Does anyone know how to do this? I need to do the same thing. Thanks, drost

Thanks, shmiller. I've tried that and it doesn't help. It may even be slightly slower, which would make sense since it's running from the server instead of loading a 'copy' to the local system. Thanks for your post. drost

Hi, Phantom. This seems to work for me, I hope it helps: Public Function getVersion() As Long Dim osinfo As OSVERSIONINFO Dim retvalue As Integer osinfo.dwOSVersionInfoSize = 148 osinfo.szCSDVersion = Space$(128) retvalue =...

I am in the process of converting a program from a DSN connection using the Workspace object to ADO - DSN-less. I have the program completed, but with ADO, it runs much slower. Can anyone give me any tweaking advice? Here's my connection: With conServer .ConnectionString =...

I am writing a program that does several simple UPDATE statements and then does an .execute command immediately after each one. I have to connect to 2 different Oracle 8i databases in my program. My DBA has set up a view to one of the databases in the other so I now only need one connection...

Thanks, psinpsycle, I think we're on the right track...although I have added the registry setting, it still hasn't solved my problem. Did you have to do anything else, or did it start to work immediately after the registry setting was entered? Thanks, drost

I have narrowed this problem down some. I only have this problem when a specific control is on my form. When I use the Lead Tools Main control, I cannot connect. If I remove the control, I can connect without issues.... Strange, isn't it? Has anyone else ever had this issue?? mbpiper...

Thanks for your reply, woyler. I have installed MDAC 2.6 and still get the same results. Also, I am running Oracle 8.1.5 on all machines. Thanks, drost

Is anyone else having this problem? I am having the same problem. Thanks, drost

Does anyone know how to find a file containing specific text, as Windows Find.exe does? I need to, in code, search a directory for files that contain a text string. Thanks, drost

This was helpful, thanks strongm. Does anyone know how to do it with Acrobat?

I need to convert a .txt to a .tif in order to import it into our imaging system. Our system will only take .tif images.

I need to convert a .txt file to a .tif format. I have Adobe Acrobat and can open a .txt file and save it as a .tif, but haven't been able to do it in code. I don't need to do this with Acrobat, so if someone knows of a way to covert the file other that Acrobat, it would be very helpful...

I am using Clipboard.SetData LoadPicture to place a picture on a Word document. It works great, but have a small issue. While the program is running, if the user copies something to the clipboard at the right time, it will overwrite what I am trying to place in the document and place what the...

Elziko, Yep, an Oracle DB is different, you also have to set your Rec.CursorLocation = adUseClient This should work better for you, your recordset should return correctly. drost