Recent content by SimonTheSponge

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