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!

  • Congratulations Mike Lewis 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. Telumendil

    Criteria selections

    That's it... I there was a difference, but I couldn't remember where... Thanks Leslie...
  2. Telumendil

    access import objects audit

    Yes, there is a way... You need to create a form letting you choose the name of your table, import it through the module as a recordset, which has a property called columncount, or so...
  3. Telumendil

    Criteria selections

    No, you're right, it was already "*" in 97, sorry...
  4. Telumendil

    Criteria selections

    No, not sure, but I've read something about this somewhere not so long ago... I'll check that tomorrow, I'm not at wor today... Have a nice day...
  5. Telumendil

    Criteria selections

    That is if you're with Access 2000, the wildcard character is something else in access 97, but I can't remember what...
  6. Telumendil

    Forms and relationships

    You can also define the form's Source in the Properties, Data, ControlSource (or something like this, I don't know exactly, I'm using the french version)... Have fun... :-)
  7. Telumendil

    Automatically ran queries!!!

    I would create a form launched at DB start up, which checks if there is any date nearing expiry, closes if not and displays it if there's any...
  8. Telumendil

    DLookUp and Yes/No

    Thanks anyhow...
  9. Telumendil

    DLookUp and Yes/No

    Just found out what the problem was... Opening and closing brackets were necessary... Correct code is : =DLookUp("[2004]","[LBA Account]","[LBA Account].[LBA_Compte] =" & Compte_N°)
  10. Telumendil

    DLookUp and Yes/No

    =DLookUp("2004","[LBA Account]","[LBA Account].[LBA_Compte] =" & Compte_N°)
  11. Telumendil

    DLookUp and Yes/No

    Well, it is in a report, and I have both a checkbox and a provisory textbox (format yes/no) in it... The result is Yes whether the field value is yes or no when the DLookUp criteria match a record and no when they don't...
  12. Telumendil

    DLookUp and Yes/No

    When I try to get the value from a Yes/No field with a DlookUp function, the result I become is Yes if DLookUp is successful and No when criteria don't match any record ? Does anyone know where this problem comes from ? How should I do to get the value of the field ?

Part and Inventory Search

Back
Top