Recent content by Mal Ba

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.