Search results

  1. RCheesley

    What's happened to the NHS???

    I can't spend a single day without seeing posters and information about the NHS Fraud Investigation Department - it's doing bloody good work and catching out some absolutely astounding frauds that go on. This will happen in any industry to be honest, but it does rely on people being vigilant...
  2. RCheesley

    You know it's nearly christmas when ...

    Heh, just buy flour and make my own .. much nicer and you can't beat the smell of fresh bread in the morning :)
  3. RCheesley

    What's happened to the NHS???

    Ahh well, I started working for them oumahexi .... that makes all the difference :) Teehee x
  4. RCheesley

    You know it's nearly christmas when ...

    You hear the first xmas song of the year on the radio .... last night on my way home from work!
  5. RCheesley

    Using Mail Merge - question on VBA

    Thanks for the advice, please appreciate that you might actually be telling me to do something which I do not understand. I tried doing this when you first posted but gave up as I was getting even more errors than I had to start with and couldn't understand your seemingly idiot proof...
  6. RCheesley

    Using Mail Merge - question on VBA

    Hi all, Perhaps I need to clarify for people as things seem to have got lost in translation somewhere! The following is not working: Private Sub But_ConsLet_Click() Dim oMainDoc As Word.Document Dim oSel As Word.Selection Dim sDBPath As String Set oMainDoc =...
  7. RCheesley

    Using Mail Merge - question on VBA

    Hi Gemma, I might be missing something but where do I put this code? I tried using the spaces as you suggest, but still no joy. Ruth
  8. RCheesley

    Using Mail Merge - question on VBA

    Is anyone able to point out why I might be getting the error above? Would really appreciate some advice! I've got as far as I can go with this one and can't see the wood for the trees :( Ruth
  9. RCheesley

    Correct English??

    I believe (being a native english speaker) it depends entirely on the conversation. There might be times when I would start the sentence with the person's name - particularly if you are intiating a conversation. Using the name gets the person's attention, then you tell them what you want them...
  10. RCheesley

    Your Slingshot Santa Scores!

    My high score so far: 348.1 .. getting better!
  11. RCheesley

    Your Slingshot Santa Scores!

    post your scores here, the game is at http://www.onemorelevel.com/game/slingshot_santa Ruth
  12. RCheesley

    Annnnd, I will walk 500 miles....

    Teehee, obviously!!
  13. RCheesley

    Annnnd, I will walk 500 miles....

    According to my screen, Mayor Taylor: 39.45!
  14. RCheesley

    Annnnd, I will walk 500 miles....

    We're starting our challenge at work today .... Should be fun! You say you can't find time but I just leave mine on the waistband all day every day, you'd be suprised how quickly it adds up! Then I find myself doing extra things like walking from the car rather than taking the bus, to increase...
  15. RCheesley

    Using Mail Merge - question on VBA

    Partially fixed ... I had a missing reference in VB Editor..now getting problems with accessing the DB - says it's locked .. funny that, seeing as I ran the request from the database :| Also now getting an error that it can't find the field "|" (it looks like a pipe, could be an L) referred to...
  16. RCheesley

    Error - User defined type not defined

    Ahar this fixed my problem, I had a missing reference in my VBA window! Woohoo many thanks :)
  17. RCheesley

    Using Mail Merge - question on VBA

    Thanks David, If I wanted to add on an additional "AND" clause, i.e. I want to say "and the sample date is less than or equal to the discharge date +62 days" would I just bolt this on to the end? as in, AND SampleDate<=(PrevDiscDate+62) or would this not play nicely? This is also set on the...
  18. RCheesley

    Using Mail Merge - question on VBA

    Hi all, Just wanted to check something, I'm planning to use the mail merge solution posted here but need to run the merge ONLY for the particular record active in the form from which the button is pressed. The VBA code on the article above incorporates an SQL statements: SQLStatement:="SELECT...
  19. RCheesley

    Mail Merge

    Important to note as I couldn't figure out why this wasn't working, you must update field after you apply this change :D
  20. RCheesley

    Did you get snow?

    I think the last time we had snow on Christmas Day in my part of the UK (I was living in Dorset at that time, which is on the South Coast) was mid-90's. We had my mum's sister and niece staying from Australia, the sister grew up in Lowestoft and emigrated but the niece had never been to the UK...
Back
Top Bottom