Search results

No i've not. Would you be able to give me a quick example of what the argument would look like and i'll give it a go asap! Thanks for your help so far Cheers

Hi all, I'm having an issue at the moment with list boxes and if anyone would be able to cast their eyes over this I'd be eternally grateful!. Essentially I have a form_A with several tab's and then one list control box in each of those tabs. At present if you double click on any item within...

Thanks Mihail & namliam, This seems to be exactly what I needed. I'm going to try it on my data this afternoon and i'll let you know how it goes. Thanks again for your quick replies Hugely appreciated.

Hi Everyone, I'm basically having issues with a query and in turn a list box displaying duplicate records and I've tried everything within my knowledge to make it work but I'm at a loss as to what else i can try at present. I am trying to run a query that shows the job number once as well as...

Morning all. I'm trying to create a query that will return the closest matches to what is input. However the closest i have gotten to this working correctly is by using the following criteria. Like Left([Forms]![TESTTESTTEST]![Text2],1) & "*" Now obviously this isn't a great solution as it...

Hi, First off thanks for the quick reply. 1, my auto number is currently four digits (0000;00000;"Null") and will increase to five soon (In our old database we allocated product enquiry numbers by starting on 1000 and then every enquiry after that would be given a number 1001, 1002 e.t.c) we...

Hi Guys, Could anyone offer me some assistance with relationships between tables please?, Apologies if this is a stupid question but I have a job number (4 digit number) which is currently set to auto number in table 1(container) I need this number to automatically update throughout the other...

Hi Guys, Basically i have a list control box which displays data from a query. I have a macro which opens up another form when a record is double clicked in the list control box and theoretically it should display that record, however it is currently only displaying the first record in the...