Search results

  1. I

    How do I fix a messed up auto number?

    Thank you very very much! Very kind of you. :)
  2. I

    How do I fix a messed up auto number?

    ...and which is this code...? I have exactly the same problem and didnt manage to find anything on internet.
  3. I

    Searching into a form

    Another db due opening problems of the last (according to Rosito)
  4. I

    Searching into a form

    Here is the db Bob
  5. I

    Returning results in search form

    anyone...?
  6. I

    Searching into a form

    Rosito?...
  7. I

    Returning results in search form

    I have a Search Form. Criteria are some combo boxes. The problem is that search process return me as results numbers (the IDs of the tables) and not names. Par example, if I give the option "Sunday" into the criteria field "Day", the result is "1" (the ID of "Day" table) and not "Sunday". How...
  8. I

    Searching into a form

    I have a Search Form. Criteria are some combo boxes. The problem is that search process return me as results numbers (the IDs of the tables) and not names. Par example, if I give the option "Sunday" into the criteria field "Day", the result is "1" (the ID of "Day" table) and not "Sunday". How...
  9. I

    Searching into a form

    And of course...ty! :)
  10. I

    Searching into a form

    unbelievable...so simple :) Mind if I'll ask u somethin' else?
  11. I

    Searching into a form

    I have a form for "Deliveries". "ID"-"Delivery Number"-"Kind of delivery". A combo search-box I made allow me to find a record by the "ID". How can I do the same while I search for a record by "Delivery number"?
  12. I

    Search Form Appearence

    the file. i forgot it into the last message
  13. I

    Search Form Appearence

    Last try mr Bob. Try this .zip. Its the one you sent to me, fixed (the greek is english now everywhere). Run it to test it.
  14. I

    Search Form Appearence

    The code (if the .zip refuse to open Option Compare Database Option Explicit Private Sub cmdFilter_Click() Dim strWhere As String Dim lngLen As Long If Not IsNull(Me.FilterDay) Then strWhere = strWhere & "([DayID] = " & Me.FilterDay & ") AND " End If...
  15. I

    Search Form Appearence

    I'm not an expert. Not even a tolerable enough access user. And my english is poor. What exactly must change into code or outside the code?
  16. I

    Search Form Appearence

    The .zip again fixed I hope
  17. I

    Search Form Appearence

    Thank you for the response. If I understood right in table Works I must change the look for the field DayID from a combo box to text. If I will do that, what is the purpose of table Days existence?
  18. I

    Search Form Appearence

    Hello to everybody. I have a Search Form with two options as criteria. "Days" and "Works" of each day . Days is a combo box with the days of the week. Data of combo box are records of the Days Table . Although the days of Criteria Section appear as words, the results appear by the DayID of the...
  19. I

    How I can take text and no number in result that arises from a combo-box into a searc

    Example Neil: I have a table of months. I have also a search form where the criterion of the month exist and i made a combo box to make the insertion of months easier. Into that combo box i managed to eliminate the MonthID by setting the width of the ID column to zero. So, now when i choose...
  20. I

    How I can take text and no number in result that arises from a combo-box into a searc

    Into the combo box in criteria, I did exactly you wrote. I changed the first column to 0. My problem is in the results.
Back
Top Bottom