Search results

Ironically, ContactID /doesn't/ have a space, although many other FN do. so that wasn't helping, but Gasman suggested the actual problem. The report works fine when called in a different way, as has been the case for many months.

Spot on! I've illustrated the dangers of using something that already works in one situation, but now in a different way, and 'coming a cropper'!

I'm using this code to open a form in print preview: Private Sub cmdPrint_Click() Dim strWhere As String If Me.Dirty Then 'Save any edits. Me.Dirty = False End If If Me.NewRecord Then 'Check there is a record to print MsgBox "Select a record to print"...

When docked, It only occupies about 1 cm of screen space, so that doesn't bother me really. Is there a useful (3rd party) alternative?

Good to know I'm not alone in my dislike of it. I suspect there are better and worse ways to handle it, which I need to learn.

Overlapping windows is what I want, and you've shown me [with the link] how to get them. Thanks! The last time I was deeply involved in Access it was Version 2000. Things have changed! (I think I hate the navigation Pane, but maybe I haven't yet learned to use it properly.)

How to Restore a window within Access so I can view two side by side.? I'm stuck with only seeing the selected one in this view: i.e. there's no Restore icon next to the X to close the window. Am I being stupid? (It's no different when the main Access window is maximised.) Thanks. PS Sorry I...

And I can, of course, put Outlook offline to stop them being -sent, when in the Outbox. :)

Yes, of course I could, and lose the option to spot check them b4 they go. (I'm still a bit nervous in case the wrong info goes to the wrong people.)

Yes, I used IIF() elsewhere to hide a label when a textbox was null:- =IIf(IsNull([Committee Role]),Null,"Committee Role") (y) Thanks for the further detail. In this case, apart from my testing, this is only done once a year in anger, so speed is not much of an issue! This code I'm using does...

Ah! YES! I forgot to check the print preview (DOH) This works: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.Text35.Visible = (Me.ContactTypeID <> 25) Me.Label38.Visible = (Me.ContactTypeID <> 25) End Sub Many thanks everyone.

--- NB: I'm trying to hide the IAM No 12345678 under my signature, but only when Status shows Group Friend [not member]. GF is [Contact Type ID] = 25 so i think the code above is the opposite - showing when [Contact Type ID] = 25 do I need to ensure the control is visible the rest of the time?

Short answer is I don't konw because I've inherited it from someone much more a user than me. But I haven't had the time (or effort!!) to sort it out. There's a lot which is sub-optimal! But no, the table is decent:- example rows [no drop-downs]

As things stand, when I go from design view to report view, it shows as continuous. Maybe htat is a particular case? I'm trying to hide the IAM No 12345678 under my signature, but only when Status shows Group Friend [not member]. GF is [Contact Type ID] = 25 the control source for the combobox...

Right, good, with you! Thanks. Thanks. I'll come back to this in a few minutes.

Thanks for all the above, but can you explain this bit, please?

Sorry, everyone, this is on a REPORT, that gets turned into a pdf, and emailed. If that makes any difference (mainly in the choice of events, I suspect.)

as the control source for the rectangle, but Access says no:-

I've successfully used IIF() to hide a label to a textbox when the latter was null. but now i want to hide both textbox and label when the info being displayed is unwanted/inappropriate . This occurs when [Contact Type ID] is 25. (not my choice of field name with spaces!) There are probably...

" ...that is where the real learning happens!" I've learnt that elsewhere in life, that you learn a lot by teaching. (y)