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 insert multiple option button which is on a frame into oracle database?

Hi All,I'm having problem with the frame, I try to insert the option button value which is on Frame 1 but it didn't store in database,it only store the value for Text1,Text2 and Text3. I'm new in VB,hope someone can help me, I'm really appreciate. Thank you =)

Expand|Select|Wrap|Line Numbers
  1. Dim con As New ADODB.Connection
  2. Dim cmd As New ADODB.Command
  3. Dim rs As New ADODB.Recordset
  4. Dim cn As String
  5.  
  6. Private Sub CommandButton1_Click()
  7. con.Open cn
  8. cmd.ActiveConnection = con
  9. con.CursorLocation = adUseClient
  10.  
  11. rs.Open "INSERT INTO TRY_REVISE(TRY, TRY_COMPONENT, TRY_CONDITION,TRY_STEP) Values ('" & Text1 & "', '" & Text3 & "', '" & Text2 & "','" & Frame1 & "')", con
  12.  
  13. Call Frame1
  14. MsgBox ("Successfully Save")
  15. End Sub
  16.  
  17.  
  18. Private Sub Frame1_Click()
  19. If Option1.Value = True Then
  20. Value = "Reposition"
  21.  
  22.  Else: Option2.Value = True
  23. Value = "Hold/Release"
  24.  
  25.  
  26. End If
  27. End Sub
May 12 '15 #1
1 1500
I'm sorry,its already 1 week,hope someone who expert or have face the same problem to help me. I'm really appreciate it. I'm already google but I can't find about that.
May 20 '15 #2

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

Similar topics

1
by: Mark | last post by:
Hi All, Is there anyway I can select an option button by clicking a command button? From what I have found out so far, unlike a check box, and option button has no value so I can't assign it one....
1
by: Stephen D Cook | last post by:
What I am trying to do is have a set of option buttons which are required to click one. If the person doesn't click any before insert, they get an error. If they do click one, it inserts into the...
1
by: Stephen D Cook | last post by:
In my form I have an option group with 3 option buttons. My form is tied to a table. the options are Temp, Permanent and Overtime. I have these inside a frame. I have an AddRecord button to enter...
0
by: shantanu | last post by:
hi all I need to read the excel sheet for the values. The requirement is like: For the number of rows in the excel which are not null, i need to store the values of the row in a array and then...
1
by: boss1 | last post by:
i m having problem with inserting data into oracle db using php. i need to how to fetch fetch multiple row's data from a table in html form and insert into oracle db at a time. may be looping is...
58
by: bonneylake | last post by:
Hey Everyone, Well recently i been inserting multiple fields for a section in my form called "serial". Well now i am trying to insert multiple fields for the not only the serial section but also...
0
by: akshalika | last post by:
I am new to Biztalk. In my project we need to connect oracle database and insert data into oracle table using BizTalk project. I use WCF Adapter pack(SP2). I create biztalk project then using Consume...
1
by: suadik | last post by:
Am trying to insert multiple fees into my database from a select option, but when I send, only one record is inserted which is the first selection. I also want it in such a way that when I insert,...
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: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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...
1
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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....

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.