Search results

See the attached. I have a report which has a picture in the Report Header (it simply shows the UK divided in to regions). Below that the Detail section lists all the information relating to each region in three columns with two fields in each. (The data in the attached snippet is random for...

That's what I had actually done as a temporary measure. I rather hoped it would be possible to do it using the ImageControl which would then have refreshed automatically as it does for tables rather than having to code it up.

For an unbound object frame what is the format of the .SourceItem property? I have a chart in an Excel file which I am trying to reference as the source. The chart is a Sheet called [Graphs] and the chart named is [Chart 1] SourceDoc = C:\Users\Mal\Downloads\MapTransfer.xlsx and I can't see...

Thanks. That was stupid of me. A while since I have ever needed to look at macros.

There is no event procedure. And it happens on every event. Here's a snapshot from an entirely new blank, unused form with no objects, code or anything else

I know they are deprecated, but in the current version of Access I have (version 2104 Build 13929.20016) there is no such option. If I go into any property sheet and click on the down arrow against a property, the only option I get is [Event Procedure]. I am certain there used to be a [Macro]...

Trying to do this with a slightly better control over what is printed than using DoCmd.PrintOut. So was attempting to use: DoCmd.RunCommand acCmdPrintPreview This fails with the run-tie error 3270: Property not found. Why would that be? Mal

I've been suggesting it to Microsoft for ages. As you say it is a fairly well-known feature elsewhere. You can even do it in vb.net. But I think Access is very much the poor relation in the Office suite. The best you can do is to create a combo box with a listbox below it - or on a dialog...

I'm sorry, it is so difficult to be clear. I tried to do so by saying IF not AND. If I put the expression in as assigned directly to the property, it works. It does not work if I assign it via VBA. I am never trying to do both (why would I?). If I assign it by VBA I doing so with the...

Thanks for that, sounds obvious, but I hit a problem. If I try to assign a simple binding in the Report_ Load event like: Me.Controls(i).ControlSource = "[Year1]" where [Year1] is the field in the recordset, it works fine. If I put a formula into the ControlSource directly as a...

Definitely not working for me. It is odd, because I would have expected it to. I've now found another instance of a person on the web having the same problem with Access 2016 (though I am using Office 365) and an example on https://www.accessforums.net/showthread.php?t=72751 . Neither...

We are talking about an Access Report. I'm not using Excel at all. I'm trying to re-create what is currently done in Excel in Access. The pivot table is created using Access and SQL. Simplifying the names, it looks like this TRANSFORM Sum(1) AS [Value] SELECT T.Name FROM LYS INNER JOIN (E...

You are being so good to me I thought I try your patience with another problem. Basically this whole thing is trying to convert something which works sucessfully in Excel into Access because you can't adequately lock down the tables in Excel to prevent people being silly. I'm sort of most of...

Nice idea and thanks, tried it and it makes no difference; still doesn't register make the CF work. I'd also tried comparing it with 0 and "0" as well as null but still it doesn't do anything. Putting the CF into a separate control seems to be (oddly) the only way.

No. Both work. I also tried both, just in case.

Nice thought. I discounted that because, whilst the records are in the same order on both views, different items are missing and if you look at the Report View.JPG there are clearly items following one another that are duplicates. However on checking I did find that Hide Duplicates was set and...

That's what I have done. See the post directly before yours, where I said I'd done that as a work-around. Work arounds shouldn't be needed though especially when one doesn't know why: I guess it does think the formula is too complicated. Maybe something to do with the order things are...

I have a report based on a moderately simple query. The datasheet for the query in the report's Control Source shows all the data correctly. However when I run the report based on this query, various entries in various records are missing. So for example, whilst all the records are shown...

Addendum: If I delete the formula: =IIf([2018-19D] Is Null,"0",[2018-19D]) & "+" & IIf([2018-19S] Is Null,"0",[2018-19S]) from the Control Source property of the control, the conditional formatting works. With the formula in the control, it does not. The work around I have used is to use a...

I was: the conditional form is applied to the control I want to highlight [Flag] not the one I am checking. I am putting the Expression CF into the [Flag] control which I want to highlight. The Expression being used is: [2018-19D]>0. Regardless of the value of [2018-19D] the conditional...