Search results

arnelgp, Thanks for the clarification and sorry for the late response. Been out of the office since. Yes, it worked. Much appreciated. Maurice.

Arnelgp, Thanks for your response. Sorry I lost power in the office, so I could not respond. I have gone through the code and I am seeing that it returns only one name, regardless of the data that I choose from the listbox. I cannot figure out where the problem is. Again, thanks for your...

For some reason, I thought I had attached the sample database, but I cannot see it in my previous posts. Sorry. Here it is. Thanks. Maurice

Ranman256, Thank you for your quick response. Yes, the code you have provided me works if I were to filter one field (say swimming) and the result would only depend on the data in the Swim field. However, the code I need is one that would filter the data based on whatever the user selects...

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...

Namliam, Thank you very much for your continued response. Let me work on your suggestion about re-working the query (though I have tried it before, but I may have missed something) then will let you know. Yes, The reason I wish for the "filtering" to be based on the ID from the query is...

Mihail, Thanks for your response. I wish to do this to the underlying query because from the active record, I would wish to print some other reports too, based on data retrieved from the query. The user's interaction with the data on the continuous form should just be so that only one...

Hello. Just an idea: Could there be a way of, say, at an "On Click" event, the ID in the active box is posited to the query, then the query runs, in turn displaying only one record in the continuous form? I would however, need to have another event that would run so as to clear the ID...

Namliam and David R, Thank you very much for your useful replies. However, I seem to be having a problem implementing your suggestions. The filtering option would only apply to the form, and not the query which contains the data behind the form. I wish to filter the data, yes, but based on...

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...

Sorry, been up and about. Galaxiom, Missinglinq and CjLondon; a BIG Thank You for your helpful replies. With much appreciation, Maurice.

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...

Sorry about that, will be much more vigilant about the category next time. I wasn't sure whether to ask it under the Queries group of VBA category, so I chose both. Thanks. Maurice

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...

Jkl0, Thank you very much for your reply, it was REALLY helpful.

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.

Mihail, Thank you so very much for your help. It has indeed been helpful and you are a life-saver. Now, I have gone through it and included some real data on my part. I am so very new to access so I know I still have a long way to go before I completely comprehend it all so thanks for...

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...