Search results

  1. Y

    Values change according to selecting value from another field

    Thank you my problem solved.
  2. Y

    Values change according to selecting value from another field

    Hello friends I am working on a school database, today I am working for fee collection form and I am facing trouble.In attachment At the top right area the hidden field I would like here changes according to selecting Fee Type under Fee Detail. I want to achieve this, If feetype is ABF then...
  3. Y

    After Date Change TransactionID Regenerate from 1

    Kindly help....
  4. Y

    After Date Change TransactionID Regenerate from 1

    This is what I am trying to accomplish I need to be able to create a serial number which automatically resets every day so I may use it to easily know how many records were created per day, without running a report.
  5. Y

    After Date Change TransactionID Regenerate from 1

    Now i have attached a sample,in this i have created a new field in tblTransaction sequenceNo and in a frmTransaction SequenceNo and i enter a before insert event in frmTransaction and when i type in GLCode Field a sequence number genrated working for me but i here want when date is change...
  6. Y

    After Date Change TransactionID Regenerate from 1

    I have attached sample Open frmGLEnquiry Form and Click On Search button the frmGLEnquirDetailQ form open , at this form i want a sequence no that every time when this form open start from 1,2,3,4, and continue so on. waiting...
  7. Y

    After Date Change TransactionID Regenerate from 1

    Mihail and Cj London , thanks for helping me , i am sorry that i am not explaining well that what i trying to do and what problem facing , i have a transdate field in my tblTransaction , i have queries qrytransaction and issue is that i have made a form frmtransactiondetail on the base of that...
  8. Y

    After Date Change TransactionID Regenerate from 1

    Thanks for answering. Dear Mihailmy idea is remembering transaction Ids is not to remember these numbers i want to make a transaction sequence numbers , like 1,2,3 and so on , i just want this for when i make a transaction i wont see back dated transaction ids in today,s transaction list, if i...
  9. Y

    After Date Change TransactionID Regenerate from 1

    Regards, I am working on a database, structure of database tblaccounts: glcode,description. tbltransaction: transaction ID, glcod, tranxtype, amount Everything is going well, when i make a transc ,transcid genrated i,e 1,2,3,to 47,48,49,50 and so on. In this case there are minimum 50...
  10. Y

    How control move on next field.

    Hi friends i have a form containing these fields trantype,Damount, Camount,Description and trantype look-up field containing transaction type debit or credit. Here in this form i want when i select debit transaction type then control move to the Damount and on pressing Enter key Camount skip and...
  11. Y

    Help for Save Button On a Form

    Yes i want a custom save button and now issue is resolved butt now i have this issue. when open form as enter new record and then you click on close button you will see the messages , put values in the fields, here i want that while pressing close button access close the form. Here is a sample...
  12. Y

    Help for Save Button On a Form

    Working but now i am facing another problem with my form where i have applied this code, i have coded my form as when i leave blank my form and click on close button then form is asking again and again to put values in required fields. Here is my form coding: Private Sub GLcode_AfterUpdate()...
  13. Y

    Help for Save Button On a Form

    thanks for help but my question is that is it possible to disable automatic saving in access?
  14. Y

    Help for Save Button On a Form

    Dear Mihail, thanks for replying , But basicaly i want to create a save button on the form that is used only for saving record to the table, for example i am entering a new student to my student table , if i enter student name and any other detail then suddenly i decided to close the form ...
  15. Y

    Help for Save Button On a Form

    Hi friends i am working on a database and i have notice after making a form that when i enter a record using a form if i enter incomplete data on the form access automaticaly save that record and generate a id for that record. For example i have a table that contain...
  16. Y

    How can make a msg box in a form where values are lookup from a table

    Thanks KYO. Solved my problem
  17. Y

    How can make a msg box in a form where values are lookup from a table

    Thanks for answering me. You don't understand that what i am trying to do. I don't want to change my "glcode" text box to combo box. my requirements in database is that user enter the glcode in text box instead of selecting from combo box. I want to making that when i enter any gl code...
  18. Y

    How can make a msg box in a form where values are lookup from a table

    Dear 4ndz i am working on a school database, in data base i have create two tables tblAccounts and tblTransaction and a form frmTransaction . tblAccounts contain two fields GLcodes Description and frmTransaction contain Glcode transaction type debit credit date narratives in form when i...
  19. Y

    I am a new user

    Helo I am new here.
View older results
Back
Top Bottom