Recent content by nice_beaver

Not sure if this is the right forum for this but I will post it here as its affecting a table that is inside the db i am working on. I am updating the db for work and it seems that we have inherited a can of worms! A number of people have worked on the db before I received it and i think it...

Is it possible to ensure that if a particular field has a specific value, ie, 'yes' then the reaminaing fields on the page are automatically set to 'no' by default? If No is selected in the field in question then this would subsequently allow the other fields to be set to any value. Thanks in...

Many thanks Tim - works a treat!! :D

I have developed a small database (attached) but want to jump to the recorde selected. Anyone got any idea how I can achieve this - it seems to be 1/2 working, but I cannot figure out the rest. Cheers

That is just what I was afraid of. Looks like I will have to dig out the VB Books... :rolleyes:

Its accessed via a .exe file. There is a .mdb file where the data is all kept, but I suspect that what has happened is that the dbase has been developed then effectively wrapped up as an executable file where it is probably/almost impossible to alter without access to the original development...

We have been requested to look after a database for a customer but thought we would have a quick look at it before we accept the challenge. This was a good idea. The problem is that we would like to add/remove some of the custom buttons on the dbase but cannot access the guts of it; all the...

We have been asked to integrate a new Access dbase with Sage accounts. Does anybody on the forum have any experience of such an excercise and if so can you give na indication of how easy/difficult it is to implement. Thanks in anticipation.

OK, this is all very helpful, but when I select the suggested option I get the message requesting whether I want to create a query based on the table. I do not think this is not the option I require, as it will end up having to create a query, or is that what is really being suggested? Sorry...

posted in error [This message has been edited by nice_beaver (edited 04-25-2002).]

Many thanks for the prompt answer, but I was being a little funny when I mention the coat of colours(please re-read, as in Jacob! (sorry, my twisted mind at work...)) Back to the original qestion. I need to restrict the number of rows visible to just 3, as opposed to upto 35. I tried your...

Is there a way of restricting the number of rows displayed on a form/subform. I have a table of many entries (unlike a coat of many colours) but the owner wants to restrict the number of rows on view to the latest 3. Any ideas......please, and thankyou.

Yup, I know exactly what you mean! This was the last part of a project I had from a company here in the UK; they are currently testing what I've submitted to them, ie trying to crash it, and will be reporting back to me on Thursday with amendments etc, so I can feel much relief knowing that...

David, Thankyou so much. Have to ay, I cpoied your code and it works a treat. To be honest, I've been having late nights and stress trying to resolve this and then it all seems so easy when the solution is given. Once more, many thanks for getting me out of this problem.

I have a report which is made up from all projects in a database. In total the number of pages runs to approx 85, but, (and here is my dilemma) I need to be able to offer the facility to print any one of the pages from the report (where each page represents an individual project). I have...