Startup Form
May 7, 2006
I 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.
View Replies
ADVERTISEMENT
Aug 18, 2006
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?
View 1 Replies
View Related
Jun 1, 2005
Hello Guys,
I have proj name m1.mdb which has forms and reports.I have 2 forms form1 ,form2.In form2 I have button that creates new database named m2_date.mdb and creates report and form1 by using property DoCmd.TransferDatabase acExport, "Microsoft Access", sFilename, acForm, "form1", "form1", StructureOnly, StoreLogin,now this form1 has to be seen first when any user doubleclicks m2_user.mdb,so my question is, is there any way i can setup startup form properties dynamically ,without using startup form manually from tool properties of toolbar.
hope to get answer..
thanks
vsap
View 2 Replies
View Related
Mar 11, 2005
Ok, I have a Forms_Menu that has many command buttons which control other functions of the database. What I want, is when a user opens access to have a page displaying a title, and then the Forms_Menu to open up automatically. Does anyone know how to do this???
View 7 Replies
View Related
Jan 16, 2007
Hi guys. I am stumped with a 45 second delay when I startup my application. I get the delay on networked workstations only when another workstation is up showing the Main "switchboard" form. Each workstation has their own copy of VBA (not compiled) with networked versions having linked tables to the server's .mdb
It seems like the workstations know that the main form is up somewhere else and need to negotiate with it. All have the (Access 2000) Default open mode to Shared, Default record locking to No Locks, and Open database using record-level locking On.
:confused:
View 6 Replies
View Related
Sep 3, 2004
I am having a problem with my form. When it opens up, it is maximized, which is what I want. However, the vertical scroll bar on the right does not begin at the top of the form, but towards the bottom. I have to scroll up each time so that I can see the top of my form. Is there a way to make the form startup at the top of the form?
View 1 Replies
View Related
Apr 19, 2006
I am trying to display only my form on startup.
Tools-Startup allows you to eliminate"Database window" default menu and toolbar but I can't eliminate "Microsoft Access" window.
I don't know if there are other settings that I am not aware of or there has to be code built.
Thanks in advance
Sebastian
View 8 Replies
View Related
May 19, 2006
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.
View 4 Replies
View Related
Nov 27, 2006
Hello,
Sorry if this is a really dumb question - I have just started using Access and I couldn't find the answer to this doing a forum search.
I have made a database consisting of a table and a form. All I want to do is get the form to appear automatically when the database is opened. I am using Access 2007.
Many thanks,
Sammy
View 14 Replies
View Related
Mar 14, 2007
I bet there is a simple explanation for this.
I have a form which opens automatically when the database is opened, but I want it to open in the maximised view so it takes up the whole screen.
View 1 Replies
View Related
Dec 19, 2006
Hello,
I have a couple of buttons on a form that I am havinga little trouble with.
The first button increments an integer variable which changes the colour of a box dependant upon the value. When a new record is opened I want it to be 0 which sets the colour. So on the form load event I have put Status (variable identifier) = 0.
when a new record is pulled up the box is white, should be a different colour, vbgreen, when I click on the button to increment it changes, so where should I put the declaration so that for each new record the colour is reset to the starting colour.
The other slight problme that I have is that another button inserts the time into a memo field. If I click the button again it just over writes the previous time stamp.
Is there a way to put each new click on a new line? Also I want to preced the time stamp with a a statement like the frist click was at time(). The second click was at time(). So I guess that I need to just increment a var for each click to then wrire 1st click, 2nd click etc. But how do I get the "1st click text/2nd click" text and again where do I put this variable so that it begins at 0 for each new record?
Many thanks.
B
View 2 Replies
View Related
Aug 9, 2013
I have been building a new db in my personal drive at work which has been working perfectly, until I transfer it to the main network drive so that others can use it.When I try to open it, I now get an error saying that windows cannot access the file (code 0x80070002) - although it does in fact open it anway, eventually.
I have removed and re-instated various bits of code, and discovered that it's linked to the 'Display Form' function within Access Options > Current Database, that I have used to open the form 'Homepage' when the db is opened. When the dropdown is set to 'None', the db opens fine, but when a form is selected, the error occurs. I have tried using an AutoExec macro to open the Homepage form, but this generates the same error too.
View 4 Replies
View Related
Jan 4, 2014
I have on very large form in my db that takes several seconds to load. I want to optimize things, so I am trying to have it load hidden in the background when the db first starts up, this way it can be immediately called on when it is needed later. Please read further :
I want to have a splash screen that loads as well. I have set the splash screen to the default form when the database opens. However, I am not quite sure how to get the other form to load in the background as hidden, AFTER the splash screen opens and appears. I tried calling it with the oncurrent event of the splash screen, but then splash screen wont appear until after the other (hidden) form has finished loading. I have tried different orders of events, but am having no luck getting the desired results.
Summary: I want the splash screen to show first, then the big form to open (hidden) in the background. The user can click on a continue button on the splash screen and then the main switchboard will open.
View 4 Replies
View Related
Apr 6, 2006
Hi i've been into Tools>Startup and remoed the menu etc.
Is there any way to retrieve these back.
Thanks
View 2 Replies
View Related
May 24, 2005
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 )
View 4 Replies
View Related
Aug 30, 2005
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.
View 1 Replies
View Related
Oct 18, 2005
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 Related
Dec 5, 2005
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.
View 7 Replies
View Related
Apr 20, 2006
Hi,
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!
View 2 Replies
View Related
May 25, 2006
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. :)
View 5 Replies
View Related
Aug 7, 2006
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
View 1 Replies
View Related
May 21, 2007
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 Related
May 28, 2007
Here 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 Related
Aug 10, 2007
How 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 :)
View 14 Replies
View Related
Mar 22, 2008
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??????
View 14 Replies
View Related
Sep 2, 2005
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 Related