Search results

  1. T

    Help: Problem AFTER Search

    Kind of confusing but here it goes: The form is a search form with a subform. When I search through the subform...I change the RecordSource. When I search through the main form, I use a filter. Well the problem arises after I do a search through the subform I can not search through the main...
  2. T

    Help: RecordSource Problem?

    Kind of confusing but here it goes: The form is a search form with a subform. When I search through the subform...I change the RecordSource. When I search through the main form, I use a filter. Well the problem arises after I do a search through the subform I can not search through the main...
  3. T

    Show All Records

    Still the same error was generated...
  4. T

    Show All Records

    Ok I am getting an error message box saying: Run-time error 2452 The expression you entered has an invalid reference to the Parent property.
  5. T

    Show All Records

    Nope, how is that done? Forms![FORMNAME].SetFocus Like that?
  6. T

    Show All Records

    I just dont get it. I have 1175 records. When I use Me.RecordSource = "Accounts" after I perform a search, the record count goes back to 1175. But then when I try to search through the main form, it can't find any records...
  7. T

    Show All Records

    Ha. That works if I filter the main form. But does not work if I filter the subform. To filter the subform I am changing the RecordSource.
  8. T

    Show All Records

    I tried putting: Me.FilterOn = False but that does not work.
  9. T

    Show All Records

    Hi, I can not search in my mainform after I do a search in my subform. After I perform a search in the subform and I try to search the mainform, I get a no records message box that I created because it can't find any matches EVEN THOUGH there are matches. To solve this I have a reset button...
  10. T

    Not Displaying Error Message Box

    I already solved the problem. I found out the the error was referring to a subform and the code in the subform. I fixed the code and everything works! Thanks maxmangion for your help!
  11. T

    Not Displaying Error Message Box

    When I perform a search with a certain condition...the search works, but a message box pops up stating: Syntax Error (missing operator) in expression But the search works. So what I want is to just get rid of the message box. I tried setting the warnings to false. I also put the code...
  12. T

    Blank Report

    What I do is create a query and then save the query as a report. See if that works.
  13. T

    Search Form with Multiple items

    And just change the text box names and the field names to your text box names and field names. Notice, in the code, Company, City, and Account are searched by LIKE and State is searched by = Meaning you can put in Trinity for say the company and results will come back with the word Trinity...
  14. T

    Search Form with Multiple items

    Dim strWhere As String Dim lngLen As Long If Not IsNull(Me.txtSearchCompany) Then strWhere = strWhere & " ([Company] Like '" & Me.txtSearchCompany & "*') AND " End If If Not IsNull(Me.txtSearchState) Then strWhere = strWhere & "([State] = """ &...
  15. T

    Hitting TAB at end of form, how go to new, blank form?

    Good luck with the rest of your database.
  16. T

    Search Form

    I guess I will ask this question first: Are you searching through a subform or a mainform?
  17. T

    Hitting TAB at end of form, how go to new, blank form?

    Whatever the last thing is on the form....be in a button or a text box....on that field put this code under the On Lost Focus Event: DoCmd.GoToRecord , , acNewRec
  18. T

    Creating A Diary In Access

    I did not make it sorry. I could probably figure out how to make it though, but I dont have the time now. Props to whomever made it. You can search through the forum to find other example calendars and see if you like them. To view a day to day diary? I don't really understand that...
  19. T

    Creating A Diary In Access

    All you have to do is make a table...probably called Diary and then put two fields....Date and Notes or something to that extent. In design view make the default value in the Date field to Date(). Then make a form based off of the Diary table and then you are all set. You might want to...
  20. T

    Creating A Diary In Access

    I can probably create a diary form for you...it should be really easy.
Top Bottom