Recent content by Donamese

Sorry...Query->SQL Specific->Pass Through was the one I was wondering.

Can I just click Query -> Select Query and save? Or does it not transfer to the new style clean?

When I run the query using the code from PHV, it populates a new column and doubles up the data in the query criteria. Initially it was entered as: Field: EESEXC Table: MKTGLIB Sort: Criteria: [Forms]![Lead]![Gender] OR [Forms]![Lead]![Gender] IS NULL I use a select query option for...

Perfect....thank you!!!

WHERE (((MKTGLIB_LEADGENRTR.EESEXC)=[Forms]![Lead]![Gender]) AND ((MKTGLIB_LEADGENRTR.AGE) Between [Forms]![Lead]![AgeL] And [Forms]![Lead]![AgeR]) AND (([Agent Info].[Agent ID])=[Forms]![Lead]![Agent]) AND ((MKTGLIB_LEADGENRTR.TERM)=[Forms]![Lead]![Term]));

I have a form that is feeding query criteria. There are 2 selections but I need a both as well. They are on the form in a combo box. Ex. Gender - Male or Female Terminated - Y or N I tried setting the default value of the combo box as [Query]![Field]In("Male","Female") but it came...

I have a database that pulls data from Query1 to populate the Lead report. What I am trying to do is create a form where I can enter criteria for the query (agent, gender, age range, and terminated or not). Once the query has the new criteria I need it to populate the report. Once created I...

There is an ID field

I am working with a form that has a button to print a record. It prints every record in the master table when clicked, but I only want it to print the last record. I am not sure how to code it....currently it is set as Private Sub Command42_Click() On Error GoTo Err_Command42_Click Dim...

There is a table with all the fields on the form. The Check boxes are seperated Banana, Apple, Kiwi, etc all have their own check box on the form and are each listed individually on the table. I have a simple query that is linked to the table, then the form is linked to that query. The text...

I have a form which uses check boxes for items which marks items as a check list. The check boxes link to the master table. I am trying to create a report where if the box is checked then the text on the report will say a given line other than the standard yes/no or true/false. Form (with...

I have a form used for call monitoring. It has 2 buttons, one to "save" which sends information to the master table then clears the form for a new entry; then the second button to print the form. When entries are made they get printed then saved. However, when you click the print...