Recent content by raychoy2k

Thanks guys. I later discovered that IsNull is the one I wanted. My problem is not knowing what to do, it is knowing what is available in Access and learning the new syntax. All suggestions were a lot of help though. Thanks!

Kind dumb question but, how do I test for empty text boxes in VBA? I am using the following code to do this, but it does not work. Should I be testing for empty string ("") or NULL? I tried both and it doesnt work. If Me![Phone] = Null And Me![name] = Null Then

You were right Pat!! Thats pretty good! It was an orderby property in the subform. I don't know how you knew. Can you explain why that happens?

But the Form opens fine when I open it by itself. I will check your suggestions.

Sorry Pat, I don't really know what you mean. It is not a query or anything, so I don't see where an order by would come into the picture.

Here she is: Private Sub Command3_Click() On Error GoTo Err_Command3_Click Dim stDocName As String Dim stFilter As String Dim stLinkCriteria As String stDocName = "Client Contact" stLinkCriteria = "[Phone]='" & Me![Text0] & "'" DoCmd.OpenForm stDocName, , ...

The delimeters were correct for the original. However the one JF suggested was just shorter. But, the problem still persists. I think it is because I am applying a filter to the main form, but the subform requires some kind of filter criteria too, in order to open properly. But even when I...

Yo JF, you are right. I think that should work. Let me try. I feel stupid for no thinking of that one. I did a refresh with the OnActivate on the original form instead. It doesn't use a query, so a requery will not help in this case. Thanks for the suggestions though.

I have a form that opens a popup, then when the popup is closed I would like the form to refresh so it can reflect the changes made. (The popup makes changes to the subform in the original form. It would be nice to have it refresh and show new changes one I go back to the form) I tried...

I have a form called "client contact" with a subform called invoice. I am using VBA to run a filter to find specific contacts. When I run the below command: stDocName = "Client Contact" stLinkCriteria = "[Phone]=" & "'" & Me![Text0] & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria A...

Hello, I was wondering how do I add a new record to a table and fill in the field values in VBA? Any help would be greatly appreciated.

Hello, I am opening form2 from form1 using a command button on_click() procedure. How do I temporarily change the properties of form2 to make it a popup form from the form1 on_click class module? Basically, I just need to know how to change properties of other forms in VBA. Any help would...

come on, I'm sure somebody has an answer to this.

because I would like it to look like a popup form temporarily. Then when I close it, I will change it back.

Another newbie question : ) If I open a form and make one small change in any field, the record is saved to the table. How can I add a command button to undo all changes and not commit the changes to the table? Basically, I want to be able to cancel everything and not add that record to the...