Search results

Read post #6. I have tried it and it does not work.

???????????

"Filtering on a field in the Subform You cannot use this simple approach if the field you wish to filter on is in the subform." I have seen this but my field that I wish to filter on is in the subform. I dont get it though because the title and then the first opening line completely...

Can anyone help or point me in the right direction?

No, that did not help.

Please post your database, I can maybe help...

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...

Yeah, I see what they did but I dont know how they did it....

Where do I examine the methodology of MS because I basically want what they did...

Open up Access Create a Blank Database Save it somewhere Go to your Tables Object on the left side Then go to File: Get External Data: Import and find your Excel file and it will take you through a wizard.

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...

Actually, I got it to work. THANKS for your help. I really do appreciate when you take your time out of your day to come on to here and help people like me. Thanks a bunch.

I dont know if this is what you wanted but this is what it says: ([Company] Like 'Uni

Ok, in my search I typed in "Unity" hoping to get Unity Hospital not Community Hospital. The Debug Window shows up and says: Run-time error '3075' Syntax error in string in query expression '([Company] LIKE 'Uni'. And I click Debug and it highlights the line that I highlighted in red in...

When I run the search the Debug Window comes up and points to this line as an error: ' Apply the string as the form's Filter. Me.Filter = strWhere Me.FilterOn = True

The code did not work for some reason. But that is what I want.

Ok, basically it is a search form. Searching for Company, Company Address, Company State, Company City, Company Zip Code Company Phone Number, Client Last Name, First Name, Middle Initial. I split my tables into two tables. One table just lists the company information because I didnt want...

Ok, do you know how to do that linking? Because I am completely new to Access. Any help will make me happy.

The Data Entry property is set to NO...