Search results

Thanks for everyone's suggestions. I have known how to solve my problem.

Thanks for your reply! I need tax rate could change. But I don't know how to do. Can you tell me which function I can use? Or does any example let me refer to?

I tried to set formula as default value. I hope the taxes value can be changed according to two fields in the same table. But it not works as expected. Could any one help me? Below is my access file. Thanks for your suggestions.

Thank you! Arnelgp, you are my hero!!

I meet problem soon... The taxes value would not change according to quantity and unit price in the second record. Do I use the wrong method? Below is my test file. Could you tell me how to edit it??

Thanks for your reply! I finally success!!!

Both of SerialDate and SerialNumber are in my database. But, the last three number of SerialNumber should start from 001 every month. How can I edit it?

I hope the result of calculation could be changed manually. Can DLookup() expression do this? If it could, can you tell me how to use DLookup() to achieve my purpose?

Generally, taxes are 5% in invoice and 0 in other duty-free receipt. But, 5% could be changed incidentally in invoice. This is unpredictable. In my table, there are receipt field(invoice or duty-free receipt), quantity field, unit price field and taxes field. I hope the taxes field could be...

I just tried this code. But the last 3 number keep 001 in the same day. ex: 1100903001, 1100903001 I hope the last 3 number is serial number. ex: 1100801001 1100801002 1100802003 1100803004 . . . 1100901001 1100901002

There are SerialDate field and SerialNumber field in Table1. I have corrected my access file below.

Hello I'm trying to make a accounting system by access. There would be quantity, unit price and taxes. Generally, taxes is calculated by quantity * unit price * 5%. I set formula for automatic calculation. Somtimes, taxes is not 5% of price, but the value of taxes cannot be changed. How can I...

Sorry...I forgot to change my code to Eng. Unfortunately, the rule of this serial number is set several years ago. So I am bound to use the advice in #2. Here is the code I used. Private Sub SerialDate_AfterUpdate() 1001 Z = DMax("SerialNumber", "Table1") 1002 If IsNull(Z) = False Then 1003...

Hello I want to make floating numbers, composed by date and serial number. I have succeed to make floating numbers, which serial numbers are reset every day. Actually, the serial numbers need to be reset every month. How can I revise the code in this access?