Hi,
I setup 2 users security.
I want to setup startup page for 2 users, but different startup page.
I want to setup one startup page for user 1
I want to setup another startup page for user 2.
How can i make that? Because there is one option to fix the startup page.
Thanks.
I thought I had this figured out, but apparently am still missing something...
When I start my DB, I get the default 'Security Warning' message every time asking if I want to cancel or continue... I thought this was an options setting under the Tools/Macro/Security setting. However, when I change this setting (default is Medium) to Low, exit Access and restart the DB I get the same warning message and the security setting is back to medium.
Am I in the right area to fix this? Why would my settings default back?
Thanks
Hello,
I have a db that I want to password, so that anyone pressing either F11 or holding shift down at the start, will be prompted with a password.
.....But, I want the user to be able to see the start-up form and associated forms without having to enter a password.
Is this something that is possible to do in Access97?
I have searched the forum for an answer, but can't find anything.
Thanks, Steve.
Hello Access experts,
I am using MSAccess 2002. I have removed the tables and queries to reduce file size. I have set database password as "planning". In the form named "Form1" I have created a Shift-Key Enable/Disable button with password "SIMON". In Menu Starup, I have also disallowed Display Database Window, disallowed Built-in Toolbars and disallowed Toolbar/Menu Changes. Now I have problem because I cant unset the Security password and make changes in Startup.. because the Menu Tool/Security, Startup..etc have disappeared. How do I get them back again?
Thanks in advance.
I've read and gone though quite a few of the scrips and examples for creating logins and security and i'm getting to the stage when i need to have good understanding of the different methods.
Some of the examples whilst create a user login do not really allow for security within the database whilst the build in security wizard would appear to offer that functionality.
I am thinking that I will use the Workgroup file and that method. My question is am i able to utilise the fact that if a person 'AdamA' logs onto the database which is built into the workgroup security file. am I then able to take 'AdamA' to populate a table which records actions by a user? (I can't seem to find any thread or book reference to doing this)
Hi i've been into Tools>Startup and remoed the menu etc.
Is there any way to retrieve these back.
Thanks
I Have just split my database, and placed the front end (mde) on a number of client machines in a SBS environment
On starting the program, one of the machines displays the following error message
"There is an invalid use of the .(dot) or ! operator, or invalid parenthese"
Any suggestions would be greatly appreciated
Regards
Andy
(PS the OS is Win XP and the machine is running Office XP Pro )
On my database, for startup, I had the toolbars taken away from the user. Is there a quick shortcut to pull them back up? I noticed that the 'Tools' option is gone.
Thanks.
I have a database (split) I developed using Access 2000 (Office Professional). I installed it in a lap top that has Office Prosessional 2002 and am encountering several problems: 1) The shift-key bypass does not work; 2) My application uses an access wizzard switchboard. With the lap top, when I open a form from the switch board and subsequently close it, Access closes; 3) When I just open Access in the lap top, I get none of the standard tool bars. (I don't know if I caused this). This has to be something obvious that I just cannot see. Thanks in advance for your help.
View 4 Replies View RelatedHi,
I've created a new database, and unticked the options in Startup which mean the various menus at the top are hidden - and I don't know the keyboard commands to get them back :S
Daft mistake, I know!
I created a database and put some time into it at work here. I am sure this is a simple fix but I need to know how to get my tools back at the top of access. :(
What I did was open startup, unselected all the features that locks the database user out from changing settings and just using the switchboard and forms. Well, I cant figure out how to get into the file and change it all around now. :eek:
I am using access 97 at work now so please respond asap with an answer about how to get to change my tables, forms, and use tools again...:confused:
Thanks. :)
Sorry I have to ask such a simple question. I haven't worked on Access for over 10 years.
How do I find out which modules is the startup? Thanks.
DanYeung
I craeted a startup menu and unchecked all the backend functions - now I cant getinto design view - what should I do?
View 14 Replies View RelatedHere is something I hope someone can help with. I have mostly completed my Access program. I was toying around with the startup options and I selected not to have my toolbars in the startup in fear that other employees at work could mess up the program. Now I would like to tweet my database and add to it but have no toolbars to make any changes or add new form or anything. Is there a way to now change my startup options back to normal and get back my toolbars or do I have to re-create the complete database? Help please!!!!
View 1 Replies View RelatedHow do I get rid of the start up dialog? The boxes which pop up and say "Security warning, Unsafe expressions not blocked" and the other that says "warning this document may not be safe blah blah blah".
Thank you for the help :)
Hello All,
I have made a critical error with my system, in tools on startup i unticked all the boxes, and now when it loads it brings up the system only and not the design view tables etc,
Is there anyway that this can be undone??????
Hey, I was messing about with tools>startup because I wanted a form to appear whent he database was opened.... I unchecked far too many options in there, and now I cannot design and modify my database anymore... it just goes straight to the form, but i cannot get anything back in design view.. is there a way to fix this??
View 2 Replies View RelatedI setup a splashScreen in startup, and I uncheked all check boxes.
Now, as soon as I load database starup form shows, and does
not allow to do any modifications.
Is there any way i can "Undo" or drop splashScreen, and get back
to normal loading of database.
Thank you.
Have a database that when opened, has a message box that appears and when this box is closed via a Close button that I have named "OK", the main form opens. I have a Tip table that I type in the message which then appears in the messaage box form. It works perfectly providing I use a Next Message/Previous Message Button to control which of the many numbered messages on my table I wish to use.
What I want is to make sure my users have no control over what message is shown. I would still like to maintain all messages on the table by number and only have the Close (OK) button on the form. While trying to do this with the present code and if I only have 1 message on the table (#1) it will show that message. If I add a 2nd message to the table (#2) without erasing the 1st, it still only shows the first. This way I have a record of everything I have sent messages on. Below is the exisiting code used for my message box with hopes you can tell me what I need to change to make this happen:
Private Sub Form_Load()
On Error GoTo Err_Form_Load
Dim intTip As Integer
Dim intCount As Integer
Randomize
intCount = DCount("*", "tblTip")
intTip = Int(intCount * Rnd)
DoCmd.GoToRecord , , A_GOTO, intTip
Exit_Form_Load:
Exit Sub
Err_Form_Load:
Resume Exit_Form_Load
End Sub
Does anyone have any db's that show how to relink tables automatically on start up and also remove the links on shutdown, i've been searching everywhere on the net and can't seem to find anything decent, any help would be appreciated.
Thanks in advance.
Hi Guys,
I'm not sure this would be allowed as it could be maliciously abused, but what I want to do is turn of warnings when a user fires up my DB.
What currently happens is a user gets 3 pop up warnings in a row the first time they use the DB with essentially the same warnings and "do you want to run this" questions.
The next time the user runs the DB they only get one warning.
On another thread I was told how to turn warnings on and off within the database:
http://www.access-programmers.co.uk/forums/showthread.php?p=499732#post499732
'Turn warnings on & Hourglass on
DoCmd.SetWarnings False
DoCmd.Hourglass True
Code in routine that would generate warnings goes here.
'Turn warnings on & Hourglass off
DoCmd.SetWarnings True
DoCmd.Hourglass False
What I would like is some way to replicate the functionality for the DB. Is this possible?
Thanks in advance,
Keith.
I've never actually had to do this before so i dont know how! Im sure its really simple.
How would i set the database to automatically open a form when the database loads up?
I have been looking all over for this function in MS Access 2007. Anyone have an knowlege on how to access the Startup section?
Thanks a bunch, :D
~Kilch~
I have a problem where i unchecked the "allow built in toolbars" , "allow toolbar menu changes","allow full menus" and " allow default shortcut menus" from the TOOLS Menu item (STARTUP)
How do i get back all the menus to show when the application starts up?
Is there any way that anyone knows to have a table open on startup? I am not using a form, because the nature of this database is easier to use with a table. And I can't use Excel because I need reports out of the data.
Having said that, I have some users who may be partially Access-illiterate, and it would be easier to have them work on a table that opened for them. Any clues?
Lisa
Hello to everyone!, Could I ask a help how could I possibly code MS Access Startup to set the MenuBar, ShortCut Menu, FormMenu, Special Keys to OFF to prevent user from using these keys when my application starts?
Thanks for your help...