Search results

Try this Web Site you answer a number of questions and then it will give you a list of breeds that could be suitable based on your responses.

Why not have a check box, that is checked if the Delivery and Pick Up address are the same? Then You could just run a simple append query to update the Delivery address to match the Pick up address, when the check box is checked.

I wouldn't have bothered answering this, if I had seen there were two threads on the same topic :mad: and the other had already been answered. I will add however that all my DB does is draw up a purchase orders for my supplier and produce an invoice for my client, as I’m not interested in the...

I have a data base that is a little similar in that the product can be sold as a set, or as component parts. What I have done is, I have a table that holds the description of the complete item, the components and prices are then stored in a second table which is linked by the ID for the complete...

You need to add an "OpenArgs" to each of the buttons one say "New" the other "View", then you need to put a logical test on the "On Load" event of the form and switch on or off the add data and edit data properties of the form.

Thanks guys yes I had got as far as both of you had suggested, and I realise I need to implement some code. What I'm wondering is can I us code to add additional criteria to the query dependant on the state of a check box, and what would that code look like, if it can be done that way?

Would it be possible to add some code that would highlight the area/s in which matches exsist? and what would it look like?

You two Absinthe enthusiasts might be interested in this site they seem to supply all manner of Absinthe and accessories :cool:

I have a form based on a query, I would like to add additional criteria to the query dependant on the status of a check box. Is this possible if so what would the code look like?

Thanks rak I'll check it out.

I've fixed the problem by testing if the last character is a space, and stopping the sub routine if it is. As I suspected whenever a text box loses focus any trailing space character is dropped off the string. I don't know why I didn't think of this solution until I went tot bed :(

I think the question is, is there an easy way to change From, Table, Query and Report names along with all the refrences to them.

Thanks Bob, that's great. There is just one little side effect though, that I have not been able to overcome as yet, and that is that the Text box will no longer hold a space character. I'm guessing that has to do with the shift of focus from and to the text box. Is there a way around this?

I've been having a bit of a play with this form and have put an on change event on the text box which keeps the highlighted row of the list box at the top of the list, and also ensures that the data shown below the list box reflects the highlighted item. it looks like this It works fine...

First you will need to write a query similar to "Query1" the references your table. Then you will need to make a form similar to the "Search" form but based on your query you will need to examine and replicate the various events on the original "Search" form with reference to your own source data

I have a form that is opened filtered from a selection in a combo box. The problem is that the selection in the combo box can not be linked directly to the data on the form to be opened. So is it possible to use a query to select the linking information and insert that result into the...

What you need is a cascading Combo Box set. Do a search on cascading combo boxes. Briefly though you will need to write a query that selects the results you want to show in the second combo box based on the selection of the first combo box. You will need to requery your second box via the...

Thanks Bob, yours is the method I use. Iwas just interested if there was any benift in the method outlined by Gemma.

Gemma what are the pros and cons of using the method you have suggested and the method suggested by Boblarson?

For starters I'd split the country and years into their own tables so each value will only appear once in your combo box(s), and in your main table store only the Country ID and Year ID.