Search results

I have a report that contains a cumulative bar chart, based upon the results of a crosstab query. It ought to be a one page report containing one chart. However, when printing this report it appears to print multiple copies of the same page. Having redesigned the report to incorporate "Page X...

Thanks. I was hoping to avoid that particular scenario as the calculations are long winded and variable depending on certain scenarios, but if that's what I've got to do then so be it.

To save time ( so I thought ) I have designed a database whose forms perform the arithmatic I need and whose tables contain the bare minimum of base data. In essence I have alot of text boxes displaying values on forms but the values only reside on the form and not in a table. The problem now...

Cracked it. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.DaysLag > 0 Then With TextDaysLag .Height = 230 .Visible = True End With With TextLagNotes .Height = 230 .Visible = True End...

Making some progress by using the OnFormat event in the Details part of the report. This at least hides or displays rows depending on whether data exists. Just need to crack the spacing.

Thanks. I am having trouble with the 'vbCrLf' part of this code. I assume this is trying to introduce a carriage return. Either access assumes it to be text or a field name, either way not a carriage return. This solution is also pre-empting the report so I could not for example modify the...

Is there a clever way to get rid of blank rows in a report ? In simple terms my report contains 2 fields. Field1 always contains data and therefore I always need a line in my report to display this data. Field2 does not always contain data. More often it is empty. Unfortunately, empty or not...

Even modifying the code to open the report twice hasn't helped. I'm going to try building in a time delay. I saw somewhere that this might give the chart a chance to pick up on the query.

From searching this forum it will be no surprise to learn that I have some charts that are not updating reliably. Even worse it's an intermittent fault, sometimes they do, sometimes they don't. I have placed a requery command when the report opens, when the section containing the chart formats...

Cool, thanks.

I want to turn this set of fields returned from a query :- 'Stage'-'Engineer'-'BDE' A-a-e A-b B-c-f C-d Into this result by merging the fields 'Engineer' and 'BDE' :- 'Stage'-'NewField' A-a A-e A-b B-c B-f C-d Something like [Engineer]&[BDE] just joins up the text which isn't what I...

Thanks for your help yesterday. I have managed to work around the problem ( I think ). If intnewrec = False Then RequestedID = DLookup("[UniqueID]", "tblDataMIC", "[Title]='" & RequestedRecord & "'") NullCheck = IsNull(RequestedID) If NullCheck = True Then...

I'll give those a try, thanks. I think though that I've nailed it down to the DoCmd.FindRecord statement - even without all the previous blurb this statement does not find a record containing speech marks. The DLookup appears to be doing its job. Maybe I need to find the record using DLookup (...

The following code works great and is designed to tell the difference between finding a record or not :- If Not IsNull(DLookup("[Title]", "tblDataMIC", "[Title] = '" & (Me.ComboTitle) & "'")) Then DoCmd.FindRecord RequestedRecord Else Me.Title = RequestedRecord...

Yay, 104 lines of code down to 4, thanks. :)

I have a table that contains financial data on projects. Each project has one record consisting of numerous fields. I want users to be able to archive off copies of these records at certain points in time so I can track the financial data - a bit like storing different versions or issues. On...

Ah, so you can. Thanks. I've had a go but for aesthetic reasons have decided to stick with the small buttons.

Not so much solved my own problem as dug a bit deeper and found what seems to be the real issue - and it's nothing to do with <autonumber>. I am trying to use a stacked column chart to display a stage-gate process. There are 5 stages to this process and numerous projects that can only be in one...

Is there a way I can enlarge the size of an option button ? The default seems to be a little bit on the small side and I've had some user complaints that they don't use the option button because they don't see it.

I don't know if this will help but I had a similar scenario in one of my charts recently. The chart displays the total net value of projects as they pass through 5 stages of a process. I needed to show the entire process / all stages regardless of whether there was a net value. I set up 2...