Search results

  1. M

    Need expert advice on search-possibilities. Please...

    Hi and thanx for your reply :) You make some very good points there Doc_Man. I have "quested" a bit around the problem and came up with a solution that miiight be okay enough : Just posting it to get your aspect of view on it --> This may be interessting for others to view too, since it's a...
  2. M

    Need expert advice on search-possibilities. Please...

    Hi and thanx a LOT for reading my post.. I'm quite lost here and VERY near deadline so yes.. i'm a bit stressed out :) I'm creating this criminal investigation information -"dump" database which should be searchable every- and any way possible.. ----------------------GENERAL...
  3. M

    Possible to use a delay on .ControlTipText ?

    Hi :) I'm using Me.button.ControlTipText = "Text is here" on a button to get a description for it.. But.. it takes a bit of time from when i mouse over the button until it's displayed.. Is it possible in any way, to shorten the time it takes to display the text ? Any "delay" i can use, or...
  4. M

    Search Query with both numbers and text.

    Got it fixed.. at last.. Tablename.[Field Name] worked..
  5. M

    Search Query with both numbers and text.

    Thanx a LOT !!.. for your help :) It was most appreciated and ... IT WORKED !§!!!! But.. it seems it dont like the fieldnames which got spaces inbetween like this : " OR Opprinnelses adresse LIKE '*" & Cstr(Me.txtSearch) Hmm... any way to format this to get it to work ? Tejre.
  6. M

    Search Query with both numbers and text.

    Hi and thanx for your reply :) Thanx for the tip with the *'s. Will try that out.. but half of the fields are number fields i'm afraid.. That's why i'm getting problems executing the query, and it results in a operator error, which is because it's trying to search the text-fields with number...
  7. M

    Search Query with both numbers and text.

    Hi and thanx for reading my post.. I got this search form which uses this SQL query to search for matches in the Person form. it's absolutely neccesary to search both Number-fields and Text-fields... This is a sample of the query : SELECT * FROM Person WHERE SSNr LIKE '%" & Me.txtSearch &...
  8. M

    Using .Requery on a form which got a subform, with another subform in it *headache*

    Found the form/sub/sub but didn't requery. Thanx for your reply :) Well.. it went through, but didn't .requery :) Tried running the .Refresh after this, but that object wasn't supported for the method (??)... Anyway.. it seems i miiight need to create something more "global", because this...
  9. M

    Using .Requery on a form which got a subform, with another subform in it *headache*

    Hi and thanx for reading my post.. Well.. generally i want to do a : Forms![frmMAIN]![Subformname].Requery but the problem is that i got this "frmMAIN" which got "tabsubPerson" as a subform, and in the "tabsubPerson" i got "subqryPersonVehicle" as a subform too.. All this should be done from...
Back
Top Bottom