Search results

Yes you can. Check out this thread for starters

The first thing you need to do before you start looking at your forms is to tidy up the structure of your tables and the data they contain. 1) You have a number of ambiguous filed names. The field called ID appears in all three of your tables, in two of those it appears to be a primary key, in...

Hi dups Firstly can I suggest that you change the way that you have set up your ComboBoxes, in most (if not all) cases I would suggest that the ComboBox be populated from it's own table. For example your Title ComboBox on your main form; instead of having the titles already held in the ComboBox...

I've made a couple of changes to the form, and I do realise that it is still some way from what you're after, but hopefully it will give you some ideas as to how to get to where you want.

I think I see where you're headed. If you get your hammer out you should be able to give my form a bit of a bash to do pretty much what you want :) In the mean time I'll have another look at what I've done and see if I can make it a little bit more what you're looking for.

Based on what you've said, I've made a few adjustments to your DB. I'm only guessing that I've headed in the right direction.

If I have understood you correctly the title is and indication/record of the training an employee has undertaken. In that case I would introduce a new table that stores the employeeID and titleID, I would then display that on the Employee record form as a subform, this way you can show the...

I think you'll find you will need to use code to achieve what I have suggested.

Firstly you'll need your three queries to be append or update queries depending on what stage you are at with your data entry. Then you will need to have a command button or some other trigger that will test which of the options have been selected and run the appropriate query. Then last of...

If I've understood you correctly, you will need to "Refresh" the form after the first Combo Box has changed. This will ensure that the data you have just entered is stored in the table. Then you will need to "Requery" the second Combo Box to ensure that it has picked up the changes you have just...

As posted the query that populates the list box is based on only one input text box (that searches a number of fields). There is no reason you couldn't modify it so that the query is based on a number of text boxes that supply criteria to different fields within the query.

The search tool discussed in this thread Might be of some help to you.

Try this out, it's probably a little diffrent to your DB, but you should be able to get the idea and then apply your needs

You will need to create a query that collects and concatenates the selection from the two comboboxes and then base your list box on that query. The list box will of course have to be requeried after the two combo's have been selected.

Sure it can.

Perhaps this new theory would help :p

Have you had a look at cascading combo boxes?

Try this Thread

If the Query is providing data for a form Me.RecordSet.RecordCount = 0 Tells you there are no records. You could test for this in the OnLoad event of the form and put up a MsgBox.

I'd guess that the short answer is going to be no. Unless you know, or can find, someone that has purchased the DB and is willing to share.