Recent content by bloody_football

I have a .TXT file with all my databases, it's the first thing you see when you go into that section, the title of the file is "0 - Don't forget, if you compact the database then the permissins get changed" and the file is empty :) Hope that helps. James

You cannot view Access pages over the Internet and the MS access wizard only creates pages that can be viewed over the LAN. I made a database for a company I worked for which worked perfectly over the office LAN; then the company expanded interstate so I needed for our interstate salespeople to...

'END IF' is not needed if you do the 'IF ... THEN' on the one line of code. I did get an answer from another forum - EXECUTE "CALL " & temp That works fine :)

using a variable to make a call() I would like to make a call() based on the variable name. So far I have - temp = "d" & Session("where") If temp = "d51" then Response.Write "Hello" Call temp() If the variable is 51 then I will get the output "hello" but the call won't work; my error is...

Free websites are usually worth the price that you pay for them (usually free web sites advertise on your web pages which can create all sorts of problems); I have never heard of a good free web site. Usually your ISP gives you some web space though; take it up with them. If your computer is...

Is there a way of making a report in access and then displaying that report as a HTML/ASP page? This report would be dynamic and created each time the user requests it. James

strSQL = "SELECT * FROM TableName" gives me a 'Syntax error in FROM clause. ' The table name is 'set' so it is definately not a spelling error :) James

Dim rsSet strSQL = "SELECT * FROM set_query" Set rsSet = Server.CreateObject("ADODB.Recordset") rsSet.Open strSQL, objConn Now this gets all the info out of a query but I to get the info straight out of the table.

I've played around a bit but now have problem with the size of the <TD> I write <td align="center" width="12" height="12"> but when I put a image in it that is larger than the <TD> then the cell is expanded, I don't want that - I would like the image to resize itself to the <TD> size that I...

Thanks monkey, I'll play around with it and see what happens :) James

I have made a large table (1 * 1) in HTML but wish to know if I can put a graphic anywhere in the table; at the moment there is only align left, center or right. For example - I wish to put a small graphic 20% in from the left hand side and 60% down from the top line. Any suggestions would be...

Sorry about the late reply Kodo, I forgot to put this thread in my subscription box! Yes the whole word is there in the database, it still only shows the first word of the name :(

Just a general question - Is there a limit on how many Session variables you can have? or should have? I have seen the code of a forum board made from ASP and they have about 80 pages of scripts and about 400 variables. Is there a limit to how long an ASP script can be before it slows down...

Oops sorry. I have 4 records in a database A - James, B - Darren, C - Emma & D - Anne. Is there a way of swapping the records (and all the info) of B & C? I realise I can get the data in any order but I would like the option of swapping data.

I have a list of records but there comes a time when I wish to swap records around; is there a way of doing this in ASP?