Search results

  1. mike60smart

    Working with form records

    Hi I noticed a slight problem when trying to set and enforce Referential Integrity between your Tables OrderDetailT and ProductT. I get the error shown in the attached. This occurs because you have the field named "ProductID" in the OrderDetailT with a Default Value of 0 Your ProductT does...
  2. mike60smart

    Modern Charts - Remove Half Border Line

    This is a year old thread.
  3. mike60smart

    DoCmd.SendObject and CDO

    Hi All I have used it for is just to send Emails
  4. mike60smart

    DoCmd.SendObject and CDO

    Hi Colin I have used Thunderbird with Access and it works a treat.
  5. mike60smart

    Solved Query if Between lower and upper to return lower, returning all records

    Just a comment. A lot of your Tables contain Lookup Fields. You should not use Lookup Fields in tables. Google "The Evils of Lookup Fields in Access Tables"
  6. mike60smart

    Selecting only records where both of two values exist

    Can you upload a stripped down version of the database with just the tables and query?
  7. mike60smart

    Selecting only records where both of two values exist

    Hi John Your tables/Relationships should be as shown in the attached.
  8. mike60smart

    Ray Casting 3D Maze in MS Access

    yes thanks
  9. mike60smart

    Ray Casting 3D Maze in MS Access

    If you don't mind me asking but what is the point of this as an Access Database?
  10. mike60smart

    Solved Begginer! please help.

    Hi I believe you need to have a rethink on the structure of your tables. The attached is an example Relationship Diagram produced by Github. See this Link
  11. mike60smart

    The copy text and add new record Button Events are not working

    Hi Barbara The database you uploaded has a table named "Investments01_tbl" with 18 Records. The other related table named "Investments01_tbl_SubForm" has over 24000 Records. We need the original "Investments01_tbl" with all current records. Also the Form with the error is based on a Query? The...
  12. mike60smart

    The copy text and add new record Button Events are not working

    No it is not. The process is that you click the Reply button and enter your answer. Then click the "Attach Files" button and navigate to the database file you want to upload. Make sure that you compress the file into a zipped format. Then select the compressed/zipped file and click Open. The...
  13. mike60smart

    The copy text and add new record Button Events are not working

    Hi Barbara No attachment
  14. mike60smart

    The copy text and add new record Button Events are not working

    Hi Barbara Can you upload the Db so we can see the problem?
  15. mike60smart

    2 queries in one form

    True, badly worded on my part. Probably best to say that you cannot set the relationship unless bad data is removed.
  16. mike60smart

    2 queries in one form

    True but the purpose of the Post was to indicate to the OP what the error was.
  17. mike60smart

    Service Ticket Table(s)

    Hi Attached is a screenshot of what I think are the required Relationships. Not all tables are as yet included.
  18. mike60smart

    Service Ticket Table(s)

    Hi Can you send me your current "tblMachine" with actual data?
  19. mike60smart

    Service Ticket Table(s)

    When you talk about Machine ID 312 and 1046, are these ID numbers that have been Manually created by you?
  20. mike60smart

    Service Ticket Table(s)

    No it makes complete sense
Back
Top Bottom