Search results

  1. A

    Unexpected Error (40230)

    I got the same error after splitting my database and making an MDE. SOLUTION: I had to fix any references in my database to point to the BE (when necessary) at which point the error was resolved. Using the link table manager to refresh links will not resolve the issue - the specific filepath has...
  2. A

    Error 424 Object required. OR How do I pass a field to a function in a SQL statement?

    I rewrote the necessary parts (see below) and it performs as expected. I opened 2 recordsets - used one to 'filter' the other using the Seek function. I suspect I could have used Filter function and perhaps had more elegant code but this is working so... I have posted this just in case it helps...
  3. A

    Error 424 Object required. OR How do I pass a field to a function in a SQL statement?

    Hi vbaInet, Unfortunately I can't - company restrictions and all that. I was wondering if I'd have to create a recordset and update that way... Thanks.
  4. A

    Error 424 Object required. OR How do I pass a field to a function in a SQL statement?

    Hi Thanks for your response. Yes. When I substitute a number for Manhole_Depth in the argument list, the correct cost is calculated and the records are updated with that value. It seems like this should work I'm just not sure why it doesn't. I pasted it in query design view and supplied values...
  5. A

    Error 424 Object required. OR How do I pass a field to a function in a SQL statement?

    Hi guys, I'd really appreciate some help with the following. The bottom line is the function HmhCostCalc (h,d,depth) returns a cost which is then inserted into the appropriate field via an update query. The user determines if it's field A and A_Cost, B and B_Cost etc. They also supply h and d...
Top Bottom