I am a new and inexperienced programmer in access and created new database(RegLetter-Inward) and am having a few problems as detailed under:
1. While opening the form, I want to search for the existing sender based on the sender's name and PIN or Sender ID from the Sender Table and if (found), then the form should automatically append the values in the corresponding fields in a new record.
2. I have a field "Sender's Name" and the value is usually selected from the Sender table. But I want that if a name is not available in the sender's table, the Data Entry Operator can type and add the same. Pl. advise how to do it.
3. I have a combo-box with drop-down list to select with check boxes. The options are CASH, CHEQUE, DD, LETTER, PRAYER. One can also select multiple options like CASH and DD, CHEQUE and DD, DD and LETTER etc. I want that if DD is not selected then the DD_NO, DD_DATE, DD_AMT fields should be disabled. Similarly if only CASH is selected, then CHEQUE_NO, CHEQUE_DATE, CHEQUE_AMT and also DD_NO, DD_DATE, DD_AMT fields should be disabled. Pl. advise how to do it.
4. While creating a report , I find that the number of fields are more for a single record, and cannot be accommodated in a single sheet of A4 size paper(Landscape). So what is to be done so that all the fields can be incorporated in the report for a single record on the same page? I don't mind if all the fields for the single record are displayed in two/three lines on the same page.
5. I am enclosing the database for modifications as above. Kindly modify and send back and let me know the steps that you followed to do the same.
hksahoo
1. While opening the form, I want to search for the existing sender based on the sender's name and PIN or Sender ID from the Sender Table and if (found), then the form should automatically append the values in the corresponding fields in a new record.
2. I have a field "Sender's Name" and the value is usually selected from the Sender table. But I want that if a name is not available in the sender's table, the Data Entry Operator can type and add the same. Pl. advise how to do it.
3. I have a combo-box with drop-down list to select with check boxes. The options are CASH, CHEQUE, DD, LETTER, PRAYER. One can also select multiple options like CASH and DD, CHEQUE and DD, DD and LETTER etc. I want that if DD is not selected then the DD_NO, DD_DATE, DD_AMT fields should be disabled. Similarly if only CASH is selected, then CHEQUE_NO, CHEQUE_DATE, CHEQUE_AMT and also DD_NO, DD_DATE, DD_AMT fields should be disabled. Pl. advise how to do it.
4. While creating a report , I find that the number of fields are more for a single record, and cannot be accommodated in a single sheet of A4 size paper(Landscape). So what is to be done so that all the fields can be incorporated in the report for a single record on the same page? I don't mind if all the fields for the single record are displayed in two/three lines on the same page.
5. I am enclosing the database for modifications as above. Kindly modify and send back and let me know the steps that you followed to do the same.
hksahoo
