Search results

  1. M

    The Microsoft database engine cannot find a record...

    Do you try to enter a record in the SUBFORM before the MAIN FORM ?? What is your RELATIONSHIPS between these two tables ??
  2. M

    The Microsoft database engine cannot find a record...

    Do you have a MAIN FORM and a SUBFORM ??
  3. M

    Command Button Macro

    Look at "DemoAdditionalsDetailsIDA20022003.mdb" (attachment, zip). Open Form and try.
  4. M

    Command Button Macro

    Do you want to find a record via Primary key ???
  5. M

    Get Last (Max) record in table

    You get T9 because it is a txt field, and textSort. You have to sort on number. Look at "DemoMaxPoA20022003.mdb" (attachment, zip). Look at Table, Query. Run Query2. Adapt it in your mdb.
  6. M

    Query not picking up records

    It is "Access 2007", I can't read it.
  7. M

    Query not picking up records

    I don't know if I not see it.
  8. M

    Autonumber not counting

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

    Query not picking up records

    You can to change a RELATIONSHIPS in the query, independantly of that in the Relationships. If you want, send a short example of your mdb (access 2000 or 2002-2003), and tell what you want to do.
  10. M

    Urgent Help Needed - Query to remove duplicates

    1) Make another table with the same fields. 2) In this table make ID = Primary key. 3) Make an append query. Input is your table, output is this another table. 4) Run this query. 5) Delete first table.
  11. M

    Search for button

    Look at "DemoSearchRecordA20022003.mdb" (attachment, zip). Oepn Form1 and try. Adapt it in your mdb.
  12. M

    How to get the last character of the string?

    Try and see .
  13. M

    How to get the last character of the string?

    Try to do it via: Like "*" & [Forms]![FormName]![FieldName] & "*" in the criteria (in Query).
  14. M

    Help with a Null value in a foreign key field??

    I can't to say anything, I dont know your task. You have to decide this.
  15. M

    Help with a Null value in a foreign key field??

    If you have got a REFERENTIAL INTEGRITY (in the RELATIONSHIPS) between these two tables, you can't to write a record in the table "JOB LOG". You must write the record in the table "CUSTOMERS" before. You can't to build a house starting from the roof.
  16. M

    Multiple Elements on One Sub-Form?

    I think you don't need so many tables, (and forms). Look at "DemoPaymentA20022003.mdb", (attachment, zip). Look at Tables, Forms(VBA), RELATIONSHIPS. Adapt it in your mdb.
  17. M

    Spacing Issue with Dynamic Search

    Yes, you have to be careful, If you write "A 100333" then you have to write on same way always. Try to use INPUT MASK properties.
  18. M

    Spacing Issue with Dynamic Search

    Look at "DemoFindLikeA2003.mdb" (attachment, zip). Open Form1 and try. Adapt it in your mdb.
  19. M

    Help me to create search button

    Look at "DemoFindA2002.mdb" (attachment, zip). Open form and try.
  20. M

    Linking a form to another form

    Look at "Relationships" (attachment, word).
Back
Top Bottom