Search results

Glad to help when I can :)

How do I do this? Reviving an old thread here: I would like to insert a pivot table, but I cannot see how/where to do it. Any pointers? Edit, A bit of background to clarify what I am attempting to do. I have a fairly simple table with fields for Personnel, Project & Section. I was able to...

Try this thread - I think it is exactly what you are looking for. http://www.access-programmers.co.uk/forums/showthread.php?t=97574&highlight=screenshots Regards,

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...

Greyowlsl, Although a bit older, I am a father of young children (3 under 4) and this changes your perspective on things. Even as an atheist, I am happy to believe in the concept of evil (in my terms innate 'badness'). Thankfully, the horror stories are rare and so they make the news (if...

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...

Back to honour (honor) To revert, rather boringly :D , to the original thread subject, I think honour is doing what you believe to be right regardless of the potential negative consequences to yourself or those around you: i.e. when it is not 'easy' to do the right thing. Is this innate or...

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...