Search results

Thanks all for your suggestions. I will try both methods. Gary, I agree with you when you say the db doesn't sound quite right. I am fortunate enough to have a consultant in the office who is working on creating a db for another program. I have talked to her and she will be willing to...

I am using Access 2003. My database tracks how many energy discount applications are sent out to clients. Our clients are low income frail seniors and disabled adults. My staff either mailes the applications to clients or in some cases staff will make a home visit to assist the client in...

I appreiciate your advise. I will do some modifications and see what happens. Thanks

I am sending a copy of my relationships. I do have a one-to-many relationship. I know I will figure it out at some point. Thanks

Great thanks. I do maintenance on the database. I really appreciate your help. I'll let you know

Thanks for responding. Sorry you are correct -- my error the command button is on the frmClientMain and yes to your question

Thanks already tried that....didn't work. I will keep plugging away at it. Thank you for your quick response.

Access 2003 I created forms frmEARP & frmAppProcess frmEAPR (parent) pulls 3 fields from tblClientMain fields: ClientID, LastName, FirstName frmAppProcess (child) has 4 fields from tblAppProcess fields: AppID, Date, AppProcess(dropdown), ClientID frmAppProcess is a subform of frmEAPR...

Thanks much for your quick reply. I will let you know how it works for me. Again thanks:)

I am using Access 2003. I am having trouble searching the internet for help on creating a backup and exit macro. Can someone help me? Thanks

Thanks much for your answer. Yeah, the db was a quick attempt to show what I was trying to do. The actual db is large and is normalized. I will take your advise and get to work. Thanks again for your very quick response.

Welcome all who would like to be my friend. I also have some great jokes.

Please let me know if the text is readable. I changed the font.

Hello Access gurus I have attempted to look through the internet and this forum for help with my question. Although I have found part of my answer, am still puzzled. :confused: I have created a “Worker At Risk” hyperlink on my main “Client” form that takes me directly to a subform entitled...

Thanks David, I like this approach. This should work well Gui Girl aka Orson9750

Thanks however I need big training wheels when it comes to code. Exactly how do I get this bit of code into my event procedure to make it work?:o

PBaldy.... With your great advice and patience I finally got the Multi-Select List Box to work with the OpenReport cmdbutton. There still is a problem with the List Box. The List Box displays the Care Options numerous times. Earlier in my DB development, I created a Main Form with the Facility...

PBaldy, I am unable to send my file due to security token missing. I will see what I can do to get permission:eek::(

CareOptionsID is an autonumber and my primary key for my tblCareOptions. I will attempt to send my DB. It's large so I will have to cut it down.

Thanks for responding and your help. Yes I did make the change. Now I get this messae: Data Type Mismatch in criteria expression. Copy of my event Option Compare Database Option Explicit Private Sub cmdOpenReport_Click() On Error GoTo Err_cmdOpenReport_Click Dim strWhere As...