please help me over my project. . .
how to create a program using adodc.as in the case of a library searching and saving accounts. . .
thanks. . .
17 1451
please help me over my project. . .
how to create a program using adodc.as in the case of a library searching and saving accounts. . .
thanks. . .
We are not doing assignments/homeworks here. Attempt to create that program and if you have some problems that's the time we can help you. Please observe posting guidelines : )
Sorry yosh29rs, but TheScripts is strictly English-only. I've deleted your post.
We are not doing assignments/homeworks here. Attempt to create that program and if you have some problems that's the time we can help you. Please observe posting guidelines : )
please help me over the codings.. . . i really need it asap. . .really badly. . .thanks
please help me over the codings.. . . i really need it asap. . .really badly. . .thanks
Can you kindly post what you have tried sofar .
please help me over the codings.. . . i really need it asap. . .really badly. . .thanks
OK, I'll try. Just post some of your codes here : )
these are what ive tried.some of the codes doesnt work.thanks for the help - Private Sub cmdClr_Click()
-
txtFname = ""
-
txtLname = ""
-
txtMname = ""
-
txtAddC = ""
-
txtAddZ = ""
-
txtAddB = ""
-
txtDate = ""
-
txtId = ""
-
txtDatebirth = ""
-
End Sub
-
-
Private Sub cmdSave_Click()
-
Adodc1.Recordset.AddNew
-
-
'let the fields of the database table hold the value on your textboxes
-
AdoNew.Recordset.Fields("fname") = txtFname.Text
-
AdoNew.Recordset.Fields("lname") = txtLname.Text
-
AdoNew.Recordset.Fields("mname") = txtMname.Text
-
AdoNew.Recordset.Fields("addb") = txtAddC.Text
-
AdoNew.Recordset.Fields("addz") = txtAddZ.Text
-
AdoNew.Recordset.Fields("addc") = txtAddB.Text
-
AdoNew.Recordset.Fields("date1") = txtDate.Value
-
AdoNew.Recordset.Fields("id") = txtId.Text
-
AdoNew.Recordset.Fields("datebirth") = txtDatebirth.Value
-
'Save the record on the database table
-
AdoNew.Recordset.Update
-
-
'Inform the user
-
MsgBox "Add New Successful!", vbInformation, "SUCCESSFUL"
-
-
End Sub
-
-
Private Sub Command4_Click()
-
Unload Me
-
End Sub
-
-
End Sub
-
-
Private Sub cmdSaveAdd_Click()
-
Adodc1.Recordset.AddNew
-
-
'let the fields of the database table hold the value on your textboxes
-
AdoNew.Recordset.Fields("fname") = txtFname.Text
-
AdoNew.Recordset.Fields("lname") = txtLname.Text
-
AdoNew.Recordset.Fields("mname") = txtMname.Text
-
AdoNew.Recordset.Fields("addb") = txtAddC.Text
-
AdoNew.Recordset.Fields("addz") = txtAddZ.Text
-
AdoNew.Recordset.Fields("addc") = txtAddB.Text
-
AdoNew.Recordset.Fields("date1") = txtDate.Text
-
AdoNew.Recordset.Fields("id") = txtId.Text
-
AdoNew.Recordset.Fields("datebirth") = txtDatebirth.Text
-
'Save the record on the database table
-
AdoNew.Recordset.Update
-
-
'Inform the user
-
MsgBox "Add New Successful!", vbInformation, "SUCCESSFUL"
-
txtFname.Text = ""
-
txtLname.Text = ""
-
txtMname.Text = ""
-
txtAddC.Text = ""
-
txtAddZ.Text = ""
-
txtAddB.Text = ""
-
txtDate.Text = ""
-
txtId.Text = ""
-
txtDatebirth.Text = ""
-
-
-
End Sub
-
-
Private Sub cmdClr_Click()
-
Dim ctrl As Control
-
For Each ctrl In Me
-
If TypeOf ctrl Is TextBox Then
-
ctrl.Text=""
-
End If
-
Next
-
End Sub
-
-
Private Sub cmdSave_Click()
-
Adodc1.Recordset.AddNew
-
-
'let the fields of the database table hold the value on your textboxes
-
AdoNew.Recordset.Fields("id") = txtId.Text
-
AdoNew.Recordset.Fields("fname") = txtFname.Text
-
AdoNew.Recordset.Fields("lname") = txtLname.Text
-
AdoNew.Recordset.Fields("mname") = txtMname.Text
-
AdoNew.Recordset.Fields("addb") = txtAddC.Text
-
AdoNew.Recordset.Fields("addz") = txtAddZ.Text
-
AdoNew.Recordset.Fields("addc") = txtAddB.Text
-
AdoNew.Recordset.Fields("date1") = txtDate.Text '<<<What's the format of your Date?
-
AdoNew.Recordset.Fields("datebirth") = txtDatebirth.Text '<<<What's the format of your Date?
-
'Save the record on the database table
-
AdoNew.Recordset.Update
-
-
'Inform the user
-
MsgBox "Add New Successful!", vbInformation, "SUCCESSFUL"
-
-
End Sub
-
-
Private Sub Command4_Click()
-
Unload Me 'Exit Form
-
End Sub
-
Rey Sean
I think for getting the date values it is better to use maskededit box, or datepicker : )
thank you for your kind and concern reply lotus. . .id like also to hear from our experts but it seems that their pretty bush huh
There's something I don't understand about this code. Shouldn't Adodc1 and AdoNew actually refer to the same thing?
There's something I don't understand about this code. Shouldn't Adodc1 and AdoNew actually refer to the same thing?
Oh sorry for that, it should be AdoNew : )
Oh sorry for that, it should be AdoNew : )
Could this be the source of some problem?
our instructor was so mean about the system i made. . .i really dont understan her. . .how cn i improve my programing language?
our instructor was so mean about the system i made. . .i really dont understan her. . .how cn i improve my programing language?
Well, one of the most important things in programming is that you must pay attention to the details. For instance, a quick glance at this post shows very sloppy use of English - are you even aware of it. A bit of precision might help. Is your programming as rough as this? The tiniest typo or wrong variable name can have big consequences - for example, see the bug I pointed out in post #10.
Also, consider the specific criticisms provided by your instructor. And finally, try tracking down a book or two on things like programming style. I don't think there's any simple way we can tell you how to program "better".
Well, one of the most important things in programming is that you must pay attention to the details. For instance, a quick glance at this post shows very sloppy use of English - are you even aware of it. A bit of precision might help. Is your programming as rough as this? The tiniest typo or wrong variable name can have big consequences - for example, see the bug I pointed out in post #10.
Also, consider the specific criticisms provided by your instructor. And finally, try tracking down a book or two on things like programming style. I don't think there's any simple way we can tell you how to program "better".
oh, is that so? well we filipinos really write things in shortcut manners. . .because we are so frugal on spending stuffs. . .
is it not okay?just because you dont get it?
maybe a visit here in the pjil will explain things much better. . .
oh, is that so? well we filipinos really write things in shortcut manners. . .because we are so frugal on spending stuffs. . .
is it not okay?just because you dont get it?
maybe a visit here in the pjil will explain things much better. . .
Two questions... - How does dropping letters out of words constitute being "frugal"? (An extra letter costs you more, does it?)
- What does pjil mean?
Two questions... - How does dropping letters out of words constitute being "frugal"? (An extra letter costs you more, does it?)
- What does pjil mean?
I think he's referring Pjil. to Phils. (Philippines)
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Andreas Lauffer |
last post by:
I changed from Access97 to AccessXP and I have immense performance
problems.
Details:
- Access XP MDB with Jet 4.0 ( no ADP-Project )
- Linked Tables to SQL-Server 2000 over ODBC
I used...
|
by: WertmanTheMad |
last post by:
Ive been playing with this for a few days and thought I might thow it
out for seggestions.
I have Several Queries that need counts returned
The Queries are Mutually Exclusive meaning whatever...
|
by: Roger Green |
last post by:
I have inherited a complex database that has many dozens of queries that derive data from a people
table.
I now need to be able to run these queries (from within a significant number of forms)...
|
by: Dom Boyce |
last post by:
Hi
First up, I am using MS Access 2002.
I have a database which records analyst rating changes for a list of
companies on a daily basis. Unfortunately, the database has been set
up (by my...
|
by: NeilAnderson |
last post by:
I'm a fairly new user of access & I've never had any training, so I'm
wondering if I'm doing the right thing here, or if it matter at all.
I'm building a database for room booking purposes and I'm...
|
by: Jerry Hull |
last post by:
I'm working with a database developed by an untrained person over
several years - and on a network that has recently been upgraded with
a new server installed and MS office upgraded from 2K (I...
|
by: MHenry |
last post by:
Hi,
I know virtually nothing about creating Macros in Access.
I would appreciate some help in creating a Macro or Macros that
automatically run(s) 14 Queries (three Make Table Queries, and 11...
|
by: Greg Strong |
last post by:
Hello All,
Is it better to create a query in DAO where a report has 4 sub-reports
each of whose record source is a query created at runtime and
everything is in 1 MDB file?
From what I've...
|
by: loosecannon_1 |
last post by:
Hello everyone, I am hoping someone can help me with this problem. I
will say up front that I am not a SQL Server DBA, I am a developer. I
have an application that sends about 25 simultaneous...
|
by: marshmallowww |
last post by:
I have an Access 2000 mde application which uses ADO and pass through
queries to communicate with SQL Server 7, 2000 or 2005.
Some of my customers, especially those with SQL Server 2005, have had...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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: 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:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |