Search results for query: *

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...

John, Thanks a bunch for your help. The SQL statement you presented earlier certainly should work. I'm not quite sure why it isn't. I've done this many times when I used to program in Foxpro/VFP. Unfortunately, I can't control what other people use for "data management". I'll keep...

John, It is not doing the trick. I thought of this earlier today and couldn't get it to work as expected.

John, Essentially, each casenum can have one or more permit fees. When a specific permit fee is not present, I need to report 0.00 in the appropriate location on the report form. Using the crosstab, when a permit fee doesn't exist for a casenum, no column is created in the result set. I need...

John, Thanks! The crosstab does basically what I need, except that columns aren't created where there was no value (for a particular casenum). My need beyond this is to find a way (in a report) to substitute the value $0.00 when a column for a permit type is not reflected in the crosstab...

I need to take a table such as: casenum type fee 222 elec 50.00 222 bldg 25.00 333 dway 75.00 333 elec 50.00 444 bldg 25.00 and turn it into: casenum bldgfee elecfee dwayfee 222 25.00 50.00...