How i can find and use DataGrid in MS ACCESS 2010 on Form.

[alihassan]

i want to use DataGrid in MS ACCESS 2010 Form. where i find DataGrid control? and how to use it? kindly explain and help me, i am new in MS ACCESS development.



Thanks in Advance.

[CJ_London]

what do you mean by DataGrid? Do you mean a datasheet subform? If so, just drag a table or query onto your form.

If you mean an activeX datagrid control then in form design, click on this button to get access to activeX controls

then scroll through the list to find it - however I don't think there is one unless you install a commercial product. I've no idea how to use it if it exists

[alihassan]

Thanks for the reply..

I am talking about ActiveX DataGrid not for the "DataSheet" subform. I did not find any ActiveX control as you had mentioned above. ActiveX controls are not there.

One more request kindly send me the source how to use ActiveX DataGrid control in MS ACCESS Forms?

[CJ_London]

Sorry, I don't have it - suggest you google 'access datagrid' or similar

[June7]

ActiveX DataGrid is not provided with Access. Requires a 3rd-party add-in. http://10tec.com/articles/ms-access-grid-control.aspx

[alihassan]

Our Requirements are,
1. Change the color of cell based on condition.
2. Change the color of whole row based on any condition.
3. Sum of TWO columns show to the next column etc.

We needed just like "DataGrid" where we can set all the rows and columns based on conditions/values are set by Programmatically.

Kindly Suggest me the Control that is best with our scenario.

Thanks in Advance.

[June7]

Use a form in continuous or datasheet view or build a report. Possibly even a subform or subreport.

Textboxes and comboboxes have Conditional Formatting available. VBA code can programmatically set control formatting but will not work right on a form set for continuous or datasheet view.

[alihassan]

Any 3rd party datagird control for MS Access 2010.
That we use that 3rd party Datagrid control on Ms Access forms and dynamically /programmatically change the cells styles based on conditions.
Conditions are
If cell value is Negative then cell color is red many more conditions thats why we need DataGrid and apply those conditions programmatically on cells and on Rows.
Kindly help me with this.
Thanks.

[June7]

I have never used any third-party controls. Already referred you to one source. If that's what you want, you are on your own from here.

[alihassan]

The condition that i had mentioned above post can we set the color of cell in datasheet using VBA code.?

When the datasheet load on form as subform if cell value is 0 then cell color is red.

If yes then kindly share the source.

[June7]

As already suggested, use textbox Conditional Formatting. In form or report design view, select the textbox then on the ribbon Format tab, click Conditional Formatting.

[CJ_London]

see this link - for 2010 the code you want starts about halfway down

https://support.microsoft.com/en-us/kb/304104

alternatively, without code see this link

http://stackoverflow.com/questions/1...ffecting-row-b

here are some other links

http://bytes.com/topic/access/insigh...imited-colours
https://www.youtube.com/watch?v=7jF81HZHtxo

[alihassan]

I really appreciate your help.
THANK YOU. :-)

[alihassan]

Is iGrid 3rd party control draw a specific number of column and specific number of rows and then put the data in each cell by using the column index in loop at run time on MS Access Form load?

Our requirements is Create a fix number of columns (for exp, 5 Columns) and fix number of rows (for exp, 20 Rows) in Grid and then put the data using index of the columns in loop at run time in MS Access 2010 forms.