backspace key

[lacampeona]

Hello everybody

i have some problems.

I write a database which will store some result. The results are in the table.

i want that my table is save so i want to disable some buttons ( on the keyboard and on the mouse) that users cant use and here i have problems,

I cant disable the backpace key. i try everythinb but is not working,

i try these.


i have macro called Autokeys and inside that i write the folowwing

submacro {BACKSPACE}
and then message box this button is not available.


can somebody help me? is another way that i can use to protect my table?

i already disable delete button, copy, cut.

but how to disable backspace button?

i alredy also now to disable ribbon bar but is any other way ? i know that you can also hide the tables.,..but for me the tables are very important and i want to user can see it. in the form he enter the information and then in the table he can see it.

please help mee

thank you

 

[Ranman256]

open the table as read only.
docmd.OpenTable tbl,,acReadOnly
or
set the query to snapshot (read only)

 

[lacampeona]

hello

thank you for you fast reply? where i have to put this<?

i have to create a module? and where i have to put the name of my table?

thank you

 

[sneuberg]

For forms you can set the RecordSet Type to Snapshot in the forms properties under the Data tab.

 

[lacampeona]

hello

i try it everythhink and steel dont work

i dont know why the submacro of backspace do not work..

the backspace button is still deleting...

 

[sneuberg]

I suggest double checking the properties of the form. It should look like the attached.

 

[lacampeona]

hello again

i try it and yes that work in the form and is good way

but i need something like this in the table...

i have a form which user use and the information ( results) is stored in the table which is very important in my case

i disable a lot of keys but the backspace button is still working...

in one way i need the baskspace button i like it in the form but later in the table i dont want the backpsace button-becouse of deleting the results

thank you for that now i know something more

 

[arnelgp]

you should hide the navigation pane so users cant see your table and edit it directly.

 

[Minty]

Tables - Storing data
Queries - Viewing, Filtering and sometimes updating Data
Forms - Data entry / Viewing.
Reports - Viewing

Users should never see a table - because of the very problems you are encountering.

 

[lacampeona]

hello again

yes you are right i have to hide the table...

i just forget that i can made a report..

for now i will use query for the users...just to see and filter some results

can you tell me where in the queries i can set up that nobody can change the query?

thank you very much

 

[Minty]

Use a button / macro to open the query - set it to read only in the properties..

 

[lacampeona]

hellooo

yesssssss is working...........this is what i wantt

thank you soo much

now i have other ideas how to made it everythinkk

thank youu

i wish you happy 2016