Search results

Unfortunately we didn't get a day off as the rain came and washed away the snow, hence the :( Sun is out now, but it's still bloomin cold!!!

As you may or may not know, I work for NHS Suffolk at the moment and we've just launched Healthy Ambitions - as part of this there is a challenge for the staff to walk 500 miles individually, collectively in a team of 5, or as a department/directorate! We were all given a pedometer as part of...

Thanks for this hugely useful thread, I've got the form using multiple values working perfectly in my database, you've saved me a huuuuuuuuge amount of time and effort! Woohoo :) Ruth

Methinks you might be right .. bloomin good job too as the UK grinds to a shuddering halt as soon as it even threatens snow ...... Great for us though, day off work!!!!

On TA or Supreme Commander? On SC you use the scroll button to pan in/out .. perhaps you had a funky resolution set? I have some crazy resolution as I have a 24" widescreen, but still didn't find things small - if anything too big - but the pan & zoom it uses takes a bit of getting used to!

My internet died last night (oes noes!) so I finally got around to installing Supreme Commander ... having really enjoyed Total Annihilation (but been incredibly awful at it as well) I had been meaning to check out Supreme Commander for ages ..... Perhaps 1130pm wasn't the best time to fire up...

Well it's a relatively rare occurence here, but we had quite a lot of snow this weekend! Unfortunatey it turned to rain by yesterday evening and it's all been washed away :( Ruth

A quick addition to this, now I've got the queries working perfectly and outputting to a report, is there any way to add in the label I have for the report, the information that is filtered upon (e.g. start/end date, location, status)? Ruth

Thanks for that, something so simple I somehow overlooked :| I've already written the queries for each type, because I want the system to determine the status from the dates entered, rather than the user .... eliminates the sleepy-tired-data-entry-person-error (i.e. me on a monday morning!) Ruth

I think I have a similar problem to this: I have four queries: 1. Queries tbl_sampleinfo to find pre-48h samples 2. Queries tbl_sampleinfo to find acute samples (taken 48h+ post admission) 3. Queries tbl_sampleinfo to find community onset community associated (sample date more than 8wks since...

I do try .... makes me look less like a fool when being told "its been answered here and here and here before" lol :)

Thanks for this, I was also trying to work this one out :) Ruth

Well that's very much the same approach I take (does that make me an honorary bloke?!?!?!) .... but this was annoying me .. turned out I had speechmarks where I didn't need them .... s'all good now though :)

Think I've managed to figure it out using expressionbuilder ... a bit of a cheat but got the syntax right!

Hi all, I wonder if you can help, I've been searching but don't seem to be using the right terms! I have various forms populating a table which includes 3 key dates, and I want to run various queries which return results from a table based on the following criteria: Date a = column1 Date b =...

Thanks for posting your solution, enabled me to fix something too! Ruth

Ahar this solved my problemo I think :) Woohoo

Thanks for the advice, I've used NHSNo as a primary key on the patient details table, linked to NHS number in the other table. Subform is set up with parent/child links, button created with the option of displaying results based on the NHS number specified, but still not working..the VBA for...

Hi folks, I thought I'd got this one cracked but it doesn't seem to be working quite right. What I have is a form where patients are entered, and then I have a button which I want to be able to click, and the following happen: If there is an existing record, this is displayed (pref. in...

Not one for handbags myself! Hehehe!