Search results for query: *

Thank you, Dodgey and SimonJPearson. You both helped me look into areas I did not (and to some extent, still do not) understand. I was able to replace the Chr(34) with double quotations, but now I am being given an error on the 'Left' string line (strSQL = Left(strSQL, (Len(strSQL) - 5)). This...

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

SKO: THANK YOU!!!!! I will try this today. Dianne in Virginia

Craig, thank you for responding so quickly. I tried your suggestion. Please look at this and tell me I substituted the right items. Arch_Telephone = telephone number text box Arch_Facsimile = fax number text box Architectural_Firm = Architect MasterQuery = name of Query form is reading from...

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

Hi. What if I have a form based on a query? I tried your method and nothing happens in the text boxes I was hoping would autofill. 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 each of them to autofill when...

Thank you. I will try this right now!

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