Search results for query: *

Paul, I'm sorry, I have been away from my computer for several days. Your second post was helpful, but I also don't know how to refer to the data or 'recordset' in the subform. Have you managed to make anymore progress on it? Can anyone else help with this problem? It seems like it would...

Any ideas? Opinions? Silvia

Hello there, I have created a DB to track staff that have been trained to use applications at my organization. I use the DB to collect the person's name, professional group and the date that they attended training of a specific application/module. So long as the date is blank, it is assumed...

I wasn't sure how to insert the Me.Dirty statement... I did however clean up my code quite a bit and got rid of prodecures that I didn't need. The good news is that the Date Range search works now!!!! :-) :-) :-) I think the problem was that a lot of people have already been trained, but we...

Hi guys, I'm sorry, I am still having another problem. I changed the code for date comparision as you told me to above. My code for that section is now If strField <> "" Then If IsDate(Me!txtStartDate) Then If IsDate(Me!txtEndDate) Then strSQLQuery = strSQLQuery & " AND...

That worked exactly right! Thank you PHV. I'm sorry, I have one more question... I promise this is it (I hope). The date range search works for the most part. The problem is hard to explain because often it shows dates outside of the range. As I did some more testing, it became even more...

Sorry, I see that I was quite vague. Currently, when I select medical, it shows me everyone in Medical and in Medical Records. What I want is for those to not to be grouped together. This is happening because in the VB code for btnFind we have the code set to: if len(nz(me!txtGroup,""))>0...

Success!!!!! Frink, it works like a charm. I know it was a long and drawn out process but you were an excellent resource! I am down to having one Search button and it lets me search seperate columns to find date ranges. It comes up beautifully. I could not have done it with out you...

It seems like it should be so easy, and yet, this is giving me such a hard time... I did as you said. I still have the second button on my form for testing purposes. OnClick for that button, I pasted your big VB code that you last sent and modified the line you mentioned in your last posed...

Hi Frink, I am still having a hard time... In response to your last message, I have changed my DB to match the naming conventions. You are absolutley correct - when I look at it in the future, it will be easier to understand. I've also changed my radio buttons to the round ones, not the...

Hi Frink, I have created a Blog to make this easier. I have posted screen shots of my database. In it, I have my main table, my search query, and my main search form. I hope that helpe you get an idea of what I am doing and how. So far, your help has been excellent. Thank you for it. Here...

Hi Frink, The info you sent was excellent and I think I have the code working. I already have a subform on my main Frm_Find search form. The results of the Name and Group query are working and the entries appear in the form in Tabular layout. How do I link the new date range VB code to this...

Hello Frink, I am sorry for my late response... I am in Australia and the time difference doesn't work in my favour. The code that you sent me looks very good and I have managed to change most of it to fit my db. I have a few questions though. 1. In the following bet of code, what does the...

Hi Frink, Good comments and I've given them a think. The database is used to track users who have been trained on particular systems. There would only be three people using the DB since we only have three trainers. Our current method of tracking who was trained is an Excel spreadsheet. The...

I have a form which is used to search my main table based on criteria like Name and Group and return the results in a subform. In addition to Name and Group columns, I currently have 3 columns in my table which represent modules of a system. When users are trained on the modules, I put the...

Any advice, anyone? Silvia

Thank PH, This is a very good example but not quite what I am looking for. I'd like to get a list of all of the records that meet the required parameters - eg. All the people who's name starts with A and they had MedChart training on 14/1/06. In the subform, I'd like to be able to add...

Hi there, I know that there is a simple solution to my question, but I am having a brain block... I created a DB to track users that have been trained in a new system and which module training sessions they attended. I have a Training table that collects the Name, Practice Group, and the date...

Hi Andy Thank you very much... I guess I just had a panicking moment of confusion. :-) Silvia

How do I add this secondary axis? I asked for help and I have the feature of step 2 under my format menu. HELP PLEASE suggestions from microsoft help feature Click the data series you want to plot along a secondary value axis. On the Format menu, click Selected Data Series, and then click...