Search results for query: *

woops - have corrected the code below but now have errorMicrosoft VBScript compilation (0x800A0409) Unterminated string constant At line MM_editTable = "tblAttendee" MM_fieldsStr = "txtTraineeID|value|txtCourseID|value|txtPMExperience|value|txtCurrentProject|value|txtBenefits|value|...

Many thanks for your time here. Have tried as suggested but still the error Microsoft OLE DB Provider for ODBC Drivers (0x80040E07) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. AAarrrggghhh. If anyone can help, much appreciated - is driving me mad :)...

On the same page further down is ... <form ACTION="<%=MM_editAction%>" METHOD="POST" name="frmCourse"> <% Dim varCourseId, varTraineeID varCourseID = Request.QueryString("CourseID") varTraineeID = Session("TraineeID") %> <input type="hidden" name="txtTraineeID" value="<%=varTraineeID%>">...

Many thanks for your quick reply - have been working on similar this morning. Tried your suggestion but getting error: Microsoft OLE DB Provider for ODBC Drivers (0x80040E07) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. Relates to line 46 - the...

Hi all I have 'inherited' a half finished training database web application created using Dreamweaver Ultradev and MS Access 2000. I have a page that allows a user to book on a course - they log in first (they have a unique ID) and their details are picked up and passed to the booking form...

Hi all Got a form submitting entries to an Access database. Does anyone know how to pick up the date the form is submitted to store it in one of the database fields? I can use server variables to pick up the users IP but seemingly not the date the form is submitted? Very grateful anyone's...

Suddenly this morning all my forms are showing the following error on clicking submit: FrontPage Error. User: please report details to this site's webmaster. Webmaster: please see the server's system log for more details. However, form details entered are actually recorded on the server and...

Many thanks everyone for your help and useful advice- have now resolved and got isNumeric working properly.

tsuji - thanks but doesn't work. Also Just tried - othPhone = trim(objRS("OtherPhone")) othPhone2 = Left(othPhone,1) if othPhone2 = [0-9] then Response.write "<tr><td><b>Other Phone: </b>6" & objRS("OtherPhone") Response.write "</td></tr>" else...

It's just occurred to me that isNumeric is not correct - really i want to check if there is a string with numbers in it not letters or null. For example, the field could contain nothing, a 4 digit number as a string, the letters N/A or the word NONE. If it's a 4 digit number as a string i want...

thanks both of you - even with the syntax fix there is no error but it doesnt work so i suspect as you say ggriffit, I'm not getting a number back. Are you able to help with more detail on how to 'convert it to a number instead and trap errors or use a Regular Expression'? thankyou!

Very grateful for anyone's thoughts on the below. I want to look at a field entry (OtherPhone field) in a database and check if the entry is numeric. If it is numeric i want to print the contents of the field with a 6 in front of it. If not numeric i just want to print the contents of the...

Success!!! Thank you very much for your help :)

Thanks - doh! - can't believe i missed that - however still a problem after i have corrected this - error is as below - very grateful for any thoughts... Microsoft VBScript compilation error '800a0401' Expected end of statement /phone/searchresultb.asp, line 132 Response.write "<a href=...

I've created a keyword search which displays a list of names as hyperlinks - clicking a name takes the user to a second page with details about that name e.g. phone number, email, fax etc. It's paginated also - showing 10 records at a time. The error shows the following part of my code as the...

Drex - you're a star - it works - many many thanks - was ripping my hair out :) The key to this was changing the form from 'post' to 'get' and 'request.form' to 'request.querystring' throughout script. Happy Christmas and best wishes for 2005 to all...

Thanks Drex for taking the time to help - tried this but still have problem. Doesn't throw up an error when make change you suggested and appears ok when i hover over link to page 2 for results of entering 'st' but when i click on page 2 it takes me to page 2 of results i would get if i...

Thanks very much for this - sorry - can you please show me how to do this - everything i have tried hasn't worked?

I have code below to pull out a list of documents from an Access 2000 database - some of which will appear as links to the file (depending on whether a filename is placed in the document field). The user enters text to a search box - a simple keyword search. The problem is that when pages are...

I am also trying to do this. I have used MS Knowledgebase article at http://support.microsoft.com/default.aspx?scid=kb;en-us;210100 to create a form where i type an image name to add it to the database. I would like to add a button that will allow me to browse to the image instead of typing...