Search results

Hi Everyone; I am developing a financial database in access program, I have one problem and hope you dears help me out; I want to add Audit Trail option, that when any user enter, edit or delete data from database form, it will be recorded, I have searched already but the I found some audit...

Thanks you very much, I used the buttons ctrl+home, it worked and solved my problem, but can I solve this issue in a better way than this way????

Hi everyone, I have made an accounting database, in journal entry form I have total of Debit and total of credit, I create button for new, next, first and last record also in build event i ordered that if text26 is not equal to zero (which is different between Dr. and Credit columns), don't go...

Dear Mihail: Thanks for your suggestion, I know what you mean, but the desinged database is another one, I have many queries, forms, reports, macros... when I wanted to save as the file to older version, it said impossible due to use of some options, that is why I remained the main tables for...

Dear Mihail: Attached is a older version. Best, Khalil

Dear Mihail: Thanks for your post, I have attached my db, hope my problem will be solved. Thanks again, Khalil

Dear all; I have an access database which has the following tables; tbl1) customer info tbl2) billing info (more than 5 years) tbl3) payment info (more than 5 years) In the first table I have info from all my customers, in the 2nd table information about billing amount and date and in the 3rd...

Hi kapil0712: If it will be 5 columns what would be the iif formula? And need to know the minimum value for these 5 columns Thanks in advance.

Dear friend Poppa Smurf: Thank u so much it works, very well. Khalil

Dear Poppa Smurf: Thanks for the post, I copy and paste the if function, but unfortunately it didn't work. Please if possible make it more clear. Khalil

Dear dbDamo: thanks for the code you provided, but what I want to do is different, I have a table like below: F1 F2 F3 F4 20 0 90 100 I want to find the minimum number except zero and maximum number as follow; Min Max...

Dear all; I have made a database for salary payments and I want to add the salary advance/loan to this database, so what i did is as follow; Table for staff ID Table for staff salaries Month Year .... For the salaries I don't have problem,but 1. I have a table for salaries which contain salary...