Search results

Does anyone know how I would use IF and THEN in Code to perform a conditional action. For example I have a text box which is in view, and a text box which is hidden. The text box you can see (Box A) is an input required from the user. The text box you can't see (Box B) is an algorythm based...

Ok chaps, here's one for yer! I have one data base, shared between 2 computers. One is 50 mile away from the other so the only way of communication is the net. Both structures are identical. What i would like to do is be able to set up a link that automatically updates the other machine when...

Forgot to put the = sign before it - Doh!! It's working now - many thanks

Still Not Working! Thanks for the tip but it's not working. Here's what I've entered - have I done someething wrong??? Here's my entry DCount("[FinanceCoName]","qryalldeals","[FinanceCoName] = 'Paragon'") Sorry to be a pain Andy

If you execute a query, and it returns no results, how can you turn that particular search into ZERO??? I've tried everything and I can't make it work!

I'd like to know how to count a certain number of records from a record set that equal a particular value - For example If I open a form and 20 of the 25 Records in the Town Field = Glasgow, how would I put that into the Control Sourse box to return the result?? All suggestions are greatly...

Still Stuck Sorry - do I create a new field or enter this into the existing criteria box???

I know this probably sounds a bit thick, but this particular problem is really annoying me. I'm executing a query that has a posibility of returning a Null value based on certain matches in criteria. (The result is based on COUNTING TEXT records) As I want to involve that search at a later...

Thanks Woks a treat - many, many thanks Andy:)

I'm just about to sell one of my first applications As the customer is "renting" the sortware by the month, I'd like a way of making the password change every month automatically so he would have to call me for the new password each time. I suspect the best way to do it would be to use an...

Just added some criteria to one of my queries so that it prompts for an input when the form attached to the query opens. When I input a name into the parameters box, it returns the records I want, but what I want to do is be able to override the input to return all the records in the query...