Replies

Thanks for the reply.

Yes, the macro only works on the machines that have MS Access installed on them. I will need to get our IT administrators to register mscal.ocx.

Thanks

Regards

Graeme

Yeah, that’s a fair observation!

Code now inserted, error handler activated, error now successfully being handled!

Thank you very much Hans

Regards

Graeme

Thanks Hans

I put the code in but still get the same error. Here’s the sub,

Private Sub CmdEmail_Click()

DoCmd.SendObject _
, _
, _
, _
“graeme.durden@edfenergy.com”, _
, _
, _
“DataBase Question”, _
“Type your Database question here…………….”, _
True

Exit_CmdEmail_Click:
Exit Sub

Err_CmdEmail_Click:
If Err = 2501 Then
‘ User cancelled – just ignore
Else
‘ Otherwise display error message
MsgBox Err.Description, vbExclamation
End If
Resume Exit_CmdEmail_Click

End Sub

Have I put a a typo somewhere?

Regards

Graeme

Those are brilliant!

Maybe they’re Colorado Blue Spruce Trees ?

And the windows look like they are a Victorian sash design. A house built at this time would have had a slate roof. The roofing timber on a roof that size would probably not be strong enough to take the weight of that many concrete tiles. Or if it’s a new build then a mock Victorian window with a concrete roof tile looks well naff!

IMHO

In the house picture, there are no lintels above the first floor windows so the roof joists and rafters would come crashing through the window frames.

Regards

Graeme

You’re quite right Argus, 20Mb means 20Mbps. 20Mb is the cable company sales blerb! The actual is 7Mbps to 17Mbps depending on which speed test site I try. Prior to this 8Mbps was the “up to” figure quoted by the phone company and I was advised that my phone line “should” be able to give me 6.5Mbps. The actual figure was somewhere inbetween 3 and 4Mbps. But then I’m old enough to have owned and used a 14kbps modem so I’m well happy!

Regards

Graeme

Woody’s 4 minute answer Lounge!

Thanks Hans, option 1 implemented and working.

Regards

Graeme

Latest update! I’ve created 9 templates in Word one for each method statement type and a data file using Excel for the site specific stuff. One of the fields holds the document date. In Excel the cell is formatted to show 26/01/09. After merging the date displays in Word as 01/26/2009. Anyone know how to keep the original formating?

Thanks

Regards

Graeme

Is that the fine feline you call Jupiter ? Or is it Saturn ?

Regards

Graeme

How could you not when you get awe inspiring pictures like this and like this on your screen each morning!

Regards

Graeme

Chris

I love this web site. I have it as my home page so It’s the first thing to great me as I fire up the internet each day.

Here is an Analemma over the Ukraine taken in the evening.

Regards

Graeme

Thanks Rory

That’s just what I wanted.

Don’t know why I posted the jpg!

Regards

Graeme

Jezza

That makes sense. However, I think my Missus might argue that “a chocolate bar is better than eternal happiness ” is valid on some days!

How’s your leg?

Regards

Graeme