Search results

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...

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 class on_click class module? Please help. Thanks

I was wondering if I use a Sum function in the footer of a FORM for one of the fields, should it sum all the values in the table for that field? I assume so, but it is not working!! [ext_total]<-- field in record ------Footer ------ sum([ext_total]) Then should I get the sum of all the...

Hello, I am stuck trying to solve this problem with access. I am creating an invoicing system. In a regular invoice, there would be multiple lines of different products that are purchased ( ie qty, item number, description, price, extended total). I created a form to hold all the customer...

Thanks but no help yet. Let me try to be more clear. I only want one of my tables to be reset to 1. I can remove all records if thats necessary. It is a autonumber data type and it is the primary key. I am storing customer ID with autonumber sequentially. But for some reason, it is...

Hello, I am pretty sure if I use a query I can do this, but I was wondering if there are funtions that allow me to access the data fields from other records in a table.