Search results

Hi I'd love to, but unfortunately it has about 2000 records and customer details in it, nothing important, but it'd be very naughty to send out their info over the net. It's also split into front end/back end. I can zip up the front end and then you could see the code, but not any working...

:confused: it's true though, if i find a customer that has a been on a trip (which is wierd as you need to use the same form to ADD a trip), then i can see the form fine. Grrrr.

For example, i have a pretty much identical form for 'training courses' that works fine. If you click on it it will show the form for training courses, and even if the customer has not been on any training courses, it allows you to add a fresh record (which has an autonumber which is set when...

hi mile-o-phile i think this is the problem. i don't remember it being like this though. The idea is that you open this form to 'add a trip'. But it will only open if you already have a trip?! I never made it like that! It won't let me add a new trip either. You can view the old ones, but not...

Hi ken unfortunately, nothing happens. It doesn't even have the number of records in the little box in teh bottom left corner (you know, with the arrows to allow you to move between records etc) - that's blank. But the form is 'there' and works if you double click it from the object viewer...

Hi there I had a button on a form 'a' that launched form 'b' with the correct customer ID of the customer from form 'a' - simple. Deployed the DB in the office, it worked fine for a while but now the form just comes up blank (ie no text boxes etc, just the blue background). I've tried...

Thanks for your help! I'll try that at work tomorrow and let you know how it goes! Cheers Edd

Hi guys A while back i made a pretty complicated database for a travel agency. I then split it and stored teh backend on the server at their office, and a copy of the front end (forms and queries) on each users machine. This worked fine. The problem is that there are some (quite a few)...

usign select DISTINCT cuts the number of records down to 96 in the query - great but it's still wasting loads of space surely? i can't find a more economical way when using the query by form method. is there any way of doing this without using up loads of space? cheers. cheers guys edit - am i...

Complicated search for data from 4 tables - can't do it sensibly! Hi guys I am currently using the query by form method to do my searches. The problems arise when i want to do a search on a query (permanent query, that is) which grabs info from over 4 tables. Now, i am using the LEFT join...

I can just see them moaning now. I've compact and repaired the db - i've analyzed performance and it says it doesn't have any suggestions to improve anything. But it takes a few seconds to open some forms or perform some queries. I'm testing it at home on 2 networked pc's, there will be 4 (max...

don't worry i've sorted it many thanks

but i WANT the combo to look empty for those rows? i want the date and text fields which get filled in upon selection of hte combo box (afterupdate) to stay.

i think the problem lies a bit deeper and is a bit to complicated for me to explain here (no one will read it), you have to see it to get it. thanks again

I want the old trips to show on the form, but not to be shown when the combo box is expanded. combo box should only show future trips.

damn... no one able to crack it? :(:( :confused: :confused:

i mean taking all the fields from tables, and putting them in a (permanment) query by the query wizard. this query then acts as a 'source' for the 'search' (qbf method), which generates a dynamic query of it's own which contains the 'results' it will always be quick on my machine cos i only...

i mean like a few thousand records (Eventually).. there'll be like 70 fields from different tables composing the query!!!!! by search i mean the query by form record, with the query named above as the source of search. cheers

Hi guys I've made a db which stores customers... each customer can do lots of things... they can do trianign courses(2 tables, many to many here), they can go on trips abroad(2 tables, many to many here), they also have other stuff.... basically to cut a logn story short, i'm searching for...

Hi No mate, when i do this, the old dates fields are still not filled in for the old trips! I should mention that i'm using cascading combo boxes. There is a box, trip type, you select a trip type in the combo box i've been working on above..... then you select the trip from there (the box...