Search results

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

they just present to allow you to specify a line when discussing data with others the are sequence numbers supposed to be permanent thanks

I would like to make VBA to get Sequence Numbers like example

There are occasions, especially with survey data, when you need to create an enumeration (also called a counting or identification) variable that starts at one for each group in your data. For example:(Attach Files) Thanks for your help

I look forward to learning new things about MS Access from this great Help Center Regards Khalid