Click here to Skip to main content
14,110,039 members

S Sansanwal - Professional Profile



Summary

    Blog RSS
6,466
Author
268
Authority
76
Debator
5
Editor
1
Enquirer
58
Organiser
220
Participant
No Biography provided

Reputation

For more information on Reputation please see the FAQ.

Privileges

Members need to achieve at least one of the given member levels in the given reputation categories in order to perform a given action. For example, to store personal files in your account area you will need to achieve Platinum level in either the Author or Authority category. The "If Owner" column means that owners of an item automatically have the privilege. The member types column lists member types who gain the privilege regardless of their reputation level.

ActionAuthorAuthorityDebatorEditorEnquirerOrganiserParticipantIf OwnerMember Types
Have no restrictions on voting frequencysilversilversilversilverAdmin
Bypass spam checks when posting contentsilversilversilversilversilversilvergoldSitebuilder, Subeditor, Mentor, Protector, Editor, Staff, Admin
Store personal files in your account areaplatinumplatinumSitebuilder, Subeditor, Supporter, Editor, Staff
Have live hyperlinks in your profilebronzebronzebronzebronzebronzebronzesilverSubeditor, Protector, Editor, Staff, Admin
Have the ability to include a biography in your profilebronzebronzebronzebronzebronzebronzesilverSubeditor, Protector, Editor, Staff, Admin
Edit a Question in Q&AsilversilversilversilverYesSubeditor, Protector, Editor, Admin
Edit an Answer in Q&AsilversilversilversilverYesSubeditor, Protector, Editor, Admin
Delete a Question in Q&AYesSubeditor, Protector, Editor, Admin
Delete an Answer in Q&AYesSubeditor, Protector, Editor, Admin
Report an ArticlesilversilversilversilverSubeditor, Mentor, Protector, Editor, Staff, Admin
Approve/Disapprove a pending ArticlegoldgoldgoldgoldSubeditor, Mentor, Protector, Editor, Staff, Admin
Edit other members' articlesSubeditor, Protector, Editor, Admin
Create an article without requiring moderationplatinumSubeditor, Mentor, Protector, Editor, Staff, Admin
Approve/Disapprove a pending QuestionProtector, Admin
Approve/Disapprove a pending AnswerProtector, Admin
Report a forum messagesilversilverbronzeProtector, Editor, Admin
Approve/Disapprove a pending Forum MessageProtector, Admin
Create a new tagsilversilversilversilverAdmin
Modify a tagsilversilversilversilverAdmin

Actions with a green tick can be performed by this member.


 
GeneralWebresource.axd or WebForm_PostBackOptions undefined problem Pin
S Sansanwal17-Oct-06 17:02
memberS Sansanwal17-Oct-06 17:02 
GeneralRe: connecting MS access database to vb combo box and list box Pin
Tyrone888824-Feb-07 6:14
memberTyrone888824-Feb-07 6:14 
Hello

i'm new to this site and dont know just yet how to create a new thread.
I'm quite new to visual basic 6 and would like some help designing a program.

-Using visual basic 6 to connect to a Microsoft Access 2000 database
- using a Microsoft ActiveX Data Objects Library

I want to connect a combo box to a databae, for example if the user clicks on the combo box the names of the tables should appear. When the user clicks on the table name its attributes should be displayed in a list box below the combo box.

Can anyone help write the code to accomplish this

Thank you

Here's my attempt to to display the table names in the combo box, this works perfectly fine apart from that it display unnecessary information in the combo such as MSys
Access Objects, MSysACEs,MSysObjects. All i want is thecombo box to display these three tables which are Attainment,Student Module. plus i want the user to select the table name and its attributes are displayed in a list box

[vbcode]Option Explicit

Private Cn As ADODB.Connection ' This is the connection
Private rstSchema As ADODB.Recordset ' This is the recordset
Private strCn As String ' string to be used in the code
Public strSelectedItem As String
Private Sub OpenDB()
Set Cn = New ADODB.Connection 'Declared it as a ADODB connection
strCn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\Documents and Settings\newResults.mdb" 'A connection string that is connected to the database
Cn.Open strCn
End Sub
Private Sub Form_Load()
' retrieve all the information from the database and places it in the combobox
OpenDB
Set rstSchema = Cn.OpenSchema(adSchemaTables)

Do Until rstSchema.EOF
cboTables.AddItem " " & rstSchema!TABLE_NAME
rstSchema.MoveNext
Loop

End Sub[/vbcode]


tyrone

GeneralSelectALL in Compact Framework Pin
S Sansanwal2-May-06 11:52
memberS Sansanwal2-May-06 11:52 
GeneralConverting HTML text to Word Pin
S Sansanwal1-Feb-06 16:23
memberS Sansanwal1-Feb-06 16:23 
GeneralPostback in WebControl PinPopular
S Sansanwal18-May-05 12:25
memberS Sansanwal18-May-05 12:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Cookies | Terms of Service
Web02 | 2.8.190518.1 | Last Updated 21 May 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid