Can i do such a specific form ?

[joe55555]

Hello everybody, first of all Happy New Year to everyone and wish you all the best for this coming year

Here's my issue:



I have a simple table with 4 Fields as following:
ID (number) Card_Type(text) Status(text) Expiry_Date (date/time)

I want to create a form where a checkbox has two options: Active or Canceled.
When the user Chooses one of the two choices, the form should show Card_types and their Expiry_Date of Active or Canceled Status.

The main issue is that i want the table to be hidden and the end user who's using the form cannot access the table at all, and he/she cannot copy or change the displayed data in the form, so the form is only a Read/Only.

Maybe my question is silly but it's been a quite long time since i used access
Thank you

[June7]

The Navigation pane and ribbon and shortcut menus can be disabled with project settings and code. Review https://www.accessforums.net/access/...ers-48543.html
Be aware that opening db while holding down shift key will override most of these settings.

Set controls on form as Locked Yes. Set form AllowAdditions and AllowDeletions properties to No.

[joe55555]

Thanks a lot everyone, i could find a simple code line to disable the ribbon and everything here it is:

Private Sub Form_Load()
    DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Sub

now the file is only accessible if the user uses "Shift" and opens the file.

I just got an idea, but i don't know if it is possible:
What if there is a code in VBA which detects that the access file is opened with the shift key, so a pop up windows show asking to enter a username and password, in this way it is not at accessible even when the user uses the "SHIFT" key to open the file!!!!

or am i dreaming or over thinking ???

[June7]

Yes, can disable shift key.

Bing: Access VBA shift bypass

http://www.databasedev.co.uk/disable_shift_bypass.html