Search results

Hello, I have a sample database (attached) where I have a form called frmVoteHeadsOne. The voteheads that I have are swimming (Swim) and transport (Trans), which both appear for data in a table. On the form, from the combo list, I would wish that if I select swimming, for example, only Mark...

Hello all, I have a form on to which a sub-form is attached. I wish to have an event such that, on the user clicking the Admission Number or ID (In Blue), only the record clicked upon remains on the form. However, ideally, I would be interested in a solution that posits the Admission...

Hello all, I wish to get some assistance on having only one record display in a continuous form, after an "On Click" event. The database in which this question lies is attached. On opening, the user first interacts with Table 1 (Continuous Form), then by clicking on ID on the details for...

Hello all, I am seeking help regarding locking entry of data in a form. Attached is the database in which my question lies. The user first interacts with Table 1, which then leads to the opening of the Personal form (as per the user's wishes). What I would like to do is: 1: To give the...

Hello, I have an access 07 database (attached) with a sample table with the following fields: 1. PreviousTermBalance 2. CurrentTermDue 3. TotalPaid 4. TotalBalance. How do I ensure that, when a payment is made, the PreviousTermBalance is knocked off first to 0 (for a case where the...

Hello, I have an access 07 database (attached) with a sample table with the following fields: 1. PreviousTermBalance 2. CurrentTermDue 3. TotalPaid 4. TotalBalance. How do I ensure that, when a payment is made, the PreviousTermBalance is knocked off first to 0 (for a case where the balance...

Hello, A while back, I got a cheque printing utility (written in VB) somewhere on this wonderful forum but I never used it. Now that I wish to use it, I can't seem to locate it. Does someone know where it is located? Thanks.

Hello all. I have created an access 07 database and split it to a back-end and a front-end with linked tables. I wish to deploy it an a network of 4 computers, 3 of which are running on XP. The back-end will be on a computer running on XP. Now, from the instructions I have come across...

Hello all, Glad to be back. Now, I am creating a database that has a transport aspect to it. Basically, I have a table with the list of buses, and tables for routes plied by each of the buses. What I would like to do is that on a datasheet form, I would wish that if at the point of...

I have been trying to put together a report to give me a statement for payments. It is based on a query. The table is fine, the query executes fine with the data I want, the report (on design view), recognizes the source of the data in each of the fields, BUT when it comes to loading it, it...

Hello. I am having some trouble trying to color select a record based on when a particular field has any data. Basically, I have a continuous form (datasheet) which has fields such as FirstName, LastName, and the like. One of those fields is Notes. What I wish to happen is that if there is...

Hello. Somewhere in this forum, I came across the Query by Form Access 2000 database, and I wish to use some elements of it for a different purpose. The only challenge I am facing is on the query. Using the same method employed in the age and operator combo boxes (IIf......), How would I do...

I am a new member of the forum, and this is my first post. I am from Kenya, living in Nairobi and not entirely comfortable with the workings of Access especially after 2007. I hope my participation in the forum will help me and others like me get a better feel of Access. Thanks.