Recent content by McRoberts

I am having the same problem. Was there ever a solution to this? Thanks

It's not the button because if I try to run the macro from the database window it still will not work on the front end now that it is split. I worked fine before we split the database. It must have something to do with the macro but I'm not sure why or what.

I have a button on my switchboard that when clicked runs a macro that I have created to open my form in "Add" Data mode. It worked fine until we put the database on the network and split it to a front end and back end database. Now when you click the button on the switchboard the Detail part...

I have a main form (frmIandRSurvey) with combo box for Status (Yes/No). I have four subforms and on each subform I have a combo box (Yes/No) that has code on the After Update as follows: Private Sub Returned_Call_After Update() If Me.Returned_Call = "Yes" Then...

1. Client calls and some infro is entered in db 2. Staff ask if they can do a survey (Can't they perform the survey right then?...) No we need to give them time to see if the information that we provided was useful/valuable - approx. one week 3. If no then the record is closed, if yes, the...

I have a form for client satisfaction surveys. When an information call comes in it is logged in the form and we ask if we have consent to do a questionnaire. In my "On Current" Event of my main form and the "After Update" event of the Consent Obtained combo I have the following code: If...

I put it on my check box also and I am getting the same error. Here is the exact code that I am using: On Click of check box. If Me.Survey_Complete = True Then Me.tab.pages(2).visible = True Me.tab.pages(2).enabled = True Me.tab.pages(2).SetFocus Else Me.[B]tab.pages(2).Visible = False...

Hi and thanks for your response. I tried that code and the error is in .tab part of the code. It is not finding my tab control page when I am writing the code. I am putting this code in the On Current event of the subform in the tab control. Am I putting it in the wrong spot? I appreciate your...

I was able to use coding for making controls visible or not in the attached database. I have a main form with a tab control that has 3 tabs with subforms in them. What I am not able to do is in the Tab Control I want the 3rd tab to be invisible and on the second tab where it says “May we go...

Hi All, I have a main form and 5 tabs within that mainform that are subforms. They are linked by an EventID. The subforms are continuous forms, but only one record is "required". What kind of code do I need to make sure that the data entry person enters at least one record in each subform...

That worked. Thank you so much for your help. It is a relief to finally move on. What do you mean by "There are some other issues with which you will have to deal". I am new to Access and thought that I was doing okay but would appreciate whatever advice you could give me.

When I am in the subform I do not get that message but the cascading combo box is not working properly. It doesn't bring up the appropriate event types for the selected Event Category.

Yes, this is in the database that you posted.

Now the cascading combo box doesn't seem to work. When I choose the Event Category then click on Event Type it says Enter Parameter Value. Thanks for your help.

I have created a dummy database that is similar to the one that I am having problems with. I have attached the database so that you can see what I mean. You are right that it is dirtying the record but I don't know why. Can you take a look at it?