Search results

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

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

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

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

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

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

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

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

Hi, I have a line of text boxes on a report that report values via a query. Now sometimes the report may not have any values to display, but the report must still be produced and printed. I have 5 text boxes that, if the query does not return any results, I want these txt boxes to not be...

Hi All, I need some assistance. I have a txt box that records a hyperlink on a form. Now to save the user from having to input the file path manually, I have added a button that allows the user to select the file they want to link. The path is then recorded in the txt box. This works fine, but...

Hi all, I have one report that I want the data source to be 2x queries. But I only want it to use "one query or the other" depending on which button is pressed on a form, to open the report. I have tried searching for this solution everywhere, but all I can find is how to create multiple...

HI All, I have a small question. I have a form that can be opened from another form to add a record to a combo box. So if the use looks at the drop down list from the combo box and they cannot see the item they require, they can click a button and "add" the required item to the list. In order...

Hi All, I have fought hard to try and figure this out and I have gotten 50% there. I have a query that generates the following calculated fields through numerous calculations etc....: [De-Merit Marks] [No Del with Major Faults] Now the way it should work is that a supplier gets a rating...

Hi All, I have a lookup list in a field of a table. It is used on a form and contains a list of two field from another table. It is simply a text field and a number field. When the user clicks on the lookup list they see the test and associated number fields in the list. They click on the...

Hi All, I have read a few posts on here but can't quite get a solution to my particular issue. I have two tables in a query: tbl_suppliers tbl_supplier_perf tbl_suppliers is right joined with tbl_supplier_perf by [Location Name]----->[Supplier] No as part of tbl_supplier_perf there is a...

Hi All, I have a report, that has a detail section that shows an amount of records dependant upon the results of a query. Pretty straightforward, but I have no idea of the best place to put a could of graphs that I want to show on the same report! I can't put them in the detail section or...

Hi All, I have a really frustrating problem. I have a report that simply shows a list of records. The records contain file paths for images for various forms and reports within the database. There are two fileds in each record for the file paths, [Photo] and [Photo2]. In order that the...

Wasen't sure whether this is a Reporting thing or a Querie thing as it resides inbetween the two. Basically (and believe me I thought this would be pretty straight forward!!!!), I am trying to create a chart from a query that returns the occurences of concerns raised each month for a year...

I am infuriated with MS Access now!!!!! I am building a nice little system and now I am developing the reporting features. I want the results of a query to populate a chart. Basically it is a monthly chart, so would have 12 months along the x axis and a quantity on the Y. A simple line chart...

Hi All, I have tried searching for this but I don't really know what to look for. I have A main table that is populated by a form. I then have another table that collects data and is related the main table by a common field (a One to Many relationship). I then have a separate form to...