Search results

So, if I close Form2 the value is no longer available. Meaning, if I choose an item from a combo box and I tell the Pop up which is Form2 on closing to do: Forms!Form1!txtDesc = Forms!Form2!combo1.column(1) that when closing the forms that information put into txtDesc will be lost.

Okay, I'm looking at your website on OpenArg. Is OpenArg a technical term of MS? I'm not getting it. Is it like saying "Open Form1 and put Renee in FirstName field?

Okay, I did it like this: If Me.NewRecord Then Me.lblImage.Caption = "NEW RECORD---Add Attachment (y/n)? " Me.cmdImage.Visible = False Me.txtYesNo.Visible = True Me.txtYesNo.Left = 2438 Me.txtYesNo.Value = "N" ElseIf Me.ActivityID = 1 Or...

Good link above. I see what you mean because I left out: Cancel = True

I can't believe I did not see that; I was thinking to click BeforeUpdate so it could check to see if these fields are filled out and so on and then save. Thanks!

No, I tried it in class and followed instructions but I don't understand it where I can use it. I really would like to know how to finally get it--understand it.

I am trying to change from using three labels on my form to one label. 1. If this is a new record, the label will say “Add Attachment (y/n)?” and the text box will have a Default Value = Y. 2. If not a new record and Activity ID is not equaled to 1, 2, or 23 then the label will say “Add...

I am trying to say that if cboSource or cboWorkType is null, display a message and then go back to the field on the form that is null. Problem is, the form closes displaying the message. Below is what it is doing: 1. I hit OK button to close form 2. Message box displays saying cboSource is...

I see stuff like "use your openArg to do this or that," which I didn't know what openArg meant. You explanation is a littler clearer. I'll read it again tomorrow and hopefullly I'll get it better. It's been a long day. Thanks!

Wow, looks 90% better. I was thinking select case but I thought I would have to do a Case for each record. Thanks a bunch!

Is there a cleaner or shorter way of writing the below code? If Me.NewRecord Then Me.cmdDetails.Visible = False Else If Me.cboActivity = 3 Or Me.cboActivity = 12 Or Me.cboActivity = 13 Or Me.cboActivity = 16 Or _ Me.cboActivity = 17 Or Me.cboActivity = 18 Or...

Ok, go ahead and laugh but I'm going to ask anyway. Is openArg the acFormAdd? Is that like saying when opening the form put it in date entry mode (add mode)?

Okay, you're correct. I forgot about that; I just read about the "bang (!)" versus "dot (period)."

Yep, I did. Their stuff is too technical for me. Anyway, no big deal on this one bc the forms work like it is. I was looking for a quick solution.

Ahh... always that little something you put in or forgot to take out. Thanks, it works!

Can you change the Caption property of a form while opening the form from another form? I know Me.Caption works. I am trying: Forms!fdlgEventNote!Caption but get this error message: Error Number: 2465 Description: Microsoft Office Access can't findthe field "Caption" referred toin your...

I have an add form called fdlgEventDetailAdd and an edit form called fdlgEventDetailEdit, which is different. Then I have a note field in a separate table called fdlgEventNote. I created three forms for the note field because of the Default Value, which are below: fdlgEventNoteAdd --- Default...

Yep, that's correct.

I understand what you're saying, but I don't have that control. I get a lot of stuff done by the secretary and a few by the attorney--who is the client--you get it. They've taken classes and many have used MS templates so going there with them is like going no where. They don't want you to...

That's what I started off with--frmCompany2, and that's what they hate. The like the style of frmCompany.