Search results

Thanks for your effort Jack, I have figured the problem out and the answer is along the lines of your response, its all in getting the query criteria right. While I have your attention what can you tell me about a frontend/backend situation where I want to be able to break/delete the link from...

Thanks Jack, sorry to bother you again, I got to this part and understand it but my bound column is the primary key and it would take some rework to modify things to make the bound column not the primary key, so what do I do with the statement below to allow things to work? Quoted from mvps.org...

Thanks for you reply Jack, you come to my rescue alot! I can now get the MS code to work, sort of, I don't get the type mismatch message and the (All) appears in the combo box list but it won't stay in the combo box as a selection to be used. I use this selecetion to filter records on the next...

I have found this code to add the word "all" to a combo box. I suspect the code has been written for A97 and as I'm using A2000 I can't seem to get it to work. The error I'm getting is a type mismatch when the form with the combo box on it opens. Because this code seems to want the combo box...

Thanks Alex, the second option was exactly what I was looking for. Thankyou very much Rachael

How can the path name of the linked back end database (the tables) be displayed on a form in the front end? I want my users to know which backend DB they are linked to. Thankyou for all replies Rachael

Thanks Pat for your reply, could you expand briefly on this ie perhaps point me in the right direction to find more info Thankyou once again Rachael

Thanks Pat for your reply. The designers of access should make this possible as it would be a handy thing!! Rachael

Hi All, Is there a way to get a continuous subform onto a continuous mainform?. When I try this I get a message stating that I have to change the main form to a single form! Thankyou for all replies. Rachael

Hello, Is there a way to get a subform embedded on a mainform that is set to continuous? What I am wanting to do is display a form to show more than one record on the screen at a time but would like to display its subform data(which is usually on 2 or 3 records long with it). At present Access...

Yes pcs, the reason for splitting is to allow upgrades of the design without disturbing the users data. Thanks Jack for your reply, I will have a look at these now. Thanks Rachael

Hi, how do I go about getting my front-end database to prompt for and link to a backend database on startup. What code is required? Where do I put it? I am distributing my database and have a set installation and linking location at the moment for the backend (c:/Program Files). My fear is that...

I had this problem a few months ago, I searched other posts in this forum and discovered some interesting things about .bmp's etc. Firstly embedding images blows your db size out the window so linking is the best option. gif's are better to use than bitmaps ( they are smaller). I suggest you...

Thanks DJN and no, your not interferring at all, as you would know any help is greatly appreciated. I shall combine your's and jwindon's replies and see how I go. Thankyou, Thankyou, Thankyou, Thankyou, Thankyou, Thankyou, Thankyou, Thankyou, Thankyou, Thankyou, Thankyou, Thankyou, Thankyou...

Thanks heaps for your reply, please excuse my dumbness here, I understand what you are saying and the code etc etc, but where exactly do I put the code, do I simply go to the form with the message I want to suppress and then go to the VB window and type in your code suggestion? In the past i...

Hi All, I have designed a db that I plan to distribute, many of my clients are basicly computer illiterate. The situation is that where I have a field on a form for data entry set to a number field, thats OK, but if the client (for some reason) tries to enter text into this field they will get...

Hi, Try inserting a tab control and then place your subforms on this (tab control is created from the toolbox) Rachael

Anauz, it seems everyone wants your code, (including me), I hope the topic is not too cold (could I have an email as well) Thankyou, Rachael rcroucher@looksmart.com.au

Thanks for your comments guys, the one month option is the best way to go. I 'spose I wanted to use Access over excel to get the option (I think) of easily selecting the combinations of different sites to be displayed on the chart. I'll see how I go!! Thanks very much for your comments, I now...

Does anyone know what the capabilities of MS graph 2000 are?? I am about to embark on a project where temperature data from several locations is entered into a database. There will be tonnes of data (ie min and max for 365 days a year for each site) I would like to know: Will MSgraph cope...