Search results

MSLady, I'd admit it if I did do it (surf porn sites etc). Unfortunately, the provider I use (state monopoly so there's no way round it) blocks objectionable material. If this was my route to getting my rocks off, whatever that actually means, I'd be a long time between drinks :) To be honest...

Thanks rak. You know, in my memory, it was black and white, but it is certainly the same joke, even if it isn't the same cartoon.

Problem solved. I was really hoping that there was some way of using something akin to 'me.filter' but it seems not. :( In the end, I have created 4 string variables that are variously defined in the case select of the 2 form filtering combo boxes which cascade into a routine to populate the...

Yasantha, I am sorry to be of no real help here but I think what you want is possible i.e. use an Access front end for a none Access back end, in this case SQL server 2000. My only tip is to try the advanced search function as various posts have been made on these subjects, none of which I...

You could probably fake tab controls using various graphic objects and their on-click or got focus properites to show and hide various items. Having said that, it is probably the wrong thing to do. I would advise thinking about Bob & Gemma's replies.

Rak, I don't know (or even really care) what a 'lobulus' is, but many eggs (if not all?) are coloured for camoflage reasons and driven by 'survival of the fittest' style evolution. This had the unfortuante side effect of making some attractive to egg collectors once humans had enough leisure...

I guess that settles that argument then? I once saw a cartoon, in Punch magazine I think, that showed a chicken and an egg in bed. The chicken was looking very satisfied n a post-coital sort of way, and smoking a cigarette, whilst the egg was looking a bit shortchanged. Underneath all this was...

Thanks for the feedback Gemma, I have been working on this today and am surprised to find that it wasn't as 'impossible' as I had thought to create the SQL where clause (apolgies to Joebax - you were right :) . I have managed to write sql 'where' text snippets for the case select conditions of...

Thanks Joebax. I am still messing about with this and wil post back with where I end up.

Hi Joebax, Thanks for the response. The 2 comboboxes that create the filter text for the form have something like 10 and 8 conditions respectively and the filter text is a combination of items in most cases. This results in about 80 possible, quite complicated filters. I started down the path...

This sounds like a cascading combo box issue but it isn't quite. I filter my form using 2 unbound combo boxes which can be used in any order, both of which define text strings using case select. These strings are concatenated into a filter text and applied by a routine called in the after...

I have a hidden combo box that is populated by SQL text in VBA when the user selects an option from a frame select. It is then displayed in drop down mode for the user to select a project. The form then synchronizes to the selection and the combo box is hidden again. At least that is how it is...

A subtle one liner from 'There's something about Mary' by the best freind of the Ben Stiller character who was a bit of a sad sack: When asked how he was doing he said, with a chearful face, something like 'Oh you know, each day is better than the next'. I missed this the first time I saw...

For others who still have nightmares about French homework: KudoZ(tm) term questions The KudoZ network provides a framework for translators and others to assist each other with translations or explanations of terms and short phrases. http://www.proz.com/kudoz?&pairs=&level=&float=

CopyLeft An alternative to copyright: This might be of interest to those of you who create longer or more complex code and generously make it available here and elsewhere. Kudos to you all. :) Read more: http://www.gnu.org/copyleft/

Hi, I have had similar issues in the past, in fact every time I created a tabbed form. :rolleyes: I think that your tab control is positioned so that its bottom edge is off the form at the size the form opens at solution 1: Decrease tab control size Solution 2: Increase form size Solution 3...

Blacknife, I see your problem is solved, but thought I would chime in anyway with a couple of alternatives. :) If the people getting the report have Access on their PC then you can use the built in snapshot report format. This is exactly as formatted on your system but is uneditable. The only...

From my studious watchng of American televsion shows (Law & Order etc) and reading various reports in The Economist, the link seems to be very weak over there. I don't know how much better it is in the UK, but any disconect is not so obvious. In my current locale, Justice & the legal system are...

Taking into account the age of the 'perp' seems eminently sensible to me. On the news article I saw, the lawyer interviewed claimed that a boy at the age of consent (I think it was 18) was prosecuted for statutory ra** of a consenting girl of 16 on pressure from the girl's parents. He was...