datagrid and button on the form

[iccsi]

I would like to put button and data grid on the form.
I tried to use datasheet, but it does not let me to have other control
on the form.

I tried to put datsheet on the form as a subform, but it is not a
subform.

Are there any workqround for this?
May I use datasheet subform and other controls on the form to pretend
the subform is major form?


Your inormation is great appreciated,

 

[Mike Painter]

You can create a subform which is a continuos form and make it look like a
datasheet.
This will give you most of the function of a form showing a single record.
Conditional formatting will solve most of the rest of the problems

 

[Albert D. Kallal]

Build what is called a continues form (the wizard calls this a tabular
form).

here is some screen shots, and note as you mention, many often have a "edit"
button that repeats....


http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

 

[inungh]

Build what is called a continues form (the wizard calls this a tabular
form).

here is some screen shots, and note as you mention, many often have a "edit"
button that repeats....

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

Thanks millions,

 

[inungh]

Thanks millions,

Thanks, it is a very good idea.
Does it support ActiveX Control like DateTimePicker?
I tried put a datetimepicker, but it does not let me enter datatime
value.
If it is the case, user needs to enter from a text box like to enter
date time value.

Thanks again,

 

[inungh]

Build what is called a continues form (the wizard calls this a tabular
form).

here is some screen shots, and note as you mention, many often have a "edit"
button that repeats....

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

Conitnes form must be a sub form.
Am I right?

Thanks again,

 

[Albert D. Kallal]

Conitnes form must be a sub form.

Am I right?


No, not at all, and some of those screen shots such as the 3rd one is not a
continues form. the "prompt boxes" were placed in the forms header...and it
is the "details" part that repeats over and over.

And, so things like invoice totals etc go in the forms footer...perhaps
along with other things like buttons that do things or even the "exit/close"
form button....

So, no, continues forms don't have to be a sub-form at all.....

 

[Albert D. Kallal]

Thanks, it is a very good idea.

Does it support ActiveX Control like DateTimePicker?
I tried put a datetimepicker, but it does not let me enter datatime
value.
If it is the case, user needs to enter from a text box like to enter
date time value.


No, but you can certainly setup a form with a calendar inside of it. You
then have that calendar form being called from that button. Just place a
button beside the date text box that looks like a little calendar.

I mean, since we use the date "over and over", I find that it is useful to
design a form with a calendar inside of it that is called by EVERY date
control I have in the whole application. So, I just place a little button
beside each date control that calls that calendar form.

 

[inungh]

Does it support ActiveX Control like DateTimePicker?
I tried put a datetimepicker, but it does not let me enter datatime
value.
If it is the case, user needs to enter from a text box like to enter
date time value.

No, but you can certainly setup a form with a calendar inside of it. You
then have that calendar form being called from that button. Just place a
button beside the date text box that looks like a little calendar.

I mean, since we use the date "over and over", I find that it is useful to
design a form with a calendar inside of it that is called by EVERY date
control I have in the whole application. So, I just place a little button
beside each date control that calls that calendar form.

Thanks millions,
It is a good idea to palce a button and call a calendar form to enter
date using calendar.

Thanks again,