Search results

Hmmmm ok here's the thing. Most of our passengers are random passengers so we may not get an actual address for them just a pick up point they may also have more than 20 pick up points and destinations. I would also need to have their details before they book to populate the table this is not...

Ok Bob I have made a second order table (booking table 2) and have the info defined as text boxes but I notice I can not see the passenger names on the table as these are all ID numbers and without a look up at table level I don't get what I need. Is there a way of showing the actual name of the...

Ok Thanks Bob.

Ok so it will bloat the db and cause some errors, ok. If I remove the look ups from the bookings table can I still use them on the main form? Cheers

Yes SIR. Lol hahahaha ok am learning, am listening. Well I am when I stop laughing, Bob has anyone ever told you your mad? But that makes two of us so carry on. OK so don't use * in field names ok didn't know that erm ok I can change that for something else. Will read why not to use look ups at...

No, we may get more than 1 Bob say, so if this particular Bob has called before then if I can list all people Named Bob it would be easier than trawling through heaps of names. You can usually Identify a passenger by their pick up address or destination so If 10 Bob's called am sure they would...

Hahahahaha:D

http://www.access-programmers.co.uk/forums/showthread.php?t=217804

Correct! If you have a look at my reply to Bob, I asked him if he could take a look at my second thread but posted the db here for convenience, my second thread asked if there is a way I could modify a query to return a specific number of records based on the name entered in a combo box on a...

The easiest way is to show you in steps with pics they say it better than me. Step 1 Book a new record. Step 2 Enter the passengers name. Step 3 See the query return passenger duplicates It's those duplicates, there are to many names I want the query to return only the name in step 1 as...

Ok thanks, well if you open the form venus dispatch system and go to new record and type a name into the passenger combo box hit enter a query will run and show duplicate names of passengers that have previously booked jobs, but I only want the names of passengers that match the name that you...

:D I hear ya lol Thanks

Wow thanks Bob, There seems a lot you can do I had noticed that I was able to achieve some things through trial and error but that is a mighty long list. I wonder if you could take a look at my second thread and see if there is a way of achieving the results I need. I have attached the DB so...

Thanks matey Regards

Thank you so much, will attempt in in a lil while when I get the nerve to try haha. It all seem so daunting just to go one step further than I already am. Thanks again apr

Hi there, seriously I need help with a table and form. In short I want to know if I can modify a query to return all duplicates but only if it matches a combo box entry if so can I then have the query add the matching data to the same table? I have a table of customer names and a macro to run a...

Hi all, Akeel is the name, trying to figure my way through this mine field called access is my game. Total newbie so if I ask a silly question don't laugh:D. Thanks for any future help, it means a lot, really.

That's probably why I couldn't find it oh dear my cheeks seem to have gone a bright red lol, is it warm in here or is it me hahahaha:D Thanks vbaInet

Hi peeps, I have been learning access 2007 and have been trying to find out how to auto refresh a split form. I have tried everything from ontime event Me.Refresh Me.Requery with the interval set to 10000. I just can't seem to get the form to auto refresh. I have a column using a combo box in...