Search results for query: *

well i still havent solved this problem....... are there any other ways this can be done? heres a summary of what needs to be done the [total value of claims] which is in the 'claims' table and is a 'number' field needs to be added to the [total claim value] which is entered in the particular...

hehe.....ok i have no idea what MCSD stands for......is this an undergraduate thing or post? i'm thinking of doing computer engineering at college next year...but the amount of programming involved is making me have second thoughts......neways......help me!!!!!!!im in real deep trouble......i...

anybody out there??????help!!!! thank you, SaDeS

hehe.......cool but now uve put me!s everywhere...some of the data used in this thing arent actually used in this form so the program has to get it off the tables and tehn use it..... the only thing that is on this form is 'reimbursement value'. the 'total value of reimbursements' and...

i still havent managed to solve this...... the report is a letter which uses values from the tables here and there. When i click on the report it askes me for the name and address of the person. the name and address i enter doesnt even exist on the system and the letter just shows the data from...

yep theyre all text boxes...do they have to be currency?because ive just specified 'number' is this the problem?? sades

i still keep getting the same error!!!!!! Private Sub saveclaim4_click() subs![total value of claims] = subs![total value of claims] + claims![total claim value] iif(sum(subs![total value of reimbursements] + claims![reimbursement value]) > subs![reimbursement limit],subs!status =...

hey, thanks a lot for all the trouble you're going thru......u people r real angels!!!!!!! i'll check it out and report back SaDeS

hi...this is exactly what i wrote- Iif ((subs![total value of reimbursements] + claims![reimbursement value]) > subs![reimbursement limit],subs!status= "reimbursed","rejected") it wasnt as direct as the version i was given by you ppl... i need to add 'total value of...

hey, i know this is probably going to be the dumbest question u people have ever heard...but neways...... my reports dont work properly. i dont think ive made them correctly(im pretty sure).......when i click on the thing i keeps asking me for all the field values that should go in the...

hi......i tried making this work today but i get a syntax error message........ iif(total claims < sub.limit ,me!status = &quot;Reimbursed&quot;,&quot;rejected&quot;) it points at the '=' and says &quot;expected: =&quot; what do i do?????

uhm, not really.......i started thar thread before this one and then i realised that i could check it for all the fields...... neways, about my last question, how do i take any action after checking if it exists?i cant use a THEN statement can i? and since i havent figured this out i keep...

uhm i kind of get this now littlesmudge.....what this does is checks if the record already exists in the table right? how do i add the code to carry out the action if it already does?...for example to run a macro &quot;alreadyexists&quot;? im not familiar with these rst. statements and...

thanks a lot bry:-)

tnx for the help!

tnx a lot for the help ppl!

hey im still having trouble figuring out the code to see if the fileds entered exists...please gimme some sample code someone!!

hi, i got this off another thread somebody had put up and i want to do something similar.....i want to see if what the user enters already exists and tehn show an error message if it does... well i dont really understand how this works.....can you explain what rst.Open &quot;SELECT...

hi, in my database ive got a susbcription limit for each subscriber and every claim the subscriber makes is added onto a total claims field. if the total claims<sub. limit i want to make the 'status' field show 'reimbursed' for the particular claim. and if total claims>sub limit i want it to...

hey, tnx a lot....... this site is proving to be very helpful!!!!!! SaDeS