Search results for query: *

thanks QatQat here is my code for select box <form name="addtraining" action="grouptraining.asp" method="POST"> <table border="0" cellspacing="0" cellpadding="0" align="center" width="100%"> <tr> <td valign="top" width="175" bgcolor="#000099"> <select...

hi guys, I need some one to help me on how to insert multiple records in a table. I used multiple selct list box where in the user are allowed to choices as many as he/she can. my problem is if it is multiple records it did not add to my table but is doesn't appear any error message. here is...

thanks guys but i am still getting an error. after i replace the apostrophe and run the sql I get an Error Type: Microsoft VBScript runtime (0x800A0009) Subscript out of range: '[number: 1]' here is the code: for the request form: <td width="39%"><div align="center"><b>Branch...

help me again guys, I am only new in ASP world and my knowledge is not so broad. I have a back end MS Access. I need to remove the apostrophe. i mean like this: ASP's .Net when I add this i got a syntax error. i don't know how to remove, replace or escape this before they passed to and from...

I have a back end MS Access and one of this field was Start date with the format dd/mm/yyyy. In my Add form the user are going to enter the date in three text boxes ( days, month and year) I have a command to convert the date enter to become dd/mm/yyyy before it store to MS Access. But now, I...

Here is the line where the error was: 'define odbc variables strdsn = "DSN=pd;UID=pd;PWD=pd" set cn = server.createobject("ADODB.Connection") set rs = server.createobject("ADODB.Recordset") cn.open strdsn yes it is, move to other server

Hi guys, I need your help. I need to do some changes to the existing pages. I have an MS access back end database and when i am trying to view the page i recieved the following error: <b> Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Microsoft ODBC Driver Manager Drivers SQL Set...

hi guys, I need someone to help me to figure out what is wrong to my program. Everytime I run my program I always recieved a message: SQLCODE = -301, error: The value of input host variable or parameter number 005 cannot be used as specified because of its Data type. I used DB2 for my...

Thanks SQLSISITER. It really a great help.

I have a back end database in MS Access but i need to convert it to SQL server. What are the things that i need to consider before i start converting it. I have a total of 75 tables in MS Access

Thanks FormerTexan. Its really a great help

hi Bill, can you guide me which site i can find a VBA sample code for this. I have a bookmark to all my word template, now I need a sample code on how to do it in VBA. thanks for your help

I have 5 word template ready. I need to export the following field from MS Access 2000 to MS Word 2000. Lastname, First name, Company Name,Address and position I need to do it in VB code. please guide me on how to do it in function.

my front end is MS Access and my back end is MS SQL server. Dim StrSQL, StrWhere As String If Not (IsNull(TheName.Value)) Then StrWhere = "INDIVIDUAL_CLIENT.SURNAME Like '" & TheName.Value & "'" End If StrSQL = "SELECT INDIVIDUAL_CLIENT.CLIENT_ID,"...

I am trying to search a surname that start from Mc' or O' but everytime i type that in a text box and click the command search i recieved a message Syntax error in string in query expression 'INDIVIDUAL_CLIENT.surname like 'O" ORDER BY INDIVIDUAL_CLIENT.surname;" my coding: StrSQL =...