Search results

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?

I have VALUE= <% =rsPlayers("name") %> > which is fine if rsPlayers("name") doesn't have a space in it, if it does then it only prints up to the space. So "Mr Nooby" only comes out as "Mr". Does anyone know the way of printing out the full word? James

Thank you :)

I have thousands of cards in my database. If the name of the card has the ' symbol in it (e.g Aladdin's Ring) then the database returns an error because it beleives the ' in the name is an instruction. Any way around this? James

thanks anyway :) I've decided to use a 'replication' of the database, still reading up on it to make sure I do it properly :D James

Default open mode = shared Default record locking = No Locks