Open Access forms from VB

[jpd01]

Dear All,

I'm using MS access 97 as my backend and have created few forms in that. I'm using crystal reports 4.6.1 version that comes with MS Visual Studio for Reporting.

Can I code in VB 6.0 to open the forms associated with Access DB. If so , can you site me a simple example.

If this is done it will be great for me.

Thanks

 

[ittobaba]

dear jpd01,

1. place controls (labels or text-boxes that you desire) on the forms for the display of data.
2. place a 'Data Control' on the form.
3. In the properties window for Data Control, set its 'DatabaseName property' (provide path of your database in Access)
4. Set the 'RecordSource' property of the Data Control (Select the table from which you intend to retrieve/enter the data, in Access)
5. Select each control (label or textboxes) one at a time and set TWO properties of it:-
(a) 'DataSource' property, and select the Data Control (e.g Data1 etc)
(b)'DataField' property, and select the column of Access that you wish to be displayed.

That's all, press F5 (Run) the program.

I do not know whether it may help you out or ..........

Doctor