Search results

  1. arifmasum

    Import Text from Text file...

    Thank you guys for coming up and help me grow my knowledge. By the way, I am able and completed that part. Now I am stack at leave management system. Can anybody guide me, how I can do it in MS Access? Thanks in advance for your time and efforts. Masum
  2. arifmasum

    Import Text from Text file...

    Thanks a lot mike. It helped me to work with the imported table. Now I need to allocate leave for employees. Can you advice me the method, i should use to allocate leave to employees? Pls note that, the file you attached is the attendance file for the employees. Thanks in advance for your time...
  3. arifmasum

    Import Text from Text file...

    Here is the text file Dear MStef, Thank you very much for your reply. I am attaching a text file with this reply. Please note that first 3 digits represent machince ID which reads the card number, next 8 digit represents date (year, month, day) and next 6 digits represents time (hour, min...
  4. arifmasum

    Import Text from Text file...

    Dear members, Please help me. I am working with a HR database. I need to load the attendance data from employees from text file. Note that, employees attendance data is recorded through a card reader machine and it stays in text file format. I need to import that text file to my access table...
  5. arifmasum

    Human Resources Database

    Thanks dear. Your comments are appriciated. Yes, I am doing the ground work of this project & I know I will be able to give a state of the art HR application. I will post if I get stuck anywhere. Thanks again for the endless support I am getting and got previously from this forum. All the best...
  6. arifmasum

    Human Resources Database

    Thanks a lot dear Adam. Actually I am from Bangladesh, A south Asian developing country. I just joined a company to develop their human resource database and administration. I am on a way to design employee information and attendance calculation first. So, can you give me any advice? BTW, as I...
  7. arifmasum

    Human Resources Database

    Dear All, I am on a way to develop a database for human resource division for a company. May I expect some guidelines and advices from experienced members of this forum? Does anybody can provide me any example of template? Thanks in advance. Arif Masum :confused:
  8. arifmasum

    Get value for text box depending on other text box !!

    This is the code Private Sub Account_Head_Click() [Forms]![CreditEntry]![Text20] = [Forms]![CreditEntry]![CTrans]![Account Head] End Sub I used this code to pass Account head code to the mainform. I used this code on the code section of the subform. Thanks n best regards Arif Masum
  9. arifmasum

    Get value for text box depending on other text box !!

    Here is the picture Here is the picture. See the textbox below VDate contains value 27 is the Account Head code (it is hidden). There are several sub codes under this code. I am using this text box in query to get the value for the sub code in the sub form. I am able to get the sub code value...
  10. arifmasum

    calculate sub-form field values in main form

    Hi Allan, Nobody responded to my question man!! I am realy stuck here!! Waiting for someones help.
  11. arifmasum

    Get value for text box depending on other text box !!

    Thanks for reading my post. My problem goes as folloing: I have several sub_code under Account_code. In my subform i have two combo boxes. 1 is account head another is sub head. There are several sub heads under 1 account head. I need to get those sub head depending on the account head. My...
  12. arifmasum

    calculate sub-form field values in main form

    I found a bug again. I have several sub_code under Account_code. In my datasheet subform I want to get sub_code list depending on the combo box account_code for each record. In my form I get the subcode for the first combo box value only. What can be my problem? Thanks in advance. Arif Masum
  13. arifmasum

    calculate sub-form field values in main form

    It's Done !!! I've solve my problem myself... Thanks for your help ...:)
  14. arifmasum

    calculate sub-form field values in main form

    Thanks one last issue !! Thanks a lot dear.. You answer so easily and I can catch also easily from your answer. Great man!! One last question: I need to get balance amount (Total Deposit [Credit] - Total Withdraw[Debit]) and show it in each days cash book report(Daily Transaction). How can I...
  15. arifmasum

    calculate sub-form field values in main form

    Thanks. In journal voucher I need to check the debit and credit value is same before save. Using command button how can I do that? Please give me some advice. Thanks in advance for your time and reply. Arif
  16. arifmasum

    calculate sub-form field values in main form

    Command button code.. I am using command button to print and preview reports and print reports. I wonder where should I put the WhereCondition argument? This forum and members I appritiate too much... Thanks Arif
  17. arifmasum

    calculate sub-form field values in main form

    Button issue.... Thanks. Till now I am not using any command button. But I wish to use command button to open this form. What should be the code then? Please give me some idea. Thanks for your valuable time and reply.. Arif
  18. arifmasum

    calculate sub-form field values in main form

    Thanks.. one more point.. Thans a lot. It helped me understand more. I have another porblem. I have credit table with two kinds of Voucher "C=Credit" & "CS=Credit Sales". I need to open and enter data in two different forms "Credit Entry" & "Credit Sales Entry". How I can apply filter, open...
  19. arifmasum

    calculate sub-form field values in main form

    Thanks.... Thanks. I've done it... Pls describe what does SubFormControl means? Thanks in advance....
  20. arifmasum

    calculate sub-form field values in main form

    Calculate on main form. Thanks a lot. I got the value in Sub form. How should I calculate sum on main form and check if both values are same? Thanks again coz you lifted up from stuck point.
Back
Top Bottom