Recent content by manix

  1. manix

    Custom Subject using Sendobject Macro

    It's OK I have managed to find a related thread here:http://www.access-programmers.co.uk/forums/showthread.php?t=231270 It is simply: ="Blah blah blah " & [Forms]![frm_ChangeRequest]![Responsible Owner].[column](3) & " report is late blah blah blah"
  2. manix

    Custom Subject using Sendobject Macro

    Hi All, Trying to use the sendobject macro to simply send an email with a subject line that is both text and data from the loaded form fields. So for example: "Concern" [45] "has been raised by" [Harry]",please respond" where the "" is the set text and [] is data from the fields. I have...
  3. manix

    Using SendObject Macro to Email using Combobox problem with Bound Control

    Thanks for the response, works a treat! I will have a look at the naming conventions, I have enough PITA's! :mad:
  4. manix

    Using SendObject Macro to Email using Combobox problem with Bound Control

    Hi All, This is frustrating me! I have a form field that is a Combo Box that allows users to select a contact a table of contacts. Now because this is a linked table containing the contact information, the relationship requires the numeric Key field to be recorded in the table. So if I use...
  5. manix

    Three Tables which needs more direct relationships!

    OK, my dilemma is how the data gets recorded in the forms. The relationships in theory work if you manually enter the docID and the CR Number. However, I am using Subforms, which is fine but only works at one level: If you have the Rev Log as a subform of the Change Request, you can enforce the...
  6. manix

    Three Tables which needs more direct relationships!

    Basically: Documents exist in soft copy on a network drive. The business must control them as part of their Quality Management System, this involves ensuring the same formats and information are available consistently and not subject to change, without review and approval. The register just...
  7. manix

    Three Tables which needs more direct relationships!

    Hi, I have three tables in a database simply designed to control document revisions. 1. The Document Register Table where each document has record. 2. The Revision Log Table which is directly related to the Document Register as each document could have multiple revisions- so One to Many. 3...
  8. manix

    Query to Report Duration an item is OPEN

    That works brilliantly, thank you!
  9. manix

    Query to Report Duration an item is OPEN

    Hi All, As a relative novice this probably sounds noobish, but I am not that hot on code at the moment. I have a table that contains data relating to quality concerns. Now one field in this table is the date the concern is closed and another is date open. I want to report the duration...
  10. manix

    Creating Multiple Reports from one click

    Thanks Mr B, I kind of get your meaning and I will have a play, but that seems to be a bit beyond my current capability! I will see if, with a bit of time I can figure that out. Thanks again.
  11. manix

    Creating Multiple Reports from one click

    Hi All, I currently have a complex array of tables and queries that create a report - A supplier performance scorecard. This score card is a report of a supplier performance over a given space of time. Currently, the query used to create the report looks at x3 combo boxes that the user fills...
  12. manix

    Using Access to record and Excel to Report

    Thanks Bob that looks good I'll give it a go and let you know how I get on. Hopefuly this will save me a few hours! I was going to give you Kudos, but the forum wouldn't let me! Thanks Again!
  13. manix

    Using Access to record and Excel to Report

    Hi All, Been a while since I tackled any Access related things so I am back!! Anyway, I have an Access DB (2003) that has a lot of useful data, but I am fed up with the reporting feature. It is especially useless at graphs, so I want to utilise Excel. The trouble is I want to export data...
  14. manix

    Masking a field that returns "#error" when certain conditions are not met

    Re: Masking a field that returns "#error" when certain conditions are not met Thanks for the quick response, but it still produces the #error and not the "No Rating". Umm, think this might get complicated. The expression works when there is data, but when there is no data avialble from the...
  15. manix

    Masking a field that returns "#error" when certain conditions are not met

    Hi All, I have a complex query that uses the following expression to calculate a rating. However, if one of the ocnditions is not met, it returns a "#error". This is fine, but I want to mask this with something like "No Rating", when they are not met. Is this possible and how is best to do...
Top Bottom