Recent content by gavjb

Thanks,

Hi, When using the Convert to format the Date in a select statement I dot seem to have any change in the display, can someone tell me if I am doing something wrong. If I use convert(datetime, '31-dec-2010', 3) or convert(datetime, '31-dec-2010', 103) all I get for the results is 2010-12-31...

thanks that was what I was after

Hi, I am in the process of looking a test upgrade from SQL2000 to SQL2005, once we are happy with the upgrade, we need to be able to turn off the SQL2000 and rename the SQL2005 server to the name of the SQL2000 server. I know from experience with older version of sql server that this can be a...

Thanks, I looked at this several times and missed that

Does anyone know if there is a limit to the amount of elements you can have in a ENUM, as I have the following ENUM in the declarations area of one of my forms and it is only displaying the first 7 elements when used Enum AddQualType QUAL_GCSE = 1 QUAL_KS = 5 QUAL_AS = 6 QUAL_A...

Worked it ot, if I open the ecordset as static, then the count works

Hi, On my master form in my project, when a user enters a reference number (StudentRef), I need to be able to check if the record exists in UCI table (PK of StudentRef), and if it exists read the data from UCI field, but if no record exists then to create a record. I have tried playing around...

Thanks for all your help, I got it working with a few changes from your suggestions. SELECT A.NotesID, A.JobRef, A.Notes, A.NotesDate FROM Notes AS A INNER JOIN ( SELECT JobRef, Min(NotesDate) AS MinDate FROM Notes GROUP BY JobRef ) As M ON A.JobRef = M.JobRef AND A.NotesDate = M.MinDate ORDER...

Hi, I have a Notes table with a notesid field, jobref field & date field where I want to return the record with the earliest date by jobref Notes ID JobRef NotesDate Notes 1 MY-06-014 11/05/06 11:23 test 1 2 MY-06-014 11/05/06 11:27 test 2 3 MY-06-010...

Hi, I need to be able to store the files on the SQL DB Server (we have loads of space on server compared to file server). Forgot to mentioned what version of SQL Server we are using, it is SQL Server 2000 (latest service pack) Thanks, Gavin,

Hi, I am in the process of updating our inhouse Helpdesk system, and need to add a table to the system which will hold attachments of documents (mainly word, excel or jpegs) The files can possibly be a couple of megs in size but will more likly be fairly small files. Can anyone recommend a...

the Setup is Windows 2000 Pro (for both development and users) with VB6 SP6 and Office 2000.

I have just done a check and the file is copied onto the machine as part of the install, I have also tried regvr32 c:\winnt\system32\shelllnk.dll. But neither seems to solve the problem, this seems strange as previously, I have found that adding the library to the install copies and registers...

Hi, I am using the ShellLnk.dll Library (comes on VB6 Pro & Enterprise Cd's), but when trying to run the app on the client PC's I get Cannot find file error all the time, through debugging I have isolated it to the ShellLnk library. I have created a install package with the Package and...