hi all
I thinks I solve the problem. same idea, on "startup" under "Tools", uncheck "Allow full Menus", which will make "Hide" and "Unhide" function invisible.
Sorry for the wrong spelling, it should be "Unhide" not "Unhind"
Cheers
meng
emlimeng
Last Activity: Sep 9 '08, 01:33 AM
Joined: Feb 11 '08
Location:
-
Hi
I think I have find a way to disable the F11 key: on Menu bar go to "Tools", then go to "Startup" and then uncheck "Use Access Special keys" will disable the F11 key and prevent users from pressing F11 to access database window.
However, my the other problem is users still can open Database Window and change database design through "Unhind" function under "Window"...Leave a comment:
-
emlimeng started a topic Access to Database Windows: Disable F11 key and “Window”->”Unhind” on Menu Barin AccessAccess to Database Windows: Disable F11 key and “Window”->”Unhind” on Menu Bar
Hi everyone
It is maybe a questions asked many times. I am trying to limite users' access to Database Windows to improve security. I am working on an Access Data Project in Access 2000 format as front end and SQL Server as backend.
The ideas in my mind so far are:
• Disable the F11 key
• Disable “Unhind” function on “Window” on Menu bar, so users can’t go to Window-> Unhind to reopen the... -
Hello, Delerna, mshmyob, missingling, and jaxjagfan, many thanks for all your suggestions and comments.
I have get the visual effect from missingling's code generally, having a flashing label do distract the users. What I am trying to achieve at the moment is the colour could scrolling from one end to other slowly and smoothly, therefore, the users do not feel uncomfortable, it also could draw people’s attention. I will have a go...Leave a comment:
-
Label Automation (Flashing): changing a label's colour
Hello, I have a label on the form to draw people's attention so they do not forget to input the data in a particular section. e.g. "Please carefully check all the options on the form".
I hope I can automate the colour of the label, so that the colours for the label can keep on changing nicely and smoothly from one end to the other. Such as the colours moves per letter or per word from left to right towards the end of the... -
Many thanks ADezii, It works out!!!
As your pointed out that my problem is I didn't qualify the String returned by the getInputNumber( ) Function. I have replaced the string getInputNumber( ) with '" & getInputNumber( ) & "'. it works now!
Thanks for the two tips, I will keep that in mind in future :o)
Cheers
mengLeave a comment:
-
Insert Into..Values(function())..
hi everyone, I need help on an error message. I am working on an environment that Access2003 (adp) as a front end and links to SQL server as a back end.
I am creating a table, which requests users insert a value(varchar) into the table throuth an input box on a form.
Please see the code is below:
[CODE=vb]Public Sub cmdAdd_Click()
Dim cmd As ADODB.Command
Set cmd = New ADODB.Command
...
No activity results to display
Leave a comment: