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...
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...
1). Ok guys, I'll be the first to say "I'm sorry for any mis-understandings that I have had/made or caused, or any discomfort, or wrongly criticism".
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...
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...
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
"...but you didn't seem to want to listen to them" and
"Now, before you make noises ..."
I need to say that this answer has given...
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...
I posted this problem 4 or 5 days ago in forum "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...
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...
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....
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.