Search results

Nope, he's not kidding. I read about that too somewhere when the BBC news site ran an article on it. I'm lucky enough to come from an area in England where the water isn't flourided by default and I have to say it tastes better for it. The stuff in other counties just tastes like someone's...

Personally I follow the presidential race from the vantage point of generalisation and am more interested in the prospect of seeing what a new breed of president would be like. Would a woman or a black man perhaps usher in a new perspective in the nations consiousness as a whole? The States...

I already thought the south had its 'Angel' equivalent in the Sails of the South (or whatever they're called) in the proximity of Portsmouth?? Kent is hardly south either in the wider scheme of things so instead it will be more like an 'Angel of the East' and eventually some bright spark will...

wOOt, I have it sussed out at long last! My problem was not with 'sending' the variable to the report but the syntax needed to get at the variable from the report. Now added to the OnFormat property of the report header (where the text box resides) is something similar to the following snippet...

I'm struggling with this, so this is basically what I have so far (I've trimmed the non-essentials like the error handling) This is the global function called by a form. My attempts to read the VariREPORT sent by OpenArgs to the report are failing miserably at the moment, can I get a really...

Its a global, I try not to embed anything in a form's module if I can help it.

I've swapped the Dim statements on the variable to Public to no avail. The relevant bits of the module now read: And the Report text box (named ReportProse) reads in design mode: Additionally - In the post above it reads =YourVariable but everytime I leave editting the text box the []...

To further muddy the waters, I'm having trouble passing the variable to the report. The Report when triggered opens a dialog box to specify a value for the variable. Whatever I type is displayed so the text box on the Report is working fine now but the variable from my vba code is not being...

Y'know I could swear I tried that at some stage but I must have been copying and overtyping a label or summat (that'll teach me!). Thanks for your help RG, I knew it wouldn't take the peeps of this forum long to sort me out! :)

This is probably going to be an easy answer for one of the many well informed posters out there... I have user specified variable which is concatenated into some text to make another variable. These variables are just strings to hold text. I don't need to do anything with this variable...

FYI (from the UK) - There were two series of Life On Mars. The idea is being taken and a version being made for US television but there is a sequel series being made reportedly called Ashes to Ashes and is set in the 80's. This time I believe the time-trapped character will be female. :) Last...

Result! I continued on poking through different threads that looked similar and found a useful code snippet. For the benefit of anyone who stumbles across this particular thread in the future, my problem was solved by assigning the vb code given below to a button on a form rather than having...

Thanks for the reply Ajetrumpet. I'm not sure that is quite the answer though, so I'll try and clarify my question a bit. The actual 'formatting' of the output'ed Excel file is not a problem, and the data is not the issue The query works as follows: Now this is all just background info, and...

Apologies in advance if this is the wrong board to post this under (it was 50/50) and I'm leaning toward the problem being with the macro end of the problem... I have a Query set up which select records based on an inital criteria being met, then sorts the 8 fields of the records selected into...

The world needs more guys like that sheriff and less of the ponced up, politically correct nonsense spouted by just about everyone else in authority. Why should inmates watch TV at all??? I'm here at work, sans TV, paying my taxes to pay for them to watch TV... Where's the human rights in...

Does this mean the Sheriff doesn't get his backhander now or whatever else was on offer? :rolleyes: 10/10 for the Judge - the full 45 days!!!

Robert Carlisle - The Full Monty

Carrie Fisher - Star Wars

I am irony personified - for every wonderous and incredible ability nature gave me I have an equally proflific flaw.

Bill Murry - Groundhog Day