Recent content by t1hodges

i found the problem. there was an Outlook email rule that was causing the duplication ><

yep only once!

i'm sure only once, but i'll check.

hello, plee for help. im writing code to send and email message to one recipient but it sends two in error. here's my code below. Imports System Imports System.Data.SqlClient Imports System.Data.Odbc Imports System.Net.Mail Imports System.Reflection Imports System.Data.OleDb Private Sub...

Thanks PHV. Im new to using these methods :) I will investigate and try it. Please let me know how to use that method if you already know, else, i'll post my results later. And thanks again!

in vba, demonstrate how to export excel files stored in Access as "long binary data" in an OLE data type field onto a network and readable using MS Excel. i have created the following code but the excel file it creates isn't readable with MS Excel presumably because the .xls file created is...

Actually got it to work. simply take OUT the in function. Public Function test() a = "everything" Select Case a Case is = "something","everything","nothing" Debug.Print "TRUE" Case Else Debug.Print "FALSE" End Select End Function

this is VBA

Has any1 ever created a select case statement using the IN function. For example, and this code block doesn't work: Public Function test() a = "everything" Select Case a Case is = in("something","everything","nothing") Debug.Print "TRUE" Case Else Debug.Print "FALSE" End Select End Function

i'd like to add, I used this code. It didnt like that my FindFirst value was a string and it gave an error. I luckily my field was a number so I changed the format to numeric and it worked well.

I figured it out that I only needed a part of your code and came up with this. shell ("C:\WINDOWS\SYSTEM32\cmd.exe /k ipconfig/all > test.xls") This works fine for me. Thanks a bunch!!!

during runtime i have two issues 1. application.wait what library reference needs to be set for this property to be available?

is it possible to call the cmd prompt with VBA, run a command like IPCONFIG /ALL, copy the results from the window and paste the results into a spreadsheet.

ok. I will experiment with it. I'll respond back asap.

this sounds promising. I'll look into it.