473,320 Members | 2,112 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to saving Form data into an unlinked table as a new record?

hello,

right, i have a form (currently form1) and this is a data entry form where users write in details about borrowing a book, when i click a save button, i need this data to be saved into a unlinked table (called Loan) as a new record, under the correct field names, e.g. "loan date" on the form to be saved under the "loan date" heading in the table.

is there a way to do this?

thanks.
Dan.
Jan 30 '11 #1

✓ answered by Rabbit

You could link the table. But if for some reason you can't do that, just use code to create a connection object to the database and run an insert SQL.

4 2266
Rabbit
12,516 Expert Mod 8TB
You could link the table. But if for some reason you can't do that, just use code to create a connection object to the database and run an insert SQL.
Jan 30 '11 #2
do you know the code to make the connection from the text box to the fields in a table?

im sorry i'v not used access before
Jan 30 '11 #3
Rabbit
12,516 Expert Mod 8TB
Is there a reason why you don't link the table?
Jan 30 '11 #4
i wasnt linked to a table because i thought that having the link would stop the data being altered or entered.
i've now found out otherwise and have resolved the problem by creating a new form with this link,

thankyou :)
Jan 30 '11 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Mike | last post by:
I have a form that certain information on it. On this form there is a button that opens a payment form. When the payment form opens I enter a payment type, check cash charge, payment number,...
1
by: nic | last post by:
Hi I have two forms form1 and form2. I am trying to get all the data entered in form1 to be updated to the table on an event. ie. when I click the button to load form2, I need the data from...
3
by: Mike | last post by:
Hello: I was not able to find a regular ASP group, so I posted this here instead. I have a web app which is actually just ASP using VBScript as the server-side language, running on IIS6. ...
2
by: Prashantsd | last post by:
Hi, I just wanted to know if it is possible to save the form data into different table. The combox box list are from the different tables and want save in another new table. What are the...
5
by: lousylife | last post by:
hi guys, im new here!! want to ask something how to save the data from the check boxes and radio buttons in your database, using asp commands! In check boxes, mulitiple selections while in radio...
3
by: roseredphoenix | last post by:
Can anyone help me with a form I'm trying to make? I'm trying to make a submission form for my school's literary magazine. I need to put the submitted information into a database. I know I need to...
1
by: gshawegypt | last post by:
Hi.... Using Access 2003.. I need help with the following... I have a form with a series of option combo's which as selected, filter data to the end chose.. I would like to record the...
3
by: mirianCalin | last post by:
the code saves the category, image title, image, and feature.. but the problem is that the "feature" is not saved, but the others were saved.. this is the data types of my table category = text...
0
by: Martin Arvidsson, Visual Systems AB | last post by:
Hi! I have a couple of newbee questions. I have a .aspx page with a couple of TextBoxes and a submit button. Now... When i press the submitbutton i want the data in the TextBoxes to be...
5
by: MeeMee | last post by:
Hi I have a problem with saving form data to a MS Access database. I am using Windows XP, FrontPage 2003, Access 2003, IIS 5.1 and FrontPage Server Extensions. I have followed several tutorials...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.