Search results

Kind of confusing but here it goes: The form is a search form with a subform. When I search through the subform...I change the RecordSource. When I search through the main form, I use a filter. Well the problem arises after I do a search through the subform I can not search through the main...

Kind of confusing but here it goes: The form is a search form with a subform. When I search through the subform...I change the RecordSource. When I search through the main form, I use a filter. Well the problem arises after I do a search through the subform I can not search through the main...

Hi, I can not search in my mainform after I do a search in my subform. After I perform a search in the subform and I try to search the mainform, I get a no records message box that I created because it can't find any matches EVEN THOUGH there are matches. To solve this I have a reset button...

When I perform a search with a certain condition...the search works, but a message box pops up stating: Syntax Error (missing operator) in expression But the search works. So what I want is to just get rid of the message box. I tried setting the warnings to false. I also put the code...

Just a simple problem that I can't seem to figure out. Background: I have a form and I have option to add a new company. Then when the user gets done filling out information they need to press Save. But the problem is that sometimes a blank record is saved... So what I thought was that...

I feel really dumb asking this question because I feel stupid right now. I have Accounts that are Active and Inactive. In a form, however, I want to only show Active accounts. A invisible combo box in the form called cmbActiveInactive shows whether or not the Account is Active or Inactive...

Hi, in my main form I have company information (Name, Address, City, State, etc). I am searching a subform. My subform contains Contact information (First Name, Last Name, Title, etc). I searched for several weeks on this issue and I have had no success. This is my code: Dim strSQL As...

I searched Google and this forum for the answer, but I didn't find it. I have a combo box 'cmbDisposition' in a subform 'LeadInformationSubform'. When the user choses "Won" from the combo box, I want a button 'btnMoreInfo' in the mainform 'AllRecordsSearch' to be enabled. If the combo box has...

I know this has been brought up, and I have tried EVERYTHING to solve this problem, but it still wont work. I have tried DoCmd.OpenForm "SalesWon", , , "LeadID = " & Me.LeadID but I might be doing it wrong. I dont know. Open Add/EditRecords And if you go down to the Lead Information section...

I am receiving an error message: Compile error: User-defined type not defined. I am trying to make a message box appear when there are no results. Here is my code: Private Sub btnSearchContacts_Click() Dim strSQL As Variant Dim l_strAnd As String Dim RS As DAO.Recordset Set RS...

I want to add a message box when there is no records found. Here is my code: Private Sub btnSearchContacts_Click() Dim strSQL As Variant Dim l_strAnd As String If (Me.txtSearchClientID & "" = "") And (Me.txtSearchFirst & "" = "") And (Me.txtSearchLast & "" = "") And...

I want to create a new message box saying there are no results when no results are found using the search using DCount(). I need someone to show me how to do this. My code is: Private Sub btnSearchContacts_Click() Dim strSQL As Variant Dim l_strAnd As String If...

Open Add/Edit form. And if you use the search function click on the Contacts tab and type in Smith in Last Name. What I want is when the user types the last name and finds the last name, I want that record that matches that search word to be selected. When a record is selected it is...

If you open up my example database and open Add/Edit Records and you go down to Disposition and you select Won, Sales Won form pops up. As you can see, this form has a Lead ID field. I want this Lead ID field value to be the same as the Lead ID field value on the Add/Edit Records form. So for...

This is probably an easy to do, but somehow I am stuck. There is a field in my form that lists if the company is a hospital or clinic (OP or IP). And then there is a field in my form that shows the size of the company. The label is "Size". I dont want that label to be "Size". IF the...

I made a search form. I want to add a message box when there are no results. What would the code be to add a message when the search returned no results? I know you have to put: MsgBox "Your search returned no results. Please check the spelling and try again.", vbInformation, "Invalid...

I know the issue has been brought up, but I have developed code to search on the main form, but what do I need to change to have the code search the subform? My mainform is named 'Accounts', my subform that I want to search in is called 'ClientInformation Subform.' And the [Last Name] field is...

Hi, I searched the forms and I didn't find an answer. Anyways, I have a form called 'Report Generator' in which I have a combo box called 'cmbLeadSource' in which the selections are 'Web, Phone, and Email'. I want the user to select one of the sources from the combo box and then click on a...

Ok this is probably an easy thing to do but I am extremely new to Access. Anyways, if you want to open up the example database Northwind on your computer. C:/ProgramFiles/Microsoft Office/Office/Samples/Northwind.mdb And you go to the "Sales Report Dialog" form. You see that the third option...

Ok, I made a search form and I added a record into my table that directly is linked to my form, but I can not find the record when I run the form? Can anyone help? Thanks.