In another way
make sure the number of days between the current date and the date of his last visit
if less than for example 20 aren't allowed to add data and alert message appears if more, allow it.
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
This is my requirements:
ComboBox= 01 or 02 or 03 or 04 or 05
if ComboBox= [highlight #FCE94F]01[/highlight] and MyDate = [highlight #FCE94F]4/6/2015[/highlight]
MyTable
PK Castumer_Number Seq_Number
1 1 01-001
2 2 01-002
3 3...
I need to automatically generate a 5-character value for my Business Key. Without any user interaction.
2 character -> from 01,02,03,04 to 05
+
3 character -> Sequential Number (001,002,003).
The Sequential Number must reset on each new day.
thanks
1-I want to count the number of people entered without dupication in one day. Just are the date, not the exact time. Each person has a unique Badge number.
2-After that, I have another worksheet with all the empoyees` Badge number. I want to compare the peoople entered with this sheet to...
I want to work Using vba so that the number of customers at the beginning of every day, will be reset to zero when the registration number and the first client data and give him the number 1 second and the client gives the No. 2 to last client
I need a new counter on my Customer form for each day, using an Autonumber and print it.
thankshttp://files.engineering.com/getfile.aspx?folder=32a88268-4681-47ad-8cad-7f346143dc0e&file=ExchangeDb_.mdb
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.