Search results for query: *

Thanks Billy Ray

Hi I have the following html <table width="100%" border="0" cellpadding = "0" cellspacing = "0" bgcolor="#DCDCC8" > <tr> <td> <img src="banner.jpg" border="0" alt=""> </td> <td> &nbsp </td> </tr> </table> hoping that the height of the table would match that of the image...

I think you may have forgotten something Gnat ;-) Cheers Simon

Hi, I'm trying to look at having a user's logging into an ASP SQL server APP via authentication/trusted connection alone how is it possible for ASP to connect, using a trusted connection, to SQL server. Authenticating using the clients NT account. Is this possible at all. Cheers

Fantastic ED, I saw the Get external data option, but thought that it would import the whole database on pointing to the database that I wanted to import from and clicking import - didn't realise that it gave me a further dialog to choose which components ;-)

Hi I have a report in on mdb that ~I would like to import/migrate to another mdb. Is there a simple way of achieveing this Cheers

Thanks gradley, I thought as such, but just wanted to make sure

Hi I'm using an ActiveX script. I would like to explicitly declare a variable as a string, but activex scripting does not appear to like dim variable as [string/integer/boolean/whatever] All variables seem to have to be declared as without a datatype essentially making them variants Am I...

Thanks Chaps, It really is a bit of a shot in the dark, as you say it could be anything. Some machines can connect, some cannot. The database is fronted by an application that people access through a Citrix metaframe connection. The connection from the citrix server to the Database server...

Hi we've been having this problem with a server for a couple of months. After a few days of this server having re-booted, I find that when I try and view the SQL Server instances in Enterprise Manager (all instances are registered with sa on my copy of EM), I can view the running server, I can...

LOL, I'm almost tempted to give you a star for a great bit of lateral thinking James. Unfortunately it is possible for there to be more than one member sharing the most number of roles in which case I'd like both/all reported ;-) Thanks Manjarikosaraju this has given me a pointer Could you...

manjarikosaraju, unfortunately Top x is not available in SQL Server 6.5 which is where I'm having problems at the moment ;-)

Having a bit of mind going blank day I have a parent table Member Membership_no (char(10)) PK First_name (char(30)) Surname (char(30)) and a child table Role_no (char(10)) PK Membership_no (char(10)) FK ...and various other fields I want a query to return the...

Thanks Tom I'll give that a try. Will blanking the recordsource for the report not have an effect on the bound fields ?

I am completely new to access, so this is a complete newbie question I have a report that is bound and has all of its controls bound to a query. I would like to run this report for 2 different sets of criteria one after the other DoCmd.OpenReport reportname 'using first criteria...

Thanks Trollacious, I've found the problem: It appears that in firefox, that there is a setting to allow Javascript to "change images

Hi I have a script that I'm migrating from IE to FireFox. Some of my mouseover events do not seem to work. The existing code changed the .src of an image by referring to it as an element in the images array document.images[n].src = 'newimage.gif' This code does not appear to work in...

Ooops Sorry, got carried away there James with the UPDATED keyword ;-)

Thanks James - spot on it's running 6.5 compaitibility level. Incidentally when I try to add a trigger that references the updated, inserted or deleted cursors, it doesn't recognise them say that it can't find table UPDATED, INSERTED or DELETED. Would this be related at all (having never used...

I have inherrited a SQL 7 Database. Although it appears not to support the Syntax Select top n from table. this always results in "incorrect syntax near 10". The database was upgraded apparently from 6.5. @@version displays Microsoft SQL server 7.0 - 7.00.1063. It was my understaing that...