Recent content by GrahamK

Hi All, I've got an SQL table which has a start time, and start date filed in it, the format of the time is 01/01/1900 08:00:00 and the date format is eg 28/08/2009 00:00:00 - it's an awful way of doign it, but thats what in our product! I'm trying to convert the start time to HH:MM but...

Dear All, Please can you tell me if it is possible to have a word document as a report - with data in - so I could perform a glorified mail merge really? I tried doing a straight mail merge but it lacks the control and ability to query every time which record you want. Many THanks Graham

THanks Dave, I declared the whole path to the application executable as a variable and now works fine! Next head ache now.....! Many Thanks Graham

Thanks Mailman, But still to no avail... Graham

Just an update - I've changed the file name to H:\1GlasgowtheWestHighlands.pdf and I'm still getting the same error Many Thanks Graham

Yes Mailman, Path as below: H:\1Glasgow%20&%20the%20West%20Highlands.pdf VMT Graham

Hello All, I'm having trouble running a piece of VBA code - centering around the shell command. The code is below: Private Sub cmdOpenFile_Click() On Error GoTo Errhand Dim strfilepath As String strfilepath = Path.Value Debug.Print strfilepath Shell strfilepath, vbMaximizedFocus...

Many Thanks Mailman, I took the () out and all appears to work..... Strange..............

Hi Mailman, OK, I've moved those lines around and now am getting a syntax error on the line DoCmd.OpenForm ("frmUsrQualSearch2",,,,,,intuserid) in the "transmitting" form. I thought I could declare a variable in the [OpenArgs] part of DoCmd.OpenForm.....???? Many Thanks Graham

Hi Mailman, Well that s what I thought, hence why I wrote it - but it's returning errors relating to a null value when the second form loads, so nothing's actually being ported between the forms... Many Thanks Graham

Dear All, I appear to be struggling to get the OpenArgs property of a DoCmd.OpenForm statement to work. The "calling" form's code is: Public Function lstUser2_Click() Dim intuserid As Integer intuserid = Forms!frmUsrQualSearch1.List0.Column(0) DoCmd.OpenForm...

Paul, Thank you very much for your assistance! Graham

Hello All, I'm trying to run the query Below on SQL Server 2000 and and getting the error "Line 4: Incorrect syntax near '=' " I wonder if anyone can offer assistance? UPDATE tblStaffQual SET Status = (CASE WHEN GETDATE() >= Expires_Date THEN Status = 'Expired' WHEN...

Neil - Many thanks for your assistance, as a result it's all sorted! Thanks Graham

Hi Folks, I'm having a couple of issues with a query I'm running through MSAccess. It has in it a couple of "calculated" fields, for one of them, it all works fine, the second has some #Error data entries being returned it it. The Query is Below: ============== SELECT tblContractType.Type...