Recent content by BlackBearDude

Interesting ... clicking on the Compile menu item in the VBE also causes the error "Invalid Procedure Call".

Thanks for the info. However, if another form - one that I did not open - had corruption in any code, could that still cause this error in another form totally unrelated to the one with corrupt code? The reason I ask, is that I can place the snippet specified earlier into virtually any event in...

I created an empty database and exported all of the relevant forms, tables queries to it. I added a MsgBox "Hello World" to the OnActivate event and guess what? It is working. I checked all of the references in the new DB and they are the same references as in the original DB (where no event...

This is happening on stand-alone forms, simply "opening" the form which (in the ex. fires OnActivate) immediately causes the error.

Yes, everything is fine until a form or report is run. Then the Invalid Procedure Call or Argument. Very strange. Can't seem to find any reason for this to be happening. Just for test purposes, I'm inserting simple MsgBox lines within event code. It's happening consistently everywhere.

No references are shown as MISSING.

which reference?

For the record, this error occurs with any code placed in any event in a form or a report.

Yes ... as follows: Private Sub Form_Activate() MsgBox "Hello World" End Sub

What would cause this error on something as simple as placing a MsgBox "Hello World" line of code in an OnActivate event of a report or form?

Is this possible to control? I have an email, I'd like to attach a file to. In addition, I want to CC someone else, but do not want them to get attachment. Is this possible to arrange with Office?

I've got a small application developed with VB6. I want it to run from a network drive. Theoretically, the only files the user needs locally are the applicable DLL's, etc. No need to have the .EXE local, or .RPT's (crystal). The app hits an ADO data source that lives in same folder structure...

I am in need of a function to convert any string to true title case. For example: "the time of day" should be converted to "The Time of Day" in addition, it should handle or allow for exceptions such as "PO Box", "NE, SW, NW, SE", "O'Brien...

The partition function is covered here: http://www.database-design-2000.com/fudd.htm you can also do this with your data: SDATE AMT 10/2/2003 125.00 9/12/2003 650.00 11/1/2003 250.00 4/22/2003 300.00 you can do something like: SELECT [InvoiceORwhatever], ...

FINALLY worked SELECT table1.[casenum],sum(iif(type='bldg',fee,0)) as bldgfee,sum(iif(type='elec',fee,0)) as elecfee, sum(iif(type='driveway',fee,0)) as drivewayfee, sum(iif(type='roof',fee,0)) as rooffee FROM Table1 INNER JOIN Table2 ON Table1.casenum = Table2.casenum WHERE...