Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SilFaz

    Create report based on data returned in a subform??

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

    Create report based on data returned in a subform??

    Any ideas? Opinions? Silvia
  3. SilFaz

    Create report based on data returned in a subform??

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

    Searching Date Ranges in Several Columns

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

    Searching Date Ranges in Several Columns

    ...& " 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 "...
  6. SilFaz

    Searching Date Ranges in Several Columns

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

    Searching Date Ranges in Several Columns

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

    Searching Date Ranges in Several Columns

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

    Searching Date Ranges in Several Columns

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

    Searching Date Ranges in Several Columns

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

    Searching Date Ranges in Several Columns

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

    Searching Date Ranges in Several Columns

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

    Searching Date Ranges in Several Columns

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

    Searching Date Ranges in Several Columns

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

    Searching Date Ranges in Several Columns

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

    Mutli-parameter text search - calling a query from form?

    Any advice, anyone? Silvia
  17. SilFaz

    Mutli-parameter text search - calling a query from form?

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

    Mutli-parameter text search - calling a query from form?

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

    Adding a secondary axis on excel graph

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

    Adding a secondary axis on excel graph

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

Part and Inventory Search

Back
Top