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

...to conduct the search and return the required info in a subform. I can click on an Edit button and add/adjust info for ppl already trained. **What I would like to do is create a report based on the info returned in the subform. Currently, I am basing the info in the report on a Query...

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

...& " AND strDateStamp(" & strField & ")<=" & strDateStamp(Me!txtEndDate) & "" End If End If End If If strSQLQuery Like " AND *" Then strSQLQuery = "WHERE " & Mid$(strSQLQuery, 5) Else strSQLQuery = "" End If Me!FindQ.Form.RecordSource = "SELECT * FROM tblTraining "...

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

...VB code for btnFind we have the code set to: if len(nz(me!txtGroup,""))>0 then strSQLQuery =strSQLQuery & " AND strGroup Like """ & me!txtGroup & "*""" This means that if Medical is selected, the vb code runs 'Medical *' (I'm talking myself through this to make sure I understand). What I...

...we are doing a Group filter like this: If Len(Nz(Me!txtGroup, "")) > 0 Then strSQLQuery = strSQLQuery & " AND strGroup Like """ & Me!txtGroup & "*""" The users choose from a combo box. Can we set this filter to choose from the list? Eg. Right now I have a Medical and a Medical Records...

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

...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 is the address of the blog: trainingdbsilfaz *dot* blogspot *dot* com/ Silvia

...VB code to this subform and have the same info (Name, Group, various module dates) appear which falls between the dates that I require? Right now, I *think* that the code is working, but I am not sure because I do not have a place for it to be returned to so I can't check. Thanks again, Silvia

...most of it to fit my db. I have a few questions though. 1. In the following bet of code, what does the fraModule refer to? strSQLQuery = "SELECT * FROM tblData " Select Case me!fraModule ... 2. When selecting the module columns from my table, can I put it like this?: case...

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

...Training.MedChart, Training.[Pt Lists], Training.MedHist FROM Training WHERE (([Training].[Name] Like [Forms]![Frm_Find]![Name] & "*") Or ([Forms]![Frm_Find]![Name] Is Null)) AND (([Training].[Group]=[Forms]![Frm_SearchAttempt_Main]![Group]) Or ([Forms]![Frm_SearchAttempt_Main]![Group] Is...

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