Ask a Question related to ASP Database, Design and Development.
-
Scott #1
Single field to multiple records in one transaction??
Im hooking into an Access 2k database via FrontPage 2k... I want to submit a single text box into 5 new records at once.
Any help would be much apreciated.
Thanks
Scott Guest
-
Multiple values into a single field
Hi, I've created a form that is all radio buttons, each question looks like: <legend>Choose the option which best describes your hair... -
CF Multiple Queries, Multiple Records
All, I've got three queries all passing variables from previous queries. The issues? The second query returns 4 records. I want to use IDs for... -
update multiple records in multiple tables from one form
hello I have been trying to run multiple update queries based on the data entered by user. Brief background: I am fetching data from various... -
form: single line -- multiple text boxes -- one typing field - how?
please excuse my ignorance. am a newbie. I saw a fillable form, that shows:- a single line with multiple text boxes for entering each letter of a... -
Is there a way to assign multiple variables a single value on a single line?
i tried $f1, $f2, $f3 = '1'; and list($f1, $f2, $f3) = 1; neither work... second obviously cuz its looking for an array on the right side,... -
Ray at #2
Re: Single field to multiple records in one transaction??
Dim oADO
Set oADO = CreateObject("ADODB.Connection")
oADO.Open YourConnectionStringHere
For i = 1 to 5
oADO.Execute "INSERT INTO [yourTable] ([yourColumn]) VALUES ('" &
YourTextboxValue & "')"
Next
Ray at work
"Scott" <srmollett@yahoo.co.uk> wrote in message
news:53FD1D50-1ADB-4FA0-8312-CAFE4DB82A0A@microsoft.com...a single text box into 5 new records at once.> Im hooking into an Access 2k database via FrontPage 2k... I want to submit> Any help would be much apreciated.
>
> Thanks
Ray at Guest



Reply With Quote

