Search results for query: *

Hello, I'm getting an error when I'm trying to create a chart. The chart is based on a query with the following data: Month Campaign Sales 1/2005 A 100 1/2005 B 200 2/2005 A 250 2/2005 B 300 I want the chart to show "Sales" on the Y axis...

Here is my problem, I'm guessing there is not a way to solve it. I have two tables from two different sources. Neither table has a primary key or like field that I can use to create a relationship. I want to use address to identify names that appear on both lists, but there are multiple ways...

Thanks for the Index Tip. That did speed it up, however it still only pulls half of the list. Thanks again!

Thanks for your help. I understand what you saying, but for some reason it is not working. Here is the code I entered: Private Sub ComboBox_KeyPress(KeyAscii As Integer) If Len(ComboBox.Text) = 3 Then ComboBox.RowSource = "SELECT * FROM tblBuildings WHERE Site Like '" &...

I have a combo box in my "lead form" that pulls names from a separate table. The separate table contains roughly 125,000 names. Anyway, the combo box is sorted by alphabetically but will only list the names starting with A-M. Is there a way to generate the entire list faster when...

Here is another code that does work, but only when the "Site" field is not a Combobox. In this situation the site field is called "Intitute" on the form and "site" in the table "tbldistricts" Private Sub Institute_Exit(Cancel As Integer) Dim varAddress1...

I am trying to get an "address", "state", and "city" field to automatically fill in on a form based on the selection from a listbox called "site". The "Site" field list comes from a separate table called "tbldistricts", which contain...