Search results

Thanks for that. That's great and works perfectly. Although there is one thing I overlooked. The combo box I am changing is part of a continuous form, however different forms might have different values and are therefore required to be different colours. Is there anyway to change them...

or even change the colour of the entire combo box based on what is selected

Hmm. Ok would possible to get a rectangle to change colour depending on what was selected in the combo box and if so what would be the best way to update that?

Is it possible to assign a different colour to each row of a combo box? I am pressuming that I have to use VBA, but my VB skills are incredibly rusty at best and I am not much better at Access. Is anyone able to offer me any pointers? Many thanks for any help in advance.

I have two subforms on the same form. Both of which show data from the same table, just different fields. Is it possible to get the second subform to change on if I select a different record from the first so they are both always showing the same record? Many thanks for any help in advance.

I got that far, but I want a continuous subform within a continuous subform, which it will not allow me to do.

I don't really understand what you mean. I have a record, which may have many records associated with it in a second table, of which any of these may have many records associated to them in a third table. I want to able to display all of this information on the screen at once and not have to...

I have a form which is set to single form. Within that form is a subform which is set to continuous form. What I want to be able to do is create another subform within that subform but keep both of the subforms set to continuous form but Access wont let me do that. All I want to achieve is to...

I have three fields, One called Key, one called IS and one called BC. I want the table to automatically copy the number from the IS field to the Key field to be used as the primary key. However, this field does not always have a value, when this occurs I want it to take the value from the BC...

I have a field called cost and a field called caller. I want to calculate the sum of cost where the field caller is equal to a specific value. I.e. A____B____ ------------ 12___One__ 09___Two__ 02___One__ 03___One__ 04___Two__ 10___One__ Total where of A where B = One: 27 I'm having trouble...

I am importing an Excel Workbook into a table by usng the following piece of code: DoCmd.TransferSpreadsheet acImport, 8, "tblCalls", "C:\Documents and Settings\David\My Documents\Phone Bill Checker\Calls" & s & ".xls", True, "" How would I modify this so it also created an auto number...

I understand how to do that, but how do i make it so the user inputs 'Accountant' into something like a parameter value box so the query is hidden from the user and the value can be changed each time the query is run?

How do i make a query which will search for key words in a field in all records in a table? I have little knowledge of VBA so a way of doing this without using it would be much appreciated.

How do i create a macro to display/open the main database window from a switchboard by using a command button?

Thank you very much Access 2000

Yes, I am inputting one value, but has many matches and I want all these to be listed in a form.

Like ""

Thank you for your assitance. I have now created a dialog box with a text box for the user to enter the criteria they wish to search for, but I am unsure as to which string to put in the criteria box, (I am not all that familiar with VBA). Please could you help. Also, is there anything else i...

I know it is possible to ask the user to define the criteria for a query from a form, but how do you do it?

Is it possible to insert a HTML code into a form design so it appears in the form view as it would if it were viewed through IE. E.g. a search engine search box.