Viewing a read-only table

[mejia.j88]

Hi all,



i have a simple db that contains a table in which temperatures are dumped via Labview program.

the program records temperatures of a furnace every 12 seconds for an hour.

in my swithboard, i have added a button that opens the table for people to view the data if needed.

ideally, i would want this table to be read only; what is the best way to accomplish this?

should i make a form in which to display the records?
is there a read-only option?
what would you do?

thanks!

[pbaldy]

I would use a form, and set the various Allow Edits/Additions/Deletions properties to No. I never let users view tables or queries directly.

[mejia.j88]

and to display the table on the form?
would i have to use a subform or any sort?

[pbaldy]

Just bind the form to the table (record source). You shouldn't need a subform, generally speaking.

[mejia.j88]

if i bind the table to the form and nothing else, the form will come up blank.

i want the user to be able to see all of the temperatures at once, as if they were looking at the table.

on a given profile of a furnace, there will be 300 records to look at.

[pbaldy]

Well, you'd obviously have to have text boxes with control sources of fields in that table. Did you try the form wizard?

[mejia.j88]

i didn't use the wizard; i also didnt want to use text boxes because i didnt want the operator to click through 300 records; that is why i wanted to display it as a table, it would be easier to view 300 records by scrolling down through them.

[pbaldy]

You can use Continuous or Datasheet view, either of which will look more like the table. I prefer Continuous, but you might prefer Datasheet as it will look almost exactly like the table.

[mejia.j88]

ohh, i see, first time creating a form that works this way.

thanks so much pbaldy

[pbaldy]

Happy to help.