Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BlackBearDude

    Invalid Procedure Call or Argument error

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

    Invalid Procedure Call or Argument error

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

    Invalid Procedure Call or Argument error

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

    Invalid Procedure Call or Argument error

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

    Invalid Procedure Call or Argument 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.
  6. BlackBearDude

    Invalid Procedure Call or Argument error

    No references are shown as MISSING.
  7. BlackBearDude

    Invalid Procedure Call or Argument error

    which reference?
  8. BlackBearDude

    Invalid Procedure Call or Argument error

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

    Invalid Procedure Call or Argument error

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

    Invalid Procedure Call or Argument error

    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?
  11. BlackBearDude

    attachment issue

    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?
  12. BlackBearDude

    Looking for a simple solution

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

    Anyone aware of a "true" title case function

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

    Aging Buckets in a Query

    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], ...
  15. BlackBearDude

    Need help creating query

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

    Need help creating query

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

    Need help creating query

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

    Need help creating query

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

    Need help creating query

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

    Need help creating query

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

Part and Inventory Search

Back
Top