Search results for query: *

I am using a pop-up form to filter a report. The code I am using comes from the Microsoft site. Have used it before, and it works perfectly. Until now. This is the code to set the filter choices: Private Sub Set_Filter_Click() Dim strSQL As String, intCounter As Integer ' Build SQL...

Below is the code given in an A2K template to allow for the user to add a new Customer to the Customer list if they are not currently there. I am trying to 'borrow' this code for another database and find that the "then" part of the statement at the end of If IsNull(Me![CustomerID])...

I am attempting to 'add' to the Resource Scheduling database provided with A2K. In the Reservations SubForm, the following is the record source: SELECT DISTINCTROW Schedule.*, [Resources].[ResourceName], [Resource Types].[ResourceType] FROM ([Resource Types] RIGHT JOIN Resources ON [Resource...

I have a combo box with a list (Architectural_Firm). I have a telephone (Arch_Telephone) and a fax (Arch_Facsimile) text box. I would like each of them to autofill when the User chooses the Architect from the combo box. My form is based on a query. I have tried at least four different methods...

I have read more than a few threads on this issue, but still have some questions. Maybe someone can help? I have a combo box (architectural_firm) for a Contact. I would like to have the telephone and fax numbers that are with this record in the table, automatically fill in the form when the...

I have done a vast number of Google searches and cannot seem to find the answer to this. I have copied the pop-up form example o Microsoft's site, to be used as a filter for a report. The example, however, only sets up text combo boxes. And it works great. What I need is to be able to also...