Search results

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...

Hi All, I am building a database between SQL Server 2000 and MS Access 2003. I have a question in how do I go about creating autonumbers in my ID fields, becasuse SQL Server didn't have an auto number field type, so I've created all the ID's in my Back End tables as "bigint" data type, but...

Hi All, I have a question of the functionality of Crystal Reports. I presently have a database which is our course booker, which in it's front end has a Crystal Reports tool. Separately to that I have a second database which has a large number of modules, reports and tables to produces all...

Thank you! :D

Hi, THat's Great! THankyou. I appended on the end of it the where clause as you stated in your "note 2". The output from the query was all the records in the tbluser table - at a guess becaue all the altbudget and altTasks were null, except mine which I would expect to see, and the one record...

It's throwing just a generic "Syntax Error, Missing Operator" when I try and switch from SQL view to datasheet view.