Search results

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

JHB, I did find a solution to what was troubling me. Thanks for your time and help. Maurice.

JHB, I did find a solution to what was troubling me. Thanks for your time and help. Maurice.

Here are some other reports on top of the ones I had mentioned. I hope this helps to clarify the problem. Thanks. Maurice

Here is the other bit. Thanks. Maurice

Oh, Sorry about that. I didn't know that the forum doesn't take .rar uploads. I have split it in two because after zipping, it was over 2MB. Thanks for the help. Maurice

Hello, Sorry, I was travelling in some remote part of the country with no internet connection. I have attached the database here, as you asked. For the reports, I have included two that work, and two that don't. Hope this helps in solving the problem I am facing. Thanks. Maurice

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

jzwp22 It works, and this is EXACTLY the solution I was looking for. Much, much appreciated. Thanks. Maurice.

jzwp22 It works, and this is EXACTLY the solution I was looking for. Much, much appreciated. Thanks. Maurice.

jzwp22 Thank you very much for your help. I have just downloaded it, so after implementing, I will let you know. I hope that someday, I will also have acquired the necessary skills and experience to help other users. Thanks. Maurice

Catalina, Thank you very much for the information. Sorry, I would have responded earlier, my internet connection is unstable. I had looked into conditional formatting before, and maybe I didn't look in the right place, but I didn't find something that suits what I was looking for. What I...

Catalina, Thank you very much for the information. Sorry, I would have responded earlier, my internet connection is unstable. I had looked into conditional formatting before, and maybe I didn't look in the right place, but I didn't find something that suits what I was looking for. What I...

jzwp22 Thanks for your response. Sorry my connection to the internet is not 24x7, I would have responded sooner. Did you take a look at the database I attached? A search form (with a continuous subform) is already there, and on it, there is an an option for entering the age (Combined with...

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.