Search results

I hit the check box to tag the item. Went to another record, came back to record, and then hit tag again to untag the record. I just tried it. Attach is the db.

It does not have a calculated Control Source, but I revised the code to txtCompanyTaggedExplanation; it was CompanyTaggedExplanation. Now I get the following error message: The data has been changed: Error Number: 7878

You can't assign a value to this object. Error number: 2448

Oh boy, after adding "DoCmd.RunCommand acCmdSaveRecord" now I am getting Error 2448. Should I write this code another way?

Aaaah, more reading. Thanks! Oops, get the following error when I click on the link: "Oops! Google Chrome could not find www.vb6.us"

This entire statement? Call MsgBox("An error was encountered" & vbCrLf & vbCrLf & _ "Description: " & Err.Description & vbCrLf & _ "Error Number: " & Err.Number, vbCritical, gstrAppTitle) Are just the word "Call"? If so, does it matter? Because I read somewhere you...

Forms!fdlgCompanyTaggedExplanation!CompanyTaggedExplanation.Value = Null DoCmd.Close acForm, "fdlgCompanyTaggedExplanation", acSaveYes Me!lblTagged.Visible = False Okay, I was thinking that the above code would: 1. Clear the field "CompanyTaggedExplanation" of...

Not understanding the above. Are you asking me if the IsFormLoaded function working? Are you saying Call need to be removed or the entire statement?

Got it--makes sense. So, the code is okay, huh? I don't need to add "requery the main form in the After_Update event of fdlgCompanyTaggedExplanation.".

I am not getting the error message now. Below is the code I am using: Private Sub chkCompanyTagged_Click() On Error GoTo ErrorHandler DoCmd.RunCommand acCmdSaveRecord If Me!chkCompanyTagged.Value = -1 Then Me!lblTagged.Visible = True DoCmd.OpenForm...

Because the label will change per record. If record 1 is checked, the label is displayed. If record 2 is not checked, the label will not display and so on.

In my table I have a field called CompanyTagged (yes/no data type) which I am using by tagging companies indvidually. And a field call TaggedExplanation--where you can jot down a note why you tagged this record. If the checkbox is checked it will display a label with the word TAGGED and bring...

Me.Name did the trick. Thank you very much!

Is there way to paste the name of the form automatically in code? Below is the code I am using: On Error GoTo ErrorHandler ' Make sure fdlgEventDetail is open If Not IsFormLoaded("fdlgEventDetail") Then MsgBox "This form ""fdlgEventNote"" cannot be open from the Navigation...

Okay, got it. Thanks for the quick response!

Yep, that's what I was trying to say.

Once again vbaInet, thanks a lot! When you see the actual db it makes a big difference. Now, I feel like I accomplish something for the day.

Went back over it. Now it makes sense. It's working. Whoa, that took a while. Now I can get a few zzzzzz. Later. THANKS!

I'll look at it again tomorrow are around noon--I am too tired--and it's in th wee hours--got to get up in 6 hours and start it all over again.

I don't want to add another table or revised the table and try to explain to someone else why I am doing this when I really don't know. Using the text box with this code in the ControlSource works: =IIf([EventAttachment] Is Not Null,".",Null) I don't know why doing the same in the image...