Prev: drag and drop with recount order
Next: displaying messages in the Status bar with the Status command
From: Bob Quintal on 14 Mar 2010 08:38
"hubertholz via AccessMonster.com" <u58479(a)uwe> wrote in
news:a4fe1b66a018e(a)uwe:

> Hi guys,
>
> Thank you very much for your answers!
>
> You are right, It would be rather stupid to let the user make
> changes in the tables. However, I would like to provide him an
> overview of what is in the table. Until now, whenever I construct
> a new form and want to present the data there, I would have to,
> you know, flip one side after the other to get to my desired
> input. But, I would like to see them all on one list. I think
> instead of opening the table, Id prefer this solution..?
>
> hubert

You can make a form appear just like a table datasheet with one click
of the mouse. While in form properties, set the default view to
datasheet. This form should not allow editing the fields.



>
> Linq Adams wrote:
>>I'm more concerned about the statement "cannot find the option in
>>the Wizard"
>>
>>After placing the button on the form, and the Wizard pops up, do
>>you not have the option, in the left hand column of ***Form
>>Operations***
>>
>>If so simply click on this then in the right hand column click on
>>
>>Open Form
>>
>



--
Bob Quintal

PA is y I've altered my email address.
From: Arvin Meyer [MVP] on 15 Mar 2010 19:07
Using a datasheet has advantages even if you allow editing. You can protect
(lock, disable) some fields. You can not allow deletions. You can create an
audit that keeps track of edits. You cannot do any of that from a table.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"hubertholz via AccessMonster.com" <u58479(a)uwe> wrote in message
news:a4fe1b66a018e(a)uwe...
> Hi guys,
>
> Thank you very much for your answers!
>
> You are right, It would be rather stupid to let the user make changes in
> the
> tables. However, I would like to provide him an overview of what is in the
> table. Until now, whenever I construct a new form and want to present the
> data there, I would have to, you know, flip one side after the other to
> get
> to my desired input. But, I would like to see them all on one list.
> I think instead of opening the table, Id prefer this solution..?
>
> hubert
>
> Linq Adams wrote:
>>I'm more concerned about the statement "cannot find the option in the
>>Wizard"
>>
>>After placing the button on the form, and the Wizard pops up, do you not
>>have
>>the option, in the left hand column of ***Form Operations***
>>
>>If so simply click on this then in the right hand column click on
>>
>>Open Form
>>
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201003/1
>


First  |  Prev  | 
Pages: 1 2
Prev: drag and drop with recount order
Next: displaying messages in the Status bar with the Status command