Single field to multiple records in one transaction??

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default 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

  2. Similar Questions and Discussions

    1. 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...
    2. 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...
    3. 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...
    4. 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...
    5. 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,...
  3. #2

    Default 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...
    > 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

    Ray at Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139