Recent content by sportypants

Right, my host has finally uploaded my site to another account where it works perfectly? They have admitted that the problem seems to relate to the account they have created and not the site. Thank you cheech for your patience and assistance, unfortunately the problem seems to lie with the...

Cheech, thanks for trying to help, the message displaying is: SELECT * FROM tblClients WHERE ClientUsername = 'abc123' ADODB.Field error '800a0bcd' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /CMembers/setsession.asp...

Thanks for the replies, Ive asked my host and they say they are enabled, can you see anything wrong with my code? Thanks, JJ

Create a field in your db something like DateStamp and in the default value an NOW() this will automatically input the date the form was successfully submitted to the database. Just add the form field as a hidden value with the value 'DateStamp'.

Please can anybody tell me what is wrong with this code? It works fine on IIS5 but not on my hosts server? <%@LANGUAGE=&quot;VBSCRIPT&quot;%> <!--#include file=&quot;../Connections/AccesoneASP.asp&quot; --> <% Dim rsAccount__strUsername rsAccount__strUsername = &quot;abc123&quot; if...

This seemed to work? Sum Of Expr1: Expr1 Oh well seems right??

Hi, I have created an expression to calculate the individual items of a customers invoice: Expr1: [tblClientInvoices]![InvoiceCost]+[tblClientInvoices]![InvoiceCost2]+[tblClientInvoices]![InvoiceCost3]+[tblClientInvoices]![InvoiceCost4]+[tblClientInvoices]![InvoiceCost5] as you can see this...

Thank you very very much for your replies, I am trying a few things now and will post the results. Thanks again for replying :)

Hi, I have developed a website using Ultradev4 and MSSQL server, locally the webiste performs perfectly, however when I upload the database to the webserver i receive this error: Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Microsoft][ODBC SQL Server Driver][SQL...

Looking for download right now :) Thanks for the advice, I will use MSDE at home after d/l. Thank you once again :)

I agree with some of your comments regarding the understanding of DB Admin, SQL Server seems quite 'Full On' as apposed to Access, We have a license for MSSQL already and I have successfully converted the access DB from our website and switched to SQL with no problems. I have used windows...

Thanks for the reply and the link, Ive just converted the access db to MSSQL and Im using it locally at the moment, I must admit I can see the difference on my local machine so Im sure its going to be much faster when its on the remote server. Thanks again for the reply :)

I know MSSQL is more efficient than Access2000 but can anyone tell me if I would notice much difference on a smallish .asp site? My site uses a few Access expressions to work our prices, store invoices and members details and is lightly scripted. I know its difficult to get an idea how much the...

Yes, I'm using CSS to create the rollover text effects for the other links, however, the links i've created to pop up the new browser window doesn't change?? Any advice?? Thanks, Jason :)

Can you send me a copy of the template? or up it somewhere to look at? hmmbead@hotmail.com