Search results

I'm using Access 97... I've get a combo box (cb) that I would like to be bound to one of two queries. I'd like the binding to be determined by a couple of buttons on the form where the cb appears. Also I'd like th cb to default to one of the queries if niether button is pressed... Any ideas...

Some help/pointers needed if you would all be so kind (I'm sure you will be...) I want to populate a field on a form (based on a table) with a link to a file. I want to choose the file with some form a 'browse' facility (similar to the the standard Windows stuff). I'm using Access 97...is...

Sorry...the example should read: E.G. If the number of results is 0 I want a message to tell the user and then return to the previous (calling) form. :D

I'm using a macro to open a form. The macro has a where condition which obviously changes the number of results displayed depending upon the basis of the condition. I have two questions: * Is it possible to count the number of results? * Can I use that reult to trigger another action? E.G...

Is it possible to re-join a split database? If so how...? If not is there a work-around...? Many Thanks Lawrence :confused:

Here's a poser for you all: Two databases with identical structures. One database has 20k of data in it the other is empty. (with me so far...) How come the database with witht he data is only 4Mb in size and the empty database is 18Mb in size? Answers on a postcard...any suggestions...

Sorry I new to this stuff so here's my (probably - hopefully - easy to answer) question. I've build a simple access application usinf Access 97. Is there anyway I can turn this into an exe file so that any user in the future don't need to have access to use it...? Thanks Lawrence:confused: