Search results

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"

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...

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

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...

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...

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...

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...

That works brilliantly, thank you!

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...

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.

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...

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!

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...

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...

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...

Not great with VB code but has anyone used VB code to do this? It seems a bit cack handed doing this with lumped together Queries and as you can see above, the DSum function does not accurately replicate cumalative %s. It seems so simple!!!! Count and sum, work out what each item is in terms of...

Hi All, I currently have a Pareto graph created by a query, that counts occurence and then uses the Dsum function to create the cumalative %. The function is as follows: CumPct: DSum("[CountofConcern_Number]","qry_ProbByConcern","[CountofConcern_Number]>=" & [Total Concerns] &...

Just stumbled accross this one and wondered what the outcome was?

Chergh, you are legend! Thank you. That worked straight off and I understand why, so thanks Rabbie, Gemma and Chergh! Excellent. I did try the Can Shrink property, and that worked but it meant that all the different text boxes would shrink to the size of the text contained and it looked...

Thanks for all your input, i have still not managed to define this problem, I think it maybe as gemma as said, no data or null values are appearing in the text, I am afraid I don't quite understand the above code. I am not 100% up to speed on VB sorry!!! I have tried breaking down what I can...