Search results

Please how can a user enter data into a form bound by query. Can you please direct me so I try it?

Yes. I just saw it but when I set to date, I don't know how to make it descending order

How do I make the user enter the data when my form is query base

Hi everyone, Please I have created Access form and set the default view to split. My problem is I want to set the arrangement of the data in my form to descending order by date (newest to oldest) so that I can see the latest entries first in the datasheet below. I have tried severally but...

Please I want P. Mode, Receipt #, Cheque #, Bank Name and Branch to be Inactive or Not Enabled when I select PLEDGE from the TranType. from the above form. I also want Cheque #, Bank Name and Branch to be Active or Enabled only when CHEQUE is select from the P. Mode list. from the same form...

It works. Thank you.

It works! Thank you.

No please but i want to show a field in the query on the membershipf form. the Record Source for the membershipF form is membership table. Kindly help me please

I only see available tables. I cannot see any query there. I want to see the query too to select field from.

I have created the query already as shown in the image. I want to show the "totalCommit" field in the membershipF form. I will be glad if you could direct me. Thank you.

Hi, I am designing a form in my access database, I want to add some of the fields from a query i have created to the form but don't know how to go about it. I need help. Can someone help me out? Thank you

Please attached is the zip file per your request. Thanks so much and hope to hearing from you soon.

Please can you help me structure my tables well so i can proceed with my project? I really need your help and support. I would not mind if i have to start from scratch please

Please can you help me structure my tables well so i can proceed with my project? I really help you help and support. I would not mind if i have to start from scratch please

Please attached is the field list of the fee table. 1. I want to a query to show sum up of all fees of each student 2. A query to show Initial fees due, payments made and balance due

Tha Thanks for swift response but please what is the way forward with regards to my initiate question?

Please is that how my fee table should look like as directed? Kindly look at it and advise me please

The total fee of a student consist tuition fee, STC Dues and penalty. Do you mean I should have a new column that will sum up all the fees components in the fees table?

Hi Sir, I have created the three tables as you directed and filled them with some records at attached. I have also created a query that give the total fee of each student. My challenge now is how to query a common query to sum up all fees owned by a student, all payments made by a student and...

Please below are my tables and their attributes: 1.Tbl.Student info Student id Name Telephone No. Dept 2.Tbl.Payment Payment id PaidDate Payment amount Payment Mode 3. Tbl.Fee FeeID Academic year Course fee SRC fee Penalty Total fee My challenge is how to link the above tables so I can track...