Search results

it works for me as i want. Thank you very much for your support. GOD BLESS YOU.

attached the sample file

can't understand?

Dear arnelgp, Can you please help me. Dim db As DAO.Database Dim rst As DAO.Recordset Set db = CurrentDb() Set rst = db.OpenRecordset("tbl_Voucher", dbOpenDynaset) rst.FindLast "Voucher_No =" & Voucher_No rst.Edit...

thanks for the help. this is the solution that i want. thanks dear. you are the boss.

yes i meant unbound textboxes on unbound form , and i just want to find if there are any macthing voucher no in Voucher_no2,Voucher_no3,Voucher_no4,Voucher_no5 textboxes. just prompt through msgbox while pressing command button.

Thanks for your response, In the table tbl_Voucher field is Voucher_No only. and the Voucher_no,Voucher_no2,Voucher_no3,Voucher_no4,Voucher_no5 etc... fields are on the unbound form. this form not related to any record source. i just want to compare values on the form fields...

Hi everyone, I am running my own school and working on the school database for in which monthly fee vouchers generated, after depositing the fee in the bank by parents/students , bank dispatched the vouchers and scroll to me. After that i have to post that vouchers entry to my database for...

I understand that what are you trying to do, and i have done this before six months, using sub forms in ms access is very cheep and not professionally looking forms, i have made a unbound form to enter the transactions and post that values to multipurpose entries table by using append queries, i...

sorry for incomplete help.now check this. Private intLoginAttempts As Integer intLoginAttempts = intLoginAttempts + 1 If intLoginAttempts > 3 Then DoCmd.Quit MsgBox "You do not have access to this database. Please contact your system administrator.", vbCritical...

post a copy of db.

Try this code on your login button. intLoginAttempts = intLoginAttempts + 1 If intLoginAttempts > 3 Then DoCmd.Quit MsgBox "You do not have access to this database. Please contact your system administrator.", vbCritical, "Restricted Access!" End If

Dear Mazhar, For doing this i have used a pakistani (Desi) method to built this, there is no programming required but you must have much knowledge of building queries. first i make a table General_Ledger, containing fields, id, GL_Code,Opening_Balance, Dr_Amt, Cr_Amt, TDate and set default...

Thank you very much , for your kind help. thanks alot. :)

Hi, i am working on accounting database in access2007, i have created a continuesly form (LOV_GL30) based on a query (LOV_GL30), the purpose of this form to provide value for a field on another form (GL30), basicaly i am using this form (LOV_GL30) as a custom LOV (list of values) for form...

thanks for reply, I want a custom counter in a table where records are entered through append query from another table. I have these two tables tblGeneral_Ledger_Transaction and tbl_Fee_Transaction , both table hold all the transaction and i have another table tbl_Journal and in journal table...

Hi friends, i have a question that how can i make a custom counter in a table where records are appended from another table. i have already used custom counter method in my database before by using this technique. http://www.599cd.com/tips/access/incrementing-your-own-counter/ but i want to...

Thanks ARI I want to write in msgbox like this Example: "Submited at 10:40pm" msgbox "Submited At" Now() what does the syntax ? please help, thanks

Dear MarkK thanks for having look on my thread, for you information I have a good structured database where tables are not holding raw data. Everything is on its own place. I don’t have to need to process data before presentation. But if you have any ideas about my question then help me for...

Helo all How can i display current time and date on msgbox. in ms access 2007. Regards.