Unable to save record in access using javascript

Expand|Select|Wrap|Line Numbers

 <html>

<head>

<script type="text/javascript" language="javascript">
 
function validate()

{

 if (document.form.fname.value=="")

 {

 alert("Enter your Name");

 document.form.fname.focus();

 return false;

 }
 
 if (document.form.age.value=="")

 {

 alert("Enter your Age");

 document.form.age.focus();

 return false;

 }
 
 if (document.form.mnumber.value=="")

 {

 alert("Enter your Mobile Number");

 document.form.mnumber.focus();

 return false;

 }
 
 if (document.form.email.value=="")

 {

 alert("Enter your Email ID");

 document.form.email.focus();

 return false;

 }
 
 if (document.form.addr.value=="")

 {

 alert("Enter your Address");

 document.form.addr.focus();

 return false;

 }

 var cn = new ActiveXObject("ADODB.Connection");

 var strcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Documents and Settings/Imtiaz Sheriff/Desktop/Mini project1/Project/busbooking.mdb;Persist Security  
 
Info=False;"

 cn.open(strcon);

 var rs = new ActiveXObject("ADODB.Recordset");

 var fullname1=document.getElementById('fname').value;

 var age1=document.getElementById('age').value;

 var mobileno=document.getElementById('mnumber').value;

 var emailid1=document.getElementById('email').value;

 var address=document.getElementById('addr').value;

 var row1="insert into customerdetails(fullname,age,mobno,emailid,addr) values (fullname1,age1,mobileno,emailid1,address)";

 rs.open(row1,cn)

 alert("Record submitted successfully");

 cn.close;

}

</script>

</head>
 
<body>

<form action="home.html" method="link" onsubmit="return validate()" name="form">

<h1 align="center">Online Bus Booking</h1>

<table border=0 bgcolor="#FF99CC">

<tr>

    <td><a href="Home.html">Home Page</a>

</tr>

</table>

<br><br><br><br>

<table border="0" align="center">

<tr>

    <th cols="2"><h3>Customer Details</h3></th>

</tr>

<tr>

    <td>Full Name: </td>

    <td><input type="text" name="fname" size="20"></td>

</tr>

<tr>

    <td>Age: </td>

    <td><input type="text" name="age" size="10"></td>

</tr>

<tr>

    <td>Mobile Number: </td>

    <td><input type="text" name="mnumber" size="10"></td>

</tr>

<tr>

    <td>Email ID: </td>

    <td><input type="text" name="email" size="20"></td>

</tr>

<tr>

    <td>Address: </td>

    <td><input type="text" name="addr"></td>

</tr>

<tr>

    <td><input type="submit" value="Submit" onclick="return validate()"></td>

    <td><input type="reset" value="Reset"/></a>

</tr>

</table>

</form>

</body>

</html>

Dec 13 '09 #1

Subscribe Post Reply

2813

gits

5,390

Expert Mod 4TB

you should describe what the error or issue exactly is - just posting code doesn't help much since we need to know what the problem is.

kind regards

Dec 14 '09 #2

by: Huw Davies | last post by:

I have created a split MDB that was intended for use on a single PC.The user has asked for it now to be setup as a multi-user (without security) system. I have placed the "application" mdb on...

Microsoft Access / VBA

Unable to Delete a Record

by: Susan Bricker | last post by:

I have a command button on a form that is supposed to Delete the record being displayed. The record is displayed one to a form. The form is not a Pop-Up nor is it Modal. Tracing the btnDelete...

Microsoft Access / VBA

Unable to Close Popup window using ASP.Net

by: GrantS | last post by:

I am having a problem closing a popup window opened modally. When I try to close the window (when the user hits save button and the data has been processed), the Popup window opens as a full screen...

C# / C Sharp

Unable to open attachment

by: Seok Bee | last post by:

Dear Experts, In my web application, I'm having a button to view an attachment. After I retrieve the record from database (Ms. Access), I have a button to view the attachment (if there is any)....

.NET Framework

Unable to open file

by: Seok Bee | last post by:

Dear Experts, In my web application, I'm having a button to view an attachment. After I retrieve the record from database (Ms. Access), I have a button to view the attachment (if there is any)....

Visual Basic .NET

Unable to Display Image from database at runtime

by: den 2005 | last post by:

Hi everyone, Here is code working on..Trying to insert record with a column with Image or VarBinary datatype in sql database from a existing jpeg image file, then retrieve this image from...

ASP.NET

How to work out which script to call to Save

by: Angus | last post by:

I have a web page with a toolbar containing a Save button. The Save button can change contextually to be a Search button in some cases. Hence the button name searchsavechanges. The snippet of...

Javascript

Save Current Record on a Form

by: Ian | last post by:

I am trying to save the current record on a form before opening a report, doesn’t sound to hard does it? The code on a buttons on click event goes like this: DoCmd.DoMenuItem acFormBar,...

Microsoft Access / VBA

Funky Save Record Stuff

by: Neil | last post by:

Was working in A2003 and noticed that the Save Record item on the Records menu was not available when the record was not dirty. In A2000, Save Record was always available. (This is a problem for me...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Unable to save record in access using javascript

Similar topics