ActiveX Grid control to use on a form in Access 2007

Asked By EarlLShryock 10 points N/A Posted on - 03/22/2013

Hi expert, 

I fell into the trouble under access 2007 activex grid control I got an ActiveX Grid control to use on a form in Access 2007. But I don’t have a clear idea about how to use it. Send some helping tutorial explanations for how to use it and give a description about the special commands used in ActiveX Grid control.

• Status: Open
• Question Views: 1631
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Tyrone E Louis

Go To Solution

Best Answer

Best Answer

Answered By Tyrone E Louis 130 points N/A #170952

ActiveX Grid control to use on a form in Access 2007

Hi,

For the DataGrid, you must know that control is definitely not a default item in the Visual Basic control toolbox, so you have to add this by yourself. That could be one of the reasons you are facing this problem. Let me guide you on how to get it done.

1. First add the DataGrid control, then click on the project on the menu bar after which, you select Components. By now you should start getting access to the dialog box that displays all the available VB6 components which you can see.
2. After that you have to Select Microsoft DataGrid Control 6.0 as a second step. This is essential.
3. Now select the Microsoft ADO data control (important) before exiting the dialog box, or else you will not be able to access the database which means you will have to go back to Step 1.
4. Now, click on the ‘OK’ button and you will exit the dialog box. This should be added to the DataGrid control and the ADO data control are added to the toolbox.
5. The next step is you have to drag the DataGrid control and the ADO data control both into the form. This should help you with what you are looking for.

About Tyrone E Louis

Questions
191

Answers
6

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 04/18/2013
• Question Category: MS Access

Answered By Wade S Veith 65 points N/A #170953

ActiveX Grid control to use on a form in Access 2007

Hello,

ActiveX Grid Control is useful for customizing with another data source, such as a Microsoft Access database (*.mdb). By using such control, you can create custom solution for use in your own application or for use in digital dashboard. The Grid Controls are said to be installed with a default Installation of Microsoft Project Server. 

To use ActiveX Controls, you must understand the interactions between your DDX code and the property values. ActiveX can be used in Visual Basic. There are two ways of learning ActiveX. 

The first is by writing ActiveX and the second is knowing about the COM. If you want to learn more about ActiveX controls grab a copy of ActiveX Controls Inside Out. You can also check ClassWizad for help.

About Wade S Veith

Questions
17

Answers
102

Best Answers
33

• Vote Up 0 Vote Down

• Posted on - 04/23/2013
• Question Category: MS Access