Recent content by slndn

I have created a report that includes 4 subreports. The subreports are displaying survey results from 4 different survey channels. New survey data is added to the tables monthly so the subreports will grow in size. Is there a way to have the subreports automatically resize and push down the...

Thanks, Paul. Do you know how I would go about finding the backup?

For my details button (which is supposed to open a form from a list of records) it does say Event Procedure in the "On Click" area and this is the code that is listed: Option Compare Database Private Sub cmdDetail_Click() End Sub Doesn't seem like a lot of code to me but I am not well versed...

I do have all macros enabled in the trust center.

I recently upgraded to Access 2007 from 2003. The upgrade was in June and went smoothly. I added a couple of drop down boxes to my form in August and that seemed to have gone fine as well. Suddenly, at least two weeks later, my form buttons are not working. I added the pathway to my database...

Okay, thank you for that explanation. I used the *Me. tool and realized that ApplicationStatus is not in the list of controls for the MIS Form. This combo box exists in my Applications Form. I'm guessing that the original designer wanted the Application Status to trigger some sort of...

Okay, that seemed to work for that line of code. When I compiled it ran and found the following error in another section. It says that cboApplicationStatus is not defined. Does this have anything to do with the changes we just made? Public Sub SelectRecords() On Error GoTo Error_Handler...

That did work thank you!!! But now the same error in the code below. It is the FindFirst issue again. I believe this is the only new record command left that could cause the issue. I'm sorry this is such a mess. I'm not sure how this happened. Private Sub cmdNewRecord_Click() On Error...

Okay, I changed it and it is still getting stuck on FindFirst. Here is the code. I really appreciate your help! Private Sub cmdNewRecord_Click() On Error GoTo Error_Handler Dim rst As Recordset Dim strDocName As String Dim strLinkCriteria As String 'Open form to new...

This is the only reference I can find to Dim Dim rstAppl As Recordset Dim strDocName As String Dim strLinkCriteria As String

ApplicantID is a field in the form that populates the ApplicantKey field in my table titled tblApplications.

pr2-eugin - I don't know how to do what you are asking. Is this in the properties of the form? My recordset type currently says Dynaset.

Should the entire strLinkCriteria be changed to ApplicantID or only tblApplicants01.ApplicantKey? I'm assuming you are referring to the third line above the FindFirst line. Thanks so much!

I am receiving the Method or data member not found error message when I attempt to add a new record in form view. I have been working in an old 2002-2003 version of Access until last week when it was converted to 2007. The old version allowed for additions just fine but now after the...

I will watch the demo and let you know if I have any other questions. Thank you both for the response!