Recent content by ZMAN2

I agree that this is an excellent piece of code and an even better forum, but you can bypass this functionality altogether and enable/disable this property. Is there a way to prevent it from being changed in these situations?

Thanks for the reply. I thought it was kinda wierd that I would have to reference an excel function if I was in excel, but I checked and Microsoft Excel 9.0 Object Library was referenced. It doesn't work or my syntax is bad. Let's say I wanted to use the find function or substitute function...

How do you reference existing functions in excel? For example, if I try to create a function and use the existing function find() I get "Sub or Function not defined:confused: . Isn't this possible? I can use others like date(), now(), et.,..... Thanks is advance.

Thanks Thanks Rural Guy! I could have sworn that I tried that exact same code and it didn't work:rolleyes: What a noob! Thanks again.

Using VBA... How do I test for a particular open form? Then If open, populate a field on that form. Actually, I don't even need to test if it's open. I just need to populate that field on the form. DoCmd.Forms!myform![field1] = 1000 I tried using me, but its outside of the form class and...

Is it possible to programatically change the name displayed before sending. For example, when the recipient receives the e-mail it displays from "XXX" as opposed to "YYY" set in outlook. I guess sort of like e-mail spoofing, but not really. It's just a displayed from change. Does that make...

Thank you for your response. I may not be asking the right question. Can you join 2 recordsets with sql in vb? In other words, join rs1 and rs2 to form rs3???

What is the syntax to join 2 recordsets? Listed below are the recordsets that I am working with and now I would like to join them. Any insight would be appreciated. FYI, I did do a search on joining recordsets in VB, but I didn't come accross anything......Thanks again. Dim rs1 As...

Is there a command line option to run a function() in a database like /x to run a macro? Thanks in advance.

Thanks ReAn, Thank you for all your help. I have found the error in my ways, thanks to your sample code. Syntax, syntax, syntax.......:rolleyes:

Thanks ReAn. Yes, I have tried resetting the connect string, but I am still experiencing the same results. Perhaps a syntax problem, see below. qdf.Connect = "ODBC; SERVERNAME=myserver; DSN=connection; UserID=myid; PW=cheese;"

I have some code that updates the sql in an existing pass-thru query, my problem is when I attempt to run the query it prompts me for ODBC parameters. Any help would be appreciated. Dim db As DAO.Database Dim qdf As DAO.Querydef Dim strSQL as String Set db = CurrentDB Set qdf =...

Thanks That works for me. I appreciate everyone's input.

If I automatically load a table daily, is there a way to create or maintain a table of the load statistics? For example: Date-----------File----------------------Records 9/5/2005----No File Found------------------0 9/6/2005----c:\winnt\temp\file1.xls--------100 Thanks in advance :)

I'm sure this has been asked before, so I'm looking for search hints: I would like to select query results displayed in a form, by check box, and add them to a table. The results displayed in the query are random and this poses a problem, at least for me anyway. :rolleyes: Any ideas? Thanks...