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!

  • Congratulations Mike Lewis 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: *

  • Users: TC002
  • Order by date
  1. TC002

    Can u move the msgbox position?

    Another way would be to use the API Message box. You have to declare about 9 API functions, about a dozen contants, and a create a function with about 10 lines of code. Then you use the API Message box, which is basically the same, except you can position it. With a few fore APIs and about 3...
  2. TC002

    I need help with a type of 'Select Case' statement

    Try this one: [COLOR=blue] Enum eBids ePaper = -2 eScissors = 0 eRock = 1 End Enum Enum eWinner eTie = 0 ePlayer1 = 1 ePlayer2 = 2 End Enum Public Function Winner(PlayerOneBid As eBids, PlayerTwoBid As eBids) As eWinner If PlayerOneBid <> eScissors And...
  3. TC002

    Error in DAO when using a function

    1). Ok guys, I'll be the first to say &quot;I'm sorry for any mis-understandings that I have had/made or caused, or any discomfort, or wrongly criticism&quot;. 2). I guess one can answer however they feel as long as no hard insults get exchanged - esp. when it is free service, and it is the...
  4. TC002

    Error in DAO when using a function

    Who was arguing up to the point that I was told that I wasn't listening? I thanked the two answers in the other forum, said it didn't work, got no more responses, asked the same here in this forum, got one answer and responded to the question asked of me, and then got the response from...
  5. TC002

    Error in DAO when using a function

    I've been away for 2 weeks and just now getting back. I am not a person to critize help I may get, but because of several comments such as &quot;...but you didn't seem to want to listen to them&quot; and &quot;Now, before you make noises ...&quot; I need to say that this answer has given...
  6. TC002

    Error in DAO when using a function

    The error as stated above is 3085 From the error listing under Help the text it: >>>>>>>>>>>>>>>>>>>>>>>>>>>>> Undefined function <name> in expression. (Error 3085) You entered an SQL expression that includes a Function procedure name that cannot be recognized. Make sure the function exists...
  7. TC002

    Error in DAO when using a function

    I posted this problem 4 or 5 days ago in forum &quot;Visual Basic (Microsoft Databases) under thread709-260314 and decided to post it here now to see if I can get some further attention. If anyone has had this problem and was able to solve it then please let me know how. 1. Why do I get an...
  8. TC002

    Error in DAO when using a function

    Thank you for responding Ok. Once again. I am not using MS ACCESS. I am Using a microsoft database (mdb) and accessing it through DAO/Jet. No, the round function doesn't have anything to do with Access 97 or 2000 but is used/interpeted by the DAO/Jet type libraries. I am not using DAO 3.6...
  9. TC002

    Error in DAO when using a function

    Thanks for responding - First of all, as I stated, I do not have ACCESS. Second, you say that later versions have a problem with this - BOTH machines have the latest versions of DAO350.dll! So I do not understand what went wrong. Please help further....
  10. TC002

    Error in DAO when using a function

    1. Why do I get an error using VB6 and DAO when including the ROUND function in a select statement one one computer and not the other - 3085? 2. How to correct? On Developer PC: VB6 IDE, NT, MDAC_Typ 2.5, Jet3.5 SP3, DAO 3.51 Database is an MDB '97 (Tables only) - no MS Access application On...

Part and Inventory Search

Back
Top