Search results

I have the following code: Private Sub Form_Current() Dim ANS As Integer ANS = MsgBox("Click on the button to generate a monthly report of followup items to be completed", vbOKOnly) If ANS = 1 Then DoCmd.OpenReport "rptFollowups", acViewPreview, , "[IActToBeDt] = Date()" End Sub...

When a user opens up the database, I want pop-up notices to appear telling them who they need to follow-up on. For instance, there may be 10 people that need to be called or have letters sent to on a given day. I want ten messages to pop up with each person's name and what needs to be done...

On the contrary, I don't feel like anyone is ganging up on me. I consider it part of my learning experience. I welcome any suggestions as I am still a novice when it comes to Access and VBA. I am going to the sites that Pat recommended right now.

Because each subject that we recruit for our study will be required to make multiple visits within four different time points. During these visits they will fill out multiple forms and take multiple tests, which are unique for the most part. For each form or test, we need to know the date, who...

Because I needed to define more than 255 fields for my form, I created 3 tables and used a query to bring them all together. This query is the source of my form, which has a tab control. When I tried to bring up the field list to design my form, it balked saying, "Too many fields defined." My...

Thanks for the suggestions. I resolved both problems! Instead of putting the DoCmd. in the OnClick event, I used Switchboard manager and chose the option to run macro when that particular button is clicked. The GoTo Control was what I needed.

The problem with that is that I have layered switchboards. When I look at the switchboard in design mode and go to the on click event, it already has the following in there "=HandleButtonClick(2)". In any case, when I replace it with the setfocus, it messes up the button that is on a different...

I have two problems related to Tab Controls and Switchboards. 1) When I open up a form with tab controls from the switchboard, I am not at the top of the page (i.e., I cannot see the tabs). What can I do to see the true "top of the page" when I open up a form? 2) From the switchboard, I would...

The error messages that pop up are not user-defined. Can I build an event procedure on the "okay" button that is generated by Access?

This is probably a simple matter, but I cannot figure it out. I have a data entry form with text boxes. The validation rule option has been defined for each text box. When the user enters incorrect (i.e., invalid) data, an error message pops up that is driven by the validation rule. After...