Search results

thnx Spacepro for your time I realy appreciate your kindness. Let me explain the best I can. Here is the situation I have two tables "tenant and payment" for instance a tenant pays the rent and I input the amount he/she paid what I want is a query to show me all the tenants who did not pay the...

Hi ! I was wondering if someone could help me on tenant maintenance DB.My problem is i need something to control the rent payment for ex: if the tenant pays the rent to take off his/her name from the due rent list until the next month. I know it is something to do with query but I need an...

HI....... Thank you a million IMO "for your time" it worked perfect with lostFocus. You are helpful and i realy appreciated greatly.That is why this forum is the best, if i don't get the answers I want here i just don't bother anywhere else. thank you again IMO and everybody who gave me there...

Hi....! everything is good so far it worked "the if statement" but there is one minor problem. whenever i put the startdate & endDate it deosn't give me the total days immediately I had to press the next button and come back that time will give me the correct days . It needs some kind of...

SOrry guys I just came from work did not get chance to see your reply my appol...... I want thank all of you for giving me your time. I will try the if statement by IMO and let you know. Answering ColinEssex's question customer can come after midnight say (Jun 30th after midnight it is already...

First of all I just want tell you this forum is like my home can't go to bed without checking what is going on every night.You guys are like family to me or big brother .......!:p. This is my problem I have Hotel db everything is good except when I want to calculate Totaldays =(Lastday-...

Hi!! I just want thank you "BOTH" jfgambit and indesisiv for giving me your time. The sample just worked fine.You saved me lots of time. thank you guys I realy appreciated....

Hi . I have a search form where users put phone number to search, what i want is if the phone number they are looking for is not there a message box that says "there is no such number". Please if anyone... Thanx.

Thank you first for relying dcx693 ... All i need is if the query did not find the phone number a message box that displayes "no such number". The query is working perfect i mean the SQL is working OK all i needed is if the number is not there a message box that tells them no such number...

Hi . I have a search form where users put phone number to search, what i want is if the phone number they are looking for is not there a message box that says "there is no such number". Please if anyone can help on this will greatly appreciated.. thanx. :confused:

RICH I DON'T KNOW WHAT TO SAY THANK YOU . YOU ARE A GREAT GUY. I CANNOT PUT IN WORDS HOW I APPRECIATED YOUR HELP. YOU ARE THE REAL GURU...... THANK YOU I DON'T KNOW HOW I CAN REPAY YOU BACK...

Hi everybody..... i'm trying to print only 1/2 page of a report and i don't want to use whole paper is that possible ? "guess trying to save the environment". Any help would be appreciated. thanx.........

After I renamed it worked abssolutelly perffect thank you A million Rich you are the man reaaaaaallly happy. And you made my whoole year "not my day". Thank you,Thank you, Thank you "RICH"

I'm deeply sorry that i posted the same one twice..... and thanx Rich but it is giving me an error whenever i put "=" sign infront of it like =sum(Iif([Date]=date()),[amount],0) it is saying the expression you entered has a function containing the wrong number of arguments thanx again Rich....

HI. I'M TRYING TO CALCULATE SUBFORM. THE TOTAL OF THE SAME DATE LET SAY TODAY'S DATE IS (APR 20 03) APR 19 03 $400 APR 20 03 $100 APR 20 03 $200 I WANT THE TOTAL TO GIVE ME $ 300 NOT ...$700 My project is stopped becuase of this problem could not do it anymore....Pleaaaaaaaaaaaaaaaaaaaase...

thanx Rich for your help but where am i going to put the expression :confused: thanx again....

HI. I'M TRYING TO CALCULATE SUBFORM. THE TOTAL OF THE SAME DATE LET SAY TODAY'S DATE IS (APR 20 03) APR 19 03 $400 APR 20 03 $100 APR 20 03 $200 I WANT THE TOTAL TO GIVE ME $ 300 NOT $700:confused: THANX I REALLY NEED IT SO BAD...