Recent content by Dave 350z

That's great, thanks!

Text - so for example, I have say three offices, Cashel, Dublin, Portlaoise. I have a parameter [Enter Office] and then just type in one of the office names, which is fine, it will show me the required details for that office, but I want to be able to run the same query and show ALL offices...

I haven't advanced it to a form as yet, it's merely a select query at the moment. I have a number of parameters in the query, so I can select the query by a single office, but I need to be able to show it not only by one office, but by all items or effectively no selection if you get me?

Hi folks, This might be a simple enough one (I hope), but I have a listing of offices, I want the query to enable me to input the office name (I can do this no problem), but I also want the option to be able to select ALL offices. Is this possible? thanks Dave

Hey MrB, looked at the tables and relationships and they all look great to me, seem to actually incorporate pretty much everything I would need, I presume once a form is created, it updates each of the tables rather than the set up I created which created a single table?

Massive thank you Mr.B for the help so far!!

Cheers for the replies guys, it's really appreciated. (I have also realised I am seriously under trained!! :) ) Ok, the purpose of the database is for the Handler (our employees), to fill in the detail of the form for a prospective client to provide a quote, all the database is going to be...

Hey, Attached is the "database", it's only a very basic working draft and filled in with some details. Let me know if you need any more info as to what I'm looking for.... Cheers Dave

Cheers Mr.B, I'll take a copy of the database as I do have some client information in there as it is, I'll post it up later on, I presume there's no issues with a "noob" posting an attachment? Thanks for the help, it's much appreciated!! Dave

Ok, my combo box has a list of handlers that looks up the detail from a table, the Row Source Type = Table/Query, I've created a table for all of the handlers. So to create the list of all items input by that handler, what is it exactly I need to do, I've added in a list box, in the control...

Great, thanks, it's just a normal database really, I have combo boxes for a number of fields, such as handler, policy types and so on, but the main thing I want is to have the ability to show the cases for the handler when they select their name, I'll give the list box a go and go from there.

Hey folks, First time posting, I've very basic access skills, so please bare with me. I have created a pipeline management form, where a handler will record prospective clients, contact details and so on. Each handler has a unique reference, so I want the handler to be able to select their...