Recent content by kc5747

I get this error You entered an expression that has an invalid reference to the recordsetClone property.

The form isn't blank until the command button runs on it so I have to have it under the event: Tried this but it doesn't work: Private Sub Dam_search_Click() On Error GoTo Err_Dam_search_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "MainForm"...

I have one main form and different queries that populate it depending on which command button is clicked I want a message box to pop up if no records are found. Here is what I have for one of the events: Private Sub Height_search_Click() On Error GoTo Err_Height_search_Click Dim stDocName...

I need to create one main form and have the user click command buttons to run diffrent queries on the same form (1 at a time).

The mailing list are in one table and the address name info is in another table called maindata list that is were they use the mailing list 1,mailing list 2,mailing list 3 fields which lookup a field in Mailing List table.

This Dbase is to create and manage mailing Lists and names address of the people on them. Right now there are 84 different ones the users must be able to add delete or modify the mailing list and their info. The user has to be able to add company, people’s information and they can be on up to 3...

I modified the WHERE state like this strWhere = " WHERE [Mailing List 1] in (" & Left(strIN, Len(strIN) - 1) & ")" Or "WHERE [Mailing List 2] in (" & Left(strIN, Len(strIN) - 1) & ")" Now I amd getting an error of type mismatch?

All the people in the MaildDataList were the name address and such are can be in up to three deffrent mailing list. (mailingList1,mailingList2,mailingList3) But their are 85 diffrent mailing list in the mailing list table. So John Doe is on abc mailing list and acme mailing list and flower...

I have a table with 3 different fields in it they all are mailing list (mailing list 1, mailing list 2, mailing 3) I want the listbox to look at all 3 fields to see if the selected names are in any of the three boxes like if veo retirees was in mailing list 1 or mailing list 2 or mailing list 3...

I got this code to work on Mail List 1 field but I need it to search 3 separate fields for the names selected in the list box (Mail List 2 and Mail list 3) can this be done? Private Sub cmdRunReport_Click() On Error GoTo Err_cmdRunReport_Click Dim MyDB As Database Dim qdf As QueryDef...

I have a database with a listbox on a form when they double click on a selection in the list box it runs a query. But if I try to select 2 selections I get nothing how do I have the query look for the 2 separate selections and not think they are one name.