Search results

As usual, my only limitations are sheer ignorance ;-) So yeah, what I'm trying to do is to return the name of the place from the PLACES table (and by extension through the PLACES table the Place_ID), by matching the one piece of information I do have - the name of the traveller from the first...

Thanks for the reply, John. But I do not believe that this addresses my issue. I want the first combobox on my form to have a list of travellers' names ([TRAVELLER]![Traveller_name]) I want the second combobox on my form to have the list of place names ([PLACES]![Place_Name]) The problem I'm...

OK, there is a much easier way to do this, I'm sure, but I'm rather new to this and can't figure out how to perform the following without all sorts of obfuscated loops and temporary variables. Given the tables: TRAVELLER -------- Traveller_ID as Autonumber Traveller_Name as text TRIPS -----...

sorry I don't have an answer to your problem - maybe fiddle with your Column Count and Column Widths... but thought I'd pass on an excellent article that explains these topics well: office.microsoft.com /en-us/ access-help/ basing-one-combo-box-on-another-HA001173058.aspx (sorry it's...

I'm using 2010 so shouldn't be an issue there. Thanks a lot for the suggestions & the article guys - looks like that article covers exactly what I need to do.

I am using the onChange Event in a listbox to continually narrow down from a list of phone numbers, so that if you click when it's empty, it shows every phone number in the table it's looking up, if you type in the first number of the area code and click the down arrow, it just shows all the...

Forgive me, I'm pretty new to database programming and, though I have immersed myself in learning material, I haven't found out how to do this yet but really need an answer. I'm thinking it's a basic conceptual problem I'm having preventing me from coming up with an answer. I have an entry...