steps on how to create a database system using ms access and VB6

[phan]

hi, im a novice in this field of programming and im really interested to learn about it specially in making a database system. please help me and teach me the steps on how to start it... pleaseeeee... starting from MS access.. i really want to learn and i know this site could really help me a lot... i'll be waiting... thanx...

[Ali Rizwan]

hi, im a novice in this field of programming and im really interested to learn about it specially in making a database system. please help me and teach me the steps on how to start it... pleaseeeee... starting from MS access.. i really want to learn and i know this site could really help me a lot... i'll be waiting... thanx...

Hello

An image is attached see it.


Set textboxes DataSource property to ADODC1
and in last set textboxes DataField Property.

reply me

[beacon]

hi, im a novice in this field of programming and im really interested to learn about it specially in making a database system. please help me and teach me the steps on how to start it... pleaseeeee... starting from MS access.. i really want to learn and i know this site could really help me a lot... i'll be waiting... thanx...

I'm fairly new to using visual basic, but I have created a simplistic database system in Access that links to a form I created in VB. All I did was create my database, went to tools, then database converter, then Access 97. Then I inserted an MSFlexGrid in VB and a data control and made the data source (in the properties) equal to data1.

Then, I added the following code to my form to indicate where the data would be placed in Access:

Data1.DatabaseName = App.Path & "\YourDatabaseNameGoesHere.mdb"
Data1.RecordSource = "select * from AFieldInYourTable order by AFieldInYourTable"

Good luck with it. If you have further questions I went to this website, http://pages.cpsc.ucalgary.ca/~saul/vb_examples/tutorial2/index.html, for help with databases and the MSFlexGrid. Simple, but effective.

[Ali Rizwan]

I'm fairly new to using visual basic, but I have created a simplistic database system in Access that links to a form I created in VB. All I did was create my database, went to tools, then database converter, then Access 97. Then I inserted an MSFlexGrid in VB and a data control and made the data source (in the properties) equal to data1.

Then, I added the following code to my form to indicate where the data would be placed in Access:

Data1.DatabaseName = App.Path & "\YourDatabaseNameGoesHere.mdb"
Data1.RecordSource = "select * from AFieldInYourTable order by AFieldInYourTable"

Good luck with it. If you have further questions I went to this website, http://pages.cpsc.ucalgary.ca/~saul/...al2/index.html, for help with databases and the MSFlexGrid. Simple, but effective.

Hello Beacon your solution is good one but it does not work with Office Xp or Higher it will only work with the old versions of Office.Check mine and tell me how is it.

Ali

[Ali Rizwan]

I'm fairly new to using visual basic, but I have created a simplistic database system in Access that links to a form I created in VB. All I did was create my database, went to tools, then database converter, then Access 97. Then I inserted an MSFlexGrid in VB and a data control and made the data source (in the properties) equal to data1.

Then, I added the following code to my form to indicate where the data would be placed in Access:

Data1.DatabaseName = App.Path & "\YourDatabaseNameGoesHere.mdb"
Data1.RecordSource = "select * from AFieldInYourTable order by AFieldInYourTable"

Good luck with it. If you have further questions I went to this website, http://pages.cpsc.ucalgary.ca/~saul/vb_examples/tutorial2/index.html, for help with databases and the MSFlexGrid. Simple, but effective.

Thanks beacon you have helped me a lot it was good i will send you a good thing you will enjoy it guarantied.