Search results

Bloody Marvellous, so simple but has had me stalled all day. Cheers very much Devastation.

Nope No Go. Cheers

I have a single lingering problem preventing me from moving on with my project. I have a single form with 3 command buttons on it, Delete, Edit, Save&Close. The form loads as default with: Me.AllowAdditions = False Me.AllowEdits = False Me.AllowDeletions = False...

jeeves79, i have noticed that you have had to post this topic a couple of times as no one seems to have a viable answer for you. I too have posted the same question before and have had no joy with a proper solution. Subsequently i would be a very happy lad if you found a solution. it seems...

Demo Version Thanks Bob. Please find attached a demo version of the database. Would appreciate greatly any assistance. Cheers Nathan

Still No Go Bob thankyou for your input, i had not done that for the vista machines, i have done so now but unfortunately the problem still exists. I have enclosed a screenshot of the offending fields. Notice the total field has the "error" in it, while the other 3 fields appear to have...

Hi All, I have a simple form with 3 subforms. I have a 1 data field on the main form for each subtotal of the subforms as well as an overall total field. I have the following code in the subtotal fields: SETot=IIf(DCount("[ID]","qryExpenses")=0,0,DSum("[Reimbursment]","qryExpenses"))...

Does anyone know why MS Access 2007 does not use the same charting engine as the rest of Office 2007. I find the new engine in Office 2007 very nice indeed and a significant improvement over previous versions, both aesthetically and functionally, so why am i still left with crap options for...

----solved---- Just to let you all know, i have finally solved this issue myself. I have basically designed a LUT with some of the more fixed data in it as follows: group,stage,value grp1, stage1, x1 grp1, stage2, x2 grp1, stage3, x3 grp1, stage4, x4 grp1, stage5, x5 grp2, stage1, x2 grp2...

This particular database generally looks at reporting individual records as opposed to summary reports. So for a particular data record i have the following data [x1][x2][x3][x4][x5][y1][y2][y3][y4][y5] I need to chart (scatter) these figures as paired x,y variables for display on a feedback...

THis may very well be the solution i'm looking for. Unfortunately i have a boss who thinks we're all 3 years old and therefore we don't have access rights and therefore can't make these changes straight away. Once she gets some time i'll arrange for these changes and give it a try. Thanks for...

Hi folks, I'm trying to append some data from one table to another table as i've had to slightly alter the structure of the table. I have an attachments field in both tables but it seems that i cannot append the attachments from one table to the other. I get the following error when trying to...

I have a niggling printing issue but some background first. First thing - my reports are NOT summary reports therefore i have no grouping levels etc etc. Each report is specific to a "Health Test". A full "Health Assessment" contains multiple Health Tests. eg Health Assessment A...

Sorry Monika, i never do seem to be able to do things the easy way. Some info as follows might help clear things up. 1. The reports are not summary reports. They are individual reports based on 2 joined queries (one getting info for current test and one getting info for previous test) that is...

Sorry Monika, Notice on page 1 of the pdf the BGL figure is correctly shown in the field as 3.89 while it shows 4.25 in the chart. A second attempt of the print run is represented by page 2 where you can see that the figures are correct in both the field and the chart. Actually i should also...

Moniker, Not entirely sure what you are referring to with regard to refreshing/requerying on each run, though it sounds like something that might do the trick. I have added a zipped copy of an example. This may help clear things up.

Hi there all. I have built a database that collects our clients Baseline health data which generates a series of single page reports for each type of health test that has been completed. So for example we take blood pressure and return a single page report with a chart containing both systolic...

My Solution I've settled on the following solution. Cheers for your input. SPass: Sum(IIf([Table]![test01]="Pass",1,0)+IIf([Table]![test02]="Pass",1,0)) It actually serves my purpose to split the report into sections anyway so i'll do a final total on the report rather than the query...

I'm building a health data system that stores data from health tests as follows: [test01], [test02], [test03],.........[test25], etc etc. Each of these tests comprised of a "Pass"/"Fail" value. Now, i'm building my queries for a feedback report to hand over to the client that is based solely on...