Recent content by friendly

I think it would be better to have the text box (3) Where the value entered in each category separately Value entered is then tested by (function) according to the criteria listed Thanks

I am a student and do not speak English fluently therefore apologize to everyone. In fact I started work program using Microsoft Access) but with regret stopped at this point. Therefore requested the all help me, I will try to clarify what I want to do with how possible. The idea of the...

I mean denomination For each category. Thanks

Hi, I'm going to create a program that contains: give customers money in denominations of 1 and 5 conditions: minimum of class (1) = 100 and maximum (1000), you must give money minimum complications (such as 100 or 200 or 300... To 1000). well minimum class (5) = 500 upper limit (5000), you...

Thank you for your feedback and I've got a good idea about (PK * FK) but my idea is that all visits are saved in the table (tblVisits) while retaining the last visited in the table (tblClients). so all I want is last date with history compare current table (tblClients), not counting over 20...

Super Moderator CJ_London thank you my sincere thanks and appreciation for your help.

This is My Database:

Is it possible to apply to these way: table = tblClients Date Field = LastVisitGDate txtboxID = txtClientID if dcount("*","tblClients","clientID=" & me.txtclientID & " AND LastVisitGDate>Date()-20")=0 then 'not visited within 20 days else 'visited within 20 days end if

I've tried using function (dcount) unfortunately didn't work out the way with me I hope help me apply it. thank you

Dear can you help me apply the function (DateDiff) described as: table = tblClients Date Field = LastVisitGDate txtboxID = txtClientID thank you

Extend to all sincere thanks and appreciation

Using VBA wanted to make sure the client's last visit date to the Bank and not allow him to exchange within a specified time period, for example, 20 days I know it's annoying you but thank you

I extend my sincere thanks and appreciation to help me

Any idea please

I can have gaps thanks for your help