How to add pic to our VB apps & subform in VB (long)

[kuman]

Hi... this is my first post in this forum so everybody please be gentle
I dunno i should ask this here but this is have to do with Database Development...

I'm in learning process of using VB & Access to create my own database programs I had all the rest going ok.. for example the normal update,delete find etc working find ( i hope).

Listed below are my questions... and please help me in any of them if you can....

few questions about Picture in VB6, Listview ,Data Report, Combo Box, subforms.. any help is much appreciated.

Question Numero "Ichi":

How to attach a picture to our form in runtime? I want to add picture of customer's building in the database during key in the customer particular then i would update their data together with the picture.
Is this possible at all? by using OLE? How to do this and how to use it? any coding suggestion will be nice.

Question "Banggou" Two:

What about the table structure or datatype to hold the picture in Ms Access 97/ms access 2k? What about in SQL 7?
again is this possible at all? can i still use OLE Object like in Access?

Question Number "Tiga":

Is there any extensive site on the net that maybe can help me in anyway? i found that this site in particular helps me a lot
Planet Source Code

Question Numero "Shi":

I still have problem with combo box. How to populate all the text box with data corresponding to the combo box?

Question Number "Go":

Microsoft Data Report questions:
I created a report using Microsoft data Report (just don't have the money to buy Seagate Crystal Report v8 and the version that came with vb6 .. crystal report v4.. just too old and it still uses ODBC)

ok then how is it change the paper orientation for that report because i notice that if the report i created is bigge that the paper setup for my default printer, the report just wont show and gives me an error.Then i have to change the paper setting in the Default Printer then run the report again. this is tedious and not very practical.

I noticed that i can use the Printer.orientation thinggy but how and where should i use it? during report activation or somewhere else. and it just doesnt work for me.

Question Number SIX:
Is there any substitution to subform in vb? or any alternative? I wanted to store a set of data for a particular employee.. for example is educational background. I dont want to create a textbox for every school the employee attended and i wanted to use a listbox/flexgrid/ anything that will let me add,remove,update etc.. ( i think this is the same as my last question )


Question Number "Last":

How to use the listview to add, delete, update data in VB6. What i wanted to do is that i wanted to create a subform to keyin data (something like ms access subform) and i'm thinking of using the listview instead. or any thing in vb that might be similar to subform in Ms Access? any suggestion

For all the questions above.. any coding example will be much appreciated

Wow this is long... anyway..



Conclusion:

Thanks in advance and any help is greatly appreciated

thank you much

Kuman

[haroldbright]

Answer 1:: for msAccess use OLE Object, and for SQL use "Textcopy.exe + ntwdblib.dll" avilable in sqlServer CD



Answer 2:: for msaccess use 'OLE Object", for SQL use "Image"



Answer 3:: here are a list of good sites
http://www.codeguru.com/
http://www.devshed.com/
http://www.a1vbcode.com/
http://www.echoecho.com/
http://www.developerfusion.com/
http://www.visualbuilder.com/
http://www.developersheaven.com/
http://www.codeproject.com/
http://www.vbcodemagician.dk/



Answer 4:: use the Combo1_Click() event for the action you want to perform



Answer 5:: Sorry friend i do not know this one, i work on Seagate Crystal Report.



Answer 6:: I couldent get, Subform (please explain). Well, if you want to store details of an employee (i think you want to store a resum`e you can use a RichTextBox Control and use "text datatype for SQL" and "memo datatype for msAccess")



Answer 7:: I think you want to perform the above action on the data inside Listview... I am sure if it is possible but to FlexGrid; yes you can add and edit a record (do not have the code at this time, but sure will mail in soon). As for the Subforms you talk about, i did not get you which ones are you talking about (please explain).


Take care.
for futher queries can mail me.