- Private Sub cmdsave_Click()
-
-
If imagebox.Picture = LoadPicture("") Then
-
MsgBox "Please browse the image you want to add to your database.", vbExclamation, "Image required"
-
browseimage
-
Exit Sub
-
-
ElseIf shotcombo = vbNullString Then
-
-
MsgBox "Please provide shot number.", vbExclamation, "shot number required"
-
shotcombo.SetFocus
-
Exit Sub
-
End If
-
-
'Add mode only
-
If addmode = True Then
-
-
Set storyboard = New Recordset
-
storyboard.Open "SELECT * FROM shot", CON, adOpenKeyset, adLockOptimistic
-
storyboard.AddNew
-
storyboard("shot") = shotcombo
-
storyboard("filename") = Filename
-
storyboard.Update
-
-
SavePicture imagebox.Picture, App.Path & "\" & Filename
-
-
question = MsgBox("Image saved to database. Do you want to add another image?", vbExclamation + vbYesNo, "Image saved")
-
-
If question = vbYes Then
-
resetfields
-
Else
-
Unload Me
-
End If
-
End If
i can able to add only my 2 fields using this save command. i want rest of my fields get saved using this save command. how to do that.
other fields are, sequence, scene, action and dialogue. i tried using if condition but didn't work.
help me out
3 1329
Hi. You can add the other fields in this section: - Set storyboard = New Recordset
-
storyboard.Open "SELECT * FROM shot", CON, adOpenKeyset, adLockOptimistic
-
storyboard.AddNew
-
storyboard("shot") = shotcombo
-
storyboard("filename") = Filename
-
storyboard("anotherfield") = anotherfield
-
storyboard.Update
Hi. You can add the other fields in this section: - Set storyboard = New Recordset
-
storyboard.Open "SELECT * FROM shot", CON, adOpenKeyset, adLockOptimistic
-
storyboard.AddNew
-
storyboard("shot") = shotcombo
-
storyboard("filename") = Filename
-
storyboard("anotherfield") = anotherfield
-
storyboard.Update
thank u so much, its working.
thank u so much, its working.
You are very welcome :)
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Andras Gilicz |
last post by:
Hi VB fans
I'm working on a relatively large project in VB6 with about a dozen
forms, including graphs, labels, text boxes, etc. The software itself
is actually a flow simulator with more or...
|
by: kbarsi |
last post by:
I have created a new web form .aspx in VS.net with a couple of fields. I
would like to add a button that when clicked will save the information from
the fields into a
newly created record in my...
|
by: Mike MacSween |
last post by:
Well, I suppose it was only 20 minutes work, but it would have been nice if
I'd been prompted to save that new code module. After all, they ask you if
you want to save new forms, reports etc.
|
by: Øyvind Isaksen |
last post by:
I have a page with an optional integer-field, and one asp:calendar control.
I use a stored procedure to save the data in SQL Server.
When all fields contains data, the code works great! But if the...
|
by: kevin.vaughan |
last post by:
Hello Everybody and Everymind,
I am using Access 2003 on an XP network.
The code below activates from a command button on a form. It selects
data from a table and then displays it in a cell on...
|
by: georges the man |
last post by:
hey guys,
i ve been posting for the last week trying to understand some stuff about c and reading but unfortunaly i couldnt do this.
i have to write the following code. this will be the last...
|
by: squrel |
last post by:
Hello everyone,
I m using some button using toolbar such as Add,Save,View,.... my save button is not working.... it doesnt give me any error but does not save to my database.... or showing in my...
|
by: terrybell105 |
last post by:
I downloaded Stephan's utility from his website but can't get it to
work - or maybe I'm not driving it properly!
The form works OK with the existing 3 "views" - I can switch between
them and they...
|
by: mokoujan |
last post by:
Hello all
I am currently developing a WCF REST service. One of the requirements
is to allow the users to search data via the rest interface. As such
key field information is passed in the URL....
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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...
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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...
|
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,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |