Search results

Rich I totally understand. You may have a great point, I am interested. Could you expand?

Please be patient, I am a new VBer. Here was the issue: The two forms that I am using are coming from the same table and record. I was getting an write protected error and I found a thread that said use that code to help sovle it. Indeed it did, but maybe I need to use something else from what...

Thanks, I will give that a try. I do have two fields and that is probably the problem. Thanks again, sam

Here is the code that I am having problems with: Private Sub Result_AfterUpdate() Dim stDocName As String Dim stLinkCriteria As String DoCmd.Save acForm, "Customer FRM" If [Result] = "APT" Then DoCmd.OpenForm "AppointmentDate FRM", , , "[ResultsID]=" & Me![ResultsID] End If...

I have a subform that if the selection "APT" is chosen from the combo box it pulls up a pop up form and you enter the date. All of this information goes into the same table. Here is my problem, after I enter the date on the pop up form and return back to the original form it tells me that I have...

I have a main form and a subform and here is what I am wanting to do. On the subform I have an unbound text box. I want to say, If ALL the "Completed Dates" on the subform for this record are <>0 then "Workorder Done" otherwise "Workorder Open". I just having trouble getting it to look at ALL...

Is there a way to take a access application and put it in VB and make it a free standing program? In other words, cut ms access out of the picture so that the program could be run without office? Any help is welcome.

Is there a reason that you could not put this in the header or footer. It seems that it would work for what you are wanting. HTH

I have an unbound field on a subform (Orders) that is refered to another subform (Payments). After updating the subform (Payments) I can't get the unbound field to update even when I use Me.Requery in several fields. These subforms are on a tab control. If I put a refresh button on the Orders...

I put the dummy button on their and also put the code on the after update event and after tabbing back and forth twice and pushing the button it works. But is there a more convenient way?

Thank you so much. I will give this a try and see what happens.

I have a main form and several subforms on tab control. After I enter a payment on my payments subform it won't update on my orders subform when I tab over. I have tried putting the me.requery in the after update and on activate, but not one thing is happening. No one will help me with this...

When I use tab controls on my forms what exactly is the "On Event" when I switch back and forth between forms. I am needing to put code in the event and I have tried On Activate, On load, On Got Focus, but so far nothing has responded.

I put that in there, but I am just tabbing back and forth between the tabs. It won't refresh for anything.

I have a main form and several subforms on tabs and need to do a blanket refresh after updating a subform. How would I go about this?

Try this: mailto:emailaddress?subject=putsubjecthere.

I have battled this for days so I hope someone can help. I have a main form customer FRM and several subforms on a tab form. I am needing the orders frm to refresh after I enter a payment on the payment frm. These are both on different tabs and I have put the me.requery in almost every on...

Well, this works just like it is supposed to but here is the problem. I added an unbound field and called it txtphonenumber and ran the code. If you say yes on the dialog box all it does is fill in the txtphonenumber with the same number. Is there a way for it to pull up the whole record of the...

Thanks, I will give this a try and see if I can get it to work. I may require a bit more assistance because this looks like some code that I tried yesterday and failed everytime. But maybe my luck has changed and it will work perfectly. Thanks again.

Yes, that is exactly what I am looking for. Please excuse my lack of vb knowlege, but could you help me with pull the record set? That is where I am stuck. Thanks a bunch.