vbCNEW 0 Light Poster

hi. im so lost now. teying to look fro a reason for this error but come up empty.

heres me problem, Im using MS access as my DB. and VB.net

i have a query in my DB that uses a USER-DEFINE FUNCTION...

If i open my query in the ACCESS,, it works fine.. it computes date as it was designed.

So last thing to do is Select the QUERY table in VB.net like this:


SELECT * from qryDates

NOTE that the qrydates uses a USERDEFINE FUNCTION Get_Date().


now my problem is it promtps : Undefined function 'Get_Date' in expression.


why it happens?
thanks...

vbCNEW 0 Light Poster

Hi,

Im very curious how to compute exact probablility of a certain slot machine games? Even samples will do.


Thanks...

vbCNEW 0 Light Poster

hi AUTHOR,

Im I read your code, its ok. but i think u need to stop for a while and think of a beter way of doing it.. but what you did is really nice..
what im trying to say is to change the way you do you GAME DISPLAY UPDATE...

heres an idea..

The better way and easiest way approach is

LOOP

DISPLAY SNAKE
DISPLAY FOOD
DISPLAY ENEMY
CHECK Kbhit()
CHECK SNAKE_BOUNDERIES
pause(100)
CLS
END LOOP

that is your main loop... everything is there already..

now maybe you ask how you control your snake?
inside your CHECK KBHIT()
just update the VARIABLE you use for your snake coordinates..

ex.
if(ch=='w'){y--;}

i hope you understand...

vbCNEW 0 Light Poster

hey i think thats impossible.. but you can do it this way..

declaration...
function testdet(testrange as string) as double

see..
now all you need to do is pass a string

range in macro is cell value( if im not mistaken),
and array is a series of values..

in the case of array, you just need to concatenate the array values to one string using a UNIQUE delimeter (ex. "|")
then pass it to the string parameter..

hope it helps..

vbCNEW 0 Light Poster

dont use macro use vb or batch file. your problem is not that clear .. i want to help but explain and give sample pls...

vbCNEW 0 Light Poster

hey i could help you but i cant understand what u want.. post here a sample data and your expected data after running the macro.. then put even alittle explaination.. then ill send you your code.. tnx

vbCNEW 0 Light Poster

in VC++ directory -- library files --> i add c:development\external\lib
in VC++ directory -- include files --> i add c:development\external\include


after that i open configure.dsw

build...

heres the error


CVTRES : fatal error CVT1100: duplicate resource. type:MANIFEST, name:1, language:0x0409
LINK : fatal error LNK1123: failure during conversion to COFF: file invalid or corrupt
Build log was saved at "file://c:\development\ClanLib-0.8.1\Debug\Configure\BuildLog.htm"
Configure - 2 error(s), 15 warning(s)
========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ==========

vbCNEW 0 Light Poster

i already did that...

add lib directory in c++ library path

add include directory in c++ library path

that error makes my compile 24 succeeded and 24 failed...

sorry if i cant help..
thanks though..

vbCNEW 0 Light Poster

i tried it again. but here the errors

Cannot open include file: 'dinput.h': No such file or directory

and

Cannot open include file: 'dsound.h': No such file or directory

and

Cannot open include file: 'png.h': No such file or directory

and

Cannot open include file: 'jpeglib.h

do you know how to fix this..

thank you very much...

vbCNEW 0 Light Poster

good afternoon.. do you know how to install or configure clanlib in vs2005 ?? im getting hard time... i tried it so many times but up to now i havent succeed... i read this link
http://www.clanlib.org/docs/clanlib-0.8.0/Tutorial/Kavanek/01-Installing.html#windows
but its hard to understand and im not sure if i download all file they say...
i never found a external libraries they were claiming... is it all the links???

im using xp(OS)...

pls help..
im desparate.. tnx

vbCNEW 0 Light Poster

you should decclare previndex static or global not inside the procedure..

vbCNEW 0 Light Poster

hello... im an experience VB 2D game programmer... if u need any help.. jusr email me in my account oluapseyer83@yahooo.com
im wasr able to check my daniweb from time to time..

vbCNEW 0 Light Poster

i guess when u say populate u mean ur running inside a loop and populate one by one.. so all u need to do is put DOevents in your code.. in side the loop so you could still cancel ur work..

vbCNEW 0 Light Poster

use this::

dim arr() as string
st= "text1/text2"
arr= split(st,"/")

vbCNEW 0 Light Poster

hello anud18.. i think veena is right. if ur just doing a login forn... try call it then proceed to the process u want after the clicked event..
sometimes we need to change everything to fixed our problems!!!

but if u really want to put a code as it is...
and u want a wait until button is pressed??? try put a loop before the process need to be executed after the clicked and put a DOEVENTS .. use the variable to end the loop.. i hope it helps

vbCNEW 0 Light Poster

your welcome... actually your last problem is easy to solve... me myself have no idea how before you raise that question... all u hav to do is search into the net.. try goggle!!! its easy really..

so heres the link for you..
http://www.samspublishing.com/library/content.asp?b=STY_VB6_24hours&seqNum=132&rl=1

im willing to help but maybe next time try to solve it first before asking for any help..

ok??? pls dont be offended..

vbCNEW 0 Light Poster

try this code..

Printer.print "Message"
printer.enddoc

this will directly print your text to the printer attached.( just be sure to configure the printer in the control panel) try exploring the Printer class and you can see it works.. change the CurrentX and currentY values to positon your text.

vbCNEW 0 Light Poster

just want to ask if somebody knows any related software about Course subject scheduler? this is my thesis.. my dean wants me to do it with AI.. i think its posible.....

the scheduler will generate class schedule to a college(Ex. COMSCI)
given its curriculum... i knowthat the scope is so large.. but ithink its still possible.

heres the example.. having the professors expertise, curriculum , and room data.. i need to generate schedules of the subjects..

AI goes in just to be sure that the schedule of the professor is logical or reasonable..

sorry if what i wrote here confuse me..
all i what is a little help.. even related literature abt it.. coz i search the web but a little help i get.

thanks..

vbCNEW 0 Light Poster

ofcourse..
now the array the hold their position is your cue..

changing the position.. will make it move..

vbCNEW 0 Light Poster

think of this..


if you are familiar with REFRESH RATE..

this is the clue... if you see any game with refresh rate, it means that the screen is refreshing all time time.. the fatser the better..

so how they do it..

like wat i explain to tyou then...

they paste everything one by one.. even there no changes happening..
see the idea..
explore more man.. i believe in you..

vbCNEW 0 Light Poster

its correct.. but i also give you some advise in that thread.. check it.. then tell me if you understnd

vbCNEW 0 Light Poster

i think u havent read my reply on your last post.. do check it out..

vbCNEW 0 Light Poster

hi... i really want to help.. but can u please next time use indention in your codes.. so its easy to read..


actually i think i know ur problem..

i encountered it when im still doing C games..

but its hard to explain the solution i did. i just hope u understood.

first.
wat i did is make a infiniteloop or the main loop, it calls the
paintBAckground
paintPLAYERS
PAintAccesories(laser,other moving pieces)
and otheres..

the key there is to have a array that hold the position of each unit, players, lasers so u can paint it anytime u want it..

i hope u undrstand..

regards to your game

vbCNEW 0 Light Poster

hey.. good afternoon..
i think you just need to read the textfile line per line then for you to get the line you want then use the SPLIT function in vb make the delimiter"|" so it will split the string into array of string..

i hope i help in any ways..

vbCNEW 0 Light Poster

what do u mean 'randomnly dying on the log'?

vbCNEW 0 Light Poster

i think it is easy to do in vb. the hardware your refferring , does it have a SDK or you create it ? i did machine then, i use bill acceptor..
i guess its the same prinsiple.. receeiving pulse or signal trhu serial or parallel port..
even the software its too easy.. so how do u want me to help you?

vbCNEW 0 Light Poster

Hey i really apreciate all your suggestions... i believe you all.. thanks!!!! ill try to do wat you all said.. again thanks

vbCNEW 0 Light Poster

ok.. thanks i appreciate the reply..

vbCNEW 0 Light Poster

hey good day to every one..
im just curious.. WHO needs vbgame developers?
heres my side.. first im a vb programmer.. i do game back then in vb6.. and its a real job.. but now as i seach for a new job, i cant find a job that needs vb game programmer. always C++, phyton, or java..
my next question is why is there a forum, books, reference that teach vb games if theres no job for these programmers after they learn it..???
sorry if i sound rude.. but believe me.. im just askin...
thanks for reading and hope to see some replies..

believe me im just curious... its a question!!!!

vbCNEW 0 Light Poster

hi.. first ithink its not right to put a loop insidde a counter because the timer is already like a loop thats why theres an interval declare for it to work .. i saw that you put 1000 in interval, so i guess u mean every minute it should trigger... so inside the timer just put sothing like this..

label1.caption = now - starttime

declare starttime as "public long" then give a value into it in form load or in the trigger of your timer if theres one..

i hope you get the idea..

vbCNEW 0 Light Poster

honestly i dont have time to think more abt ur problem coz im busy right now.. but seeing this condition , i think this wont work... try to look for a collition detection code in vbcode.com theres a lot there..

ill post the right code when i got mine.. hope it helps

go with your code ithink you can do it..

If FrogTop > Top And FrogLeft > Left And FrogBottom < Bottom And FrogRight < Right
vbCNEW 0 Light Poster

it is!!! if you need help you could email me...

vbCNEW 0 Light Poster

of course there is... by the way what code are you using in displaying the image... is it in a picture box? or directly drawn in the form...

my suggestion is use first a USERCONTROL...
create an image, make the background of the image MAGENTA!!!!
for masking issues.. save it to bmp for high resolution.
set the maskimage property to your image and mask color to the background of your image(ex MAgenta)..

if my explanation is not good.. try vbcode.com and look for a game that do ttransparency.. theres a lot there..

i hope it helps

vbCNEW 0 Light Poster

i think you should put doevents in the SHOOT codes... so you could exit anytime u want.. and about the clicking of shoot.. try to declace a global variable that will tell you the status of your game.. ex. if you click shoot the status is Shooting... so you can filter now the click event with that variable..
try the code..
if bstatus = shooting then exit sub

i hope i ve help you..

vbCNEW 0 Light Poster

ok.. i understand ur assignement.. but in what art are you stuck in?

which part u didnt understand.... and where is the code?

vbCNEW 0 Light Poster

can u please paste it to the thread... so everybody can view..

vbCNEW 0 Light Poster

by the way... thank you very much for your time..
one more concern if u may.....

im a vb game programmer... do you know how can i use my knowledge ? im using GDIPLUS!!!... i ve done a lot of games,, BINGO games, REEL games, and other casino games.... thanks again..

vbCNEW 0 Light Poster

sorry if im not that straight to anwer you last time..
i know what you mean.. but it gives an error!!!

something like adOpenForwardOnly, adLockReadOnly are not known... they dont have any values at all..
i know its a built-in const... but im using excel only.. i dont have vb studio here yet...

just like what i did..
Const adOpenStatic = 3
Const adLockOptimistic = 3

hope u understand it..

vbCNEW 0 Light Poster

could you help me please how to declare adLockReadOnly and adOpenForwardOnly?

i dont know the value....

vbCNEW 0 Light Poster

sir your right... i forgot to put it back because im debugging... i have it then!!!!

but the problen is my memory is going up inside the SearchNAMElink function

right aftrer this line...

objRecordset.Open "Select link FROM [NAMElinks$] where CODE = '" & stcode & "'", _
objConnection, adOpenStatic, adLockOptimistic, adCmdText

and when i put the
SET objrecordset = notrhing

before the function leaves, hthe next time the function was called... i need to create again the objrecordset....

same problem.... memory goes up...

which i think it shoudnt!!!! pls help again...

vbCNEW 0 Light Poster

Hi!!! could anyone please help me about querying in excel..

heres the scenario..

i have 2 sheets(sheet1,sheet2)

sheet1 = contain the correct answer
ex. col1 -- 3333 | col2 -- jose reyes
sheet 2 = contains only tha code... ex. col1 -- 3333 (shuffled)
(note.... record count is more than 5000)
now using the sheet1 as basis i need to know the corresponding NAME of the code in sheet 2...


actually i have a code... its working fine.. but i always run out of memory... pls help... its making me nuts...


heres the code::::


form___________
Private Sub CommandButton1_Click()
Dim st As String
Dim cnt As Long
cnt = 2
Set objConnection = CreateObject("ADODB.Connection")
Set objRecordset = CreateObject("ADODB.Recordset")
objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\NAME.xls;" & _
"Extended Properties=""Excel 8.0;HDR=Yes;"";"

Do
st = SearchNAMElink(ActiveSheet.Cells(cnt, 2).Value)
ActiveSheet.Cells(cnt, 4).Value = st
If ActiveSheet.Cells(cnt, 2).Value = "" And ActiveSheet.Cells(cnt + 1, 2).Value = "" Then
Exit Do
End If
Label1.Caption = "RECORDS :" & cnt - 1
cnt = cnt + 1
DoEvents
Loop While True

Set objConnection = Nothing


Unload Me

End Sub


inA MODULE___________
Public Function SearchNAMElink (stcode As String) As String
If stcode = "" Then Exit Function
objRecordset.Open "Select link FROM [NAMElinks$] where CODE = …

vbCNEW 0 Light Poster

Hi... im a vb programmer in the phils...

i do work in a gaming company doing LAN(server-client type) vb games!!!! and i can say that it is a successful one... but for some reason i leave that company... so now im working still vb programmer... but the thing is i would like to ask for a suggestion if anybody knows whats the best place where i can use my gaming knowledge.....

u can email me too.. thanks for the time..