Is there a way of controlling a datasheet form through code, i.e. hiding 

columns, locking cells etc, or would i have to insert a seperate datagrid 

control? Also I know in Access 2000 if a subform has another subform you 

get a hierarchical datagrid, which is great, but sometimes when the form 

opens with no records in it you lose this functionality. Is there anyway 

of forcing this through code or would I have to insert a seperate 

heirarchical datagrid? Is there any advantages of using these datagrid 

objects instead of a subform? 

Any advice would be much appreciated.



Thanks

Jason

Jason



Datasheets have many 'undocumented' properties which may make them 

suitable for your database. I've an article on them that describes these 

properties and gives a few examples of their use. Drop me a line if you're 

still interested.



-Brian



> Is there a way of controlling a datasheet form through code, i.e. hiding 

> columns, locking cells etc, or would i have to insert a seperate 

datagrid 

> control? Also I know in Access 2000 if a subform has another subform you 

> get a hierarchical datagrid, which is great, but sometimes when the form 

> opens with no records in it you lose this functionality. Is there anyway 

> of forcing this through code or would I have to insert a seperate 

> heirarchical datagrid? Is there any advantages of using these datagrid 

> objects instead of a subform? 

> Any advice would be much appreciated.

> 

> Thanks

> Jason

Brian



Thanks for the reply. I am very interested in the article if you would be so

kind to send it me.



Cheers

Jason



-----Original Message-----

From: brian.skelton@b...

[mailto:brian.skelton@b...]

Sent: 27 November 2001 20:03

To: Access

Subject: [access] Re: Manipulating forms in datasheet view





Jason



Datasheets have many 'undocumented' properties which may make them

suitable for your database. I've an article on them that describes these

properties and gives a few examples of their use. Drop me a line if you're

still interested.



-Brian



> Is there a way of controlling a datasheet form through code, i.e. hiding

> columns, locking cells etc, or would i have to insert a seperate

datagrid

> control? Also I know in Access 2000 if a subform has another subform you

> get a hierarchical datagrid, which is great, but sometimes when the form

> opens with no records in it you lose this functionality. Is there anyway

> of forcing this through code or would I have to insert a seperate

> heirarchical datagrid? Is there any advantages of using these datagrid

> objects instead of a subform?

> Any advice would be much appreciated.

>

> Thanks

> Jason






Read the future with ebooks at B&N

http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid

=rn_ebooks

Hi Brian,



I would also love to get my hands on the article. 



Thanks in advance...



____________________________________________________



John Fejsa

Systems Analyst/Computer Programmer

Hunter Centre for Health Advancement

Locked Bag 10

WALLSEND NSW 2287

Phone: (02) 49246 336 Fax: (02) 49246 209

____________________________________________________



The doors we open and close each day decide the lives we live

____________________________________________________



CONFIDENTIALITY & PRIVILEGE NOTICE

The information contained in this email message is intended for the named 

addressee only.  If you are not the intended recipient you must not copy, 

distribute, take any action reliant on, or disclose any details of the 

information in this email to any other person or organisation.  If you 

have received this email in error please notify us immediately.



>>> brian.skelton@b... 28/11/2001 7:02:42 >>>

Jason



Datasheets have many 'undocumented' properties which may make them

suitable for your database. I've an article on them that describes 

these

properties and gives a few examples of their use. Drop me a line if 

you're

still interested.



-Brian



> Is there a way of controlling a datasheet form through code, i.e. 

hiding

> columns, locking cells etc, or would i have to insert a seperate

datagrid

> control? Also I know in Access 2000 if a subform has another subform 

you

> get a hierarchical datagrid, which is great, but sometimes when the 

form

> opens with no records in it you lose this functionality. Is there 

anyway

> of forcing this through code or would I have to insert a seperate

> heirarchical datagrid? Is there any advantages of using these datagrid=20



> objects instead of a subform?

> Any advice would be much appreciated.

>

> Thanks

> Jason



.au




Read the future with ebooks at B&N

http://service.bfast.com/bfast/click?bfmid=3D2181&sourceid=3D38934667&categ

oryid=3Drn_ebooks



This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient,
please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily
the views of Hunter Health.