Recent content by GuiGirl

Hi Tim, Thanks for responding to my question. Background. The DB is set up of clients names, addresses, phone numbers, date of birth and numerous command buttons to record various assistance given to a client. In order to assist a client, a worker needs to go to the client's home. The worker...

Question: Hyperlink to a Form Access 2003 DB. I created a hyperlink to a form on my database. The color of the hyperlink if blue which is great. However, I would like the hyperlink color to change to red when the user enters information to the form. This form provides information on worker...

A good tutorial is http://www.datapigtechnologies.com/AccessMain.htm Apply a filter to a report using a form entry. A great website.

pbaldy, Thanks for your advise. The command button and combo box on the form did the trick. Real slick. I will be using this again I am sure.

Thanks for the advice. I will give it a try and let you know. I appreciate your quick response.

I am using Access 2003. I have been searching through the many websites for tutorials. They have been useful. My question, I created a report using query builder and it works well. However, since I gave the query a parameter, the report wants to know What Care Option? As the creator I know...

Hello all, I found my solution. I appreciate all that have responded to me. I am a visual learner and found an example at www.rogersaccesslibrary.com on M:M relationships. I have some tweaking to do on my DB . Many thanks to BobLarson for recommending this great website to novice Access...

I am not sure what I am doing wrong. I have two tables that are a manay to many relationship. tblCareOptions and tblFacilities. I reviewed some of the wonderful threads in the tables forum. I visited Microsoft Access Help for relationships and forms. I've visited some of the Access tutorials...

Thanks for replying. No error message. I want to keep the information on the main form in tact so I used Snapshot on RecordSet. I also have a subform on the main form that holds information for each record in the main form.To find the record to update I use a Record Find command which is part...

I figured it out. I was tring to move my subform onto the Page instead of adding it thru the subform control. I knew it couldn't be that difficult. Thanks for your advise.

How do I create a tabbed control with 3 pages each page a different subform. I dragged a subform from the main form onto the first tabbed page and the subform shows on the following 2 tabs. The result I am looking for is each page has a separate subform. Thanks for any advise Guigirl