Search results

Christian Slater - Alone in the Dark

Here is a copy of it, as the original has already been split in FE & BE with an associated workgroup and passwords etc.

Our Contacts database holds records relating to individual clients. As these clients are visited in their homes, I have put a "Lone Worker Caution" yes/no field on the form to alert staff of potential risks prior to visiting. To have a more visual signal to staff, I have placed a label...

Hi, Our Contacts database holds records relating to individual clients. As these clients are visited in their homes, I have put a "Lone Worker Caution" yes/no field on the form to alert staff of potential risks prior to visiting. To have a more visual signal to staff, I have placed a label...

Thanks, but I'm still having problems. I have Label202 on the form set to visible:no. I have a yes/no check-box with the following code: Private Sub LoneWorkerCaution__AfterUpdate() If Me.LoneWorkerCaution = True Then Me.Label202.Visible = True End If If Me.LoneWorkerCaution = False Then...

Keira Knightley - Bend it Like Beckham

I'm having real problems trying to implement this, I think I'm in way over my head with the VBA stuff, don't understand it at all and am just cutting and pasting. WOuld anyone be willing to have a look?

I'm trying to change the format of the yes/no check box, but "conditional Formatting" is greyed-out

I've also noticed that even though I've ticked the check box against a single client, the Lone Worker Warning label becomes visible against every clients record.

Okay, I've put a label on the screen with text "Lone Worker Warning", and set it's properties to be visible:no. On my Lone Worker Warning yes/no check box I've set the properties of on click: to be the event procedure: Private Sub LoneWorkerCaution__Click() Label202.Visible = True End Sub...

Is there a specific sample you know of?

Hi, Our Contacts database holds records relating to individual clients. As these clients are visited in their homes, I have put a "Lone Worker Caution" yes/no field on the form to alert staff of potential risks prior to visiting. However, this doesn't offer enough of a visual signal to staff...

Thanks for that Curtis, I have applied the code to the AfterUpdate, but when I type into the field now I get this message: "Database can't find the macro '[fieldname]=StrConv([fieldname], vbProperCase)'. The macro (or its macro group) deosn't exist, or the macro is new but hasn't been saved...

I have a contacts database set up to record all our charities' clients. I have set up the relevant fields to force first-letter capitals for their first name, surname and so on, but how do I do this for their address, where there can be a mixture of numbers and text with spaces in-between (i.e...

I need to do this too. I've searched "Audit Trail" but cannot find what I need. Any ideas?

I've set up a command button on my form in my Contacts database to carry out a search (I used the built-in Wizard). The command button invokes the Find & Replace function, which works perfectly well, but is there a way of refining it so that the search dialog box opens with "Any Part of Field"...

Sorry, but I'm a novice at this and don't know what I need to do when I get this error message. Can anyone help me?

That works! Brilliant! Thanks.

Thanks Bob, The code behind this button is now: Private Sub TalkingBooksUsers_Click() On Error GoTo Err_TalkingBooksUsers_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Talking Books Users" DoCmd.OpenForm "Talking Books Users", acFormDS...

Hi Lagbolt, Thanks for the input but I'm afraid it isn't working. It now returns the error code 438 "Object doesn't support this property or method". Any ideas what else I could try?