I have an option group on a form that is meant to filter a report. The SQL in the RecordSource refers to a control on this form. I get the report to run fine with the radio buttons that only filter by one criterion, but I can't when I need multiple criteria. For Example, Option1 puts a number...
I have two users whose Outlook Inbox suddenly stopped syncing with the Exchange server. They both use Outlook 2003 in cached mode and we use Exchange server 2000. The other seven users' Outlook works fine under the same setup, and these two users with the problem had worked fine up until this...
I have a form that creates new records in which the ID needs to be inserted into another table. This form was working fine until we started using replication. I took the easy way out and used the Max() function to get the newest entry. My question is, is there a quick way to get this...
I'm appending data from a form into a table. The code works fine without trying to add the date, but when I try to add the date, I get the syntax error.
CODE:
Private Sub cmdTarget_Click()
Dim strSQL As String
Dim strSQL2 As String
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim rs2 As...
I have a New Call form that creates a new Activity and has a subform to enter in details related to this activity.
I'm trying to get the subform to list active opportunities and be able to enter details for each opportunity for the particular Activity at hand.
tblDetails
-----------
ID...
I get this error when invoking the click event from the subform.
This is the code in the click event.
Me.txtActivityID = Forms![Fmast_ContactTabs].Form.CSP_T_TeamActivityLog_ID
Forms![Fmast_ContactTabs].Form.subDetails.LinkChildFields = "txtActivityID"...
I have a data entry form with a subform. The main form is used to enter the Task information while the subform is used to enter and list specific details associated with this new task. The subform is a continuous form that will not show any records at first but will allow new details to be...
How would I refer to the caption of a button that was just clicked?
I would like to set a variable to the caption of cmd button in the click event of said button.
Thanks in advance, my mind is in the wrong place today.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.