Search results for query: *

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.

Yeah. I think im giving up. Sorry about my brashness but I didnt want everyone to go off on the asp tangent; I know that route. Thanks for all your responses :) Tack care.

I dont know. thats way im here. I can develop data access pages but I want to build something robust. And If It cant be done, it cant be done. I live with it.

Do any of you know server-side javascript? the problem is that our RAD group is not allow to use any of the obvious it solutions. Im very good with access, excel and vba. I want to use asp but we are not allowed

I Need to create a web page that allows users to first log in, then second add, edit, and delete records in an access database. there will be aprox. five users on a LAN.

ok...Is there anyone else out there who can answer my question?