Search results for query: *

Anybody know how to do this in javascript, I can't seem to find anything in google. Cheers, Simon

Hi Does anyone know if its possible to limit the width of a table so that however long a string inside a cell is the table remains the same size. The width attribute doesn't seem to work, the table just seems to stretch anyway. Any ideas? Cheers, Simon.

Hi I am at a complete loss with this problem. We have a maintnance plan which backs up our database over the network at 21:00 every week night. Sometime it works and sometimes is doesn't. When it doesn't the log says this: BackupDiskFile::CreateMedia: Backup device...

Hi, I am creating a helpdesk system with a web front end and an SQL Server back end, and my current problem is this: Each request made the the helpdesk can consist of more than one task. First you enter the request, and then it lets you add more tasks on a different page, then finally you go...

Hi, I have a form with a list, I want to put an "edit" box next to each item on the list so it can be edited. How do I make it so that the visible name of the edit button is alwats "edit" but the value that is passed to the edit page is the id of the item on the list. Its not the ASP side of...

Hi We have a database which is 11 gb in size. However only 9 gb is is used the remaining 2 gb is free space. I was wondering how I go about freeing this the OS. I have tried: DBCC SHRINKDATABASE (i3_eic, 1, TRUNCATEONLY) but it only seemed to free about 400 mb or so. Has anybody got any...

Hi, I was wondering if it is possible to do 16 bit graphics with photoshop (any version). It seems to me that it skips from 8 bit (256 colours) to 24 bit (16 million colours). I can't see why 16 bit would be a problem but loads of grahics packages seem not to do it, and I really need to to...

Hi, I need to how you can bind a text box to a recordset that has been made in code e.g: Set conn = New ADODB.Connection Set rs = New ADODB.Recordset conn.Open "Driver={SQL Server};" & _ "Server=A9000;" & _ "Database=HR;" & _ "Uid=simontest;" & _...

Hi, I have made a view which contains the following: Year 1month 2month 2002 0 1 2003 0 1 2003 1 0 2002 0 1 1998 0 1 1998 0 1 1985 0 1 2003 1 0 How do I go about grouping by the year field and giving the sum of both the 1month and 2month fields. E.G. Year 1month 2month 2003 2...

Hi, Im using this code: **************************************** Dim objword, objdoc Set objword = GetObject("c:\simon\mailmerge.doc", "word.document") objword.Application.Visible = True objword.MailMerge.OpenDataSource Name:="C:\simon\db2.mdb", LinkToSource:=True...

Hi this morning our intranet has suddenly come up with this message when you try to got to the home page at http://ftc An error has occurred in the web site: Error Code Error description Error Source 13 "Type mismatch" "Global.asa 3" and the url goes to...

Hi, I have a form which has code in the beforeupdate event which is used to validate records. It all works fine except that I would like to make it so that when the user clicks the close button and the record does not meet the validation rules the form stays open so they can make the necessary...

Hi im trying to set up our HR database so that it prevents users from entering duplicate records. Im reasonably sure that I must use the beforeupdate event the dlookup function in some way to do this. However my code: Private Sub Form_BeforeUpdate(Cancel As Integer) ' used to find duplicates...

I was just wondering why our transacton log seems to shrink a little every now and again even though "autoshrink" and "truncate log on checkpoint" options are off SQL Server 7.0 Cheers Simon.

Hi i've written this: for /f "tokens=1-4 delims=/ " %%a in ("%date%") do set dude=%%d%%b%%c md %dude% which makes a directory based on todays date. It works on 2000, but annoyingly does not work on NT4 Server. Has anybody got any ideas what the problem might be. Cheers, Simon

Hi Ok heres the problem, i recently started a new job. I have inherited a load of Access/Sql server applications put together by my predessor. A lot of them use the "Microsoft Internet Transfer Control 6.0" to ftp files to/from unix. The FTP on most applications seems to work fine but on some...

I use this command which works perfectly when I run it in the dos window (ftp utility): cftp -s 10.246.154.204 -u import -p import -l "c:\test" and it returns this if I use it in SQL Server: The name specified is not recognized as an internal or external command, operable program or batch...

Hi, I have a command exec job which copies a file from a mapped network drive (which is on a unix machine) and when it runs it says "access is denied" in the job history. However when I log in on the SQL Server machine using the same account used by sql server agent and try the command it works...

Hi, I have a command exec job which copies a file from a mapped network drive (which is on a unix machine) and when it runs it says "access is denied". However when I log in using the same account on the SQL Server machine and try the command it works ok. One thing I noticed is that agent and...

Hi, I currently doing some quite large inserts into sql server. I have managed to do them sucessfully (dropping no rows)using BCP, using a format file. However I read somewhere that BULK INSERT is faster than BCP so I tried using this instead. Oddly enough it drops quite a few rows, even when I...