Search results

  1. M

    Ranking Query

    Yuo can use an "ASCENDING" or "DESCENDING" sort. Look at "DemoRankingQueryA20022003.mdb" (attachment, zip). Look at table and queries. Rune Query1 or Query2 and see.
  2. M

    Query with Replication ID

    Try in query-criteria; [Forms]![FormName]![CustomerID]
  3. M

    Sorting Problem

    Hello Louis M ! As I can understand you, you need something like this (Attachment, zip). I added a Subform, I change Default view (Single form). Look at RECORD SOURCE in "Form_SearchAllContacts", also look at in "frmContractSubform", Look at RELATIONSHIPS, Look at "Link child Fields" and "Link...
  4. M

    One combo box linked to another

    Send a short example of your MDB, (Access 2000 or 2002-2003).
  5. M

    Relationship between two tables

    As I can understand you, you don't need 2 tables, and you don't need a RELATIONSHIPS between these 2 tables. One tabe is enough.
  6. M

    Add text at the beginning of a field

    Do you wish "Append query" or "Update query" ?? Do you wish to add a new record, or update an old record ???
  7. M

    Another IIF question

    Send a short example of your mdb, (Access 2000 or 2002-2003), and say what you want to do.
  8. M

    If "TableA.FieldA" exists in "TableB.FieldB" then return "1" else "2"

    Re: If "TableA.FieldA" exists in "TableB.FieldB" then return "1" else "2" My congratulations !!
  9. M

    Subform creating a blank record

    Send a short example of your mdb, (Access 2000 or 2002-2003).
  10. M

    Subform creating a blank record

    Yes there is a way to stop this. Make one or more fields in the table as REQUIRED.
  11. M

    Question help Dlookup function

    You write a Form, and you want to enter 1 (it means you want to enter a new record), wherefrom you want to see "a", (you have no record in your table). You can use an IF function for this (not Dlookup). If Me.Nr = 1 Then Me.Simbol = "a" 'and so on. End if
  12. M

    DCOUNT Challenge. Is this possible?

    Send a short example of your mdb, (access 2000 or 2002-2003), and tell what you want to do. See you tomorrow.
  13. M

    If "TableA.FieldA" exists in "TableB.FieldB" then return "1" else "2"

    Re: If "TableA.FieldA" exists in "TableB.FieldB" then return "1" else "2" You can make a FUNCTION (if you know to do that). Function can be called from form, also from a query.
  14. M

    If "TableA.FieldA" exists in "TableB.FieldB" then return "1" else "2"

    Re: If "TableA.FieldA" exists in "TableB.FieldB" then return "1" else "2" FieldAB isn't a field it is a FUNCTION in Module1.
  15. M

    Listbox selection to open record

    Look at "DemoSearchRecordA20022003.mdb" (attachment, zip). Open form and try. Adapt it in your mdb.
  16. M

    If "TableA.FieldA" exists in "TableB.FieldB" then return "1" else "2"

    Re: If "TableA.FieldA" exists in "TableB.FieldB" then return "1" else "2" Look at "DemoPostCodeA20022003.mdb" (attachment, zip). Look at TableA, TableB, Query1, Module1. Run query and see, I think it is what you want.
  17. M

    query multiple optional criteria

    Look at "DemoFirstNameA20022003.mdb" (attachment, zip). Look at Table1, Query1. Run Query1. If you want the Firstname only, in the question for Surname put the sign * (and vice versa). Try with Mmmmm * Try with * Stef Try with * salers Try with Andrej...
  18. M

    Form / Dsum problem

    Look at Access help about DSum function. (Word, Zip).
  19. M

    Option buttons

    Look at another way (as gemma-the-husky sey), with OPTION GROUP. Open Form1 and try. Adapt it as you want.
  20. M

    Option buttons

    Look at "DemoOptionButtonsA20022003.mdb" (attachment, zip). Open Form1 and try.
Back
Top Bottom