Forms :: Error On Startup Due To Display Form

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 Replies


ADVERTISEMENT

Forms :: Splash Screen While Other Form Loads In Background On Startup

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

General :: Database Startup Error On Only One Computer

Jul 10, 2013

"The key or key combination ^{Break} in FunctionKey_SubForm has invalid syntax or is not allowed"
- -
The "FunctionKey_SubForm" is a macro in this database.

It only does it on my computer when I opens this specific database.

This database works fine (copied it elsewhere) on everyone elses computer and also when I use it one another computer, whether the database is on the server or on the C: drive.

Since it works fine on all other computers, it's a setting in Access which is throwing up the error (even if it is " invalid syntax or is not allowed"), not the database.

Database works fine after I click through it but it's irritating and I don't recall changing anything.

View 2 Replies View Related

Set Different Startup Forms Depending On User

Mar 2, 2007

Hi! I have a database and I have two groups of users: admins and users. The admins' switchboard is different than the users' switchboard. I cannot for the life of me figure out how to tell the db to open the admin switchboard if the admin logs in, or the user switchboard if the user logs in. Any suggestions? Is this even possible? I'm looking forward to your replies. Thanks!

KellyJo

View 1 Replies View Related

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 3 Replies View Related

Forms :: Create List Box To Only Display Information From Another Form Related To Current Form

Mar 20, 2014

What I would like to do is create a list box that will only display the information from another form that is related to the current form.So I have a form call Equipment Catalog and that form is related to Equipment features 1 to M relationship and the Equipment Features is related to a Features form M to 1.

So what I want to do is display all the related equipment features in a listbox that is related to the current PK of that form.So if there is only one feature on one form the list box will only display that one item however is there is 6 features on another it will display all 6.I have been trying SQL and Queries but I still can't get it to work.

View 1 Replies View Related

Open A Form On Startup

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

How To Use Startup Form Dynamically

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

Opening A Form From Startup

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

Forms :: Access 2010 - Hide Menu On Startup?

Feb 4, 2015

Well, I made the move and am using Access 2010 now and I am running into a couple issues.

First off, I want to get rid of this menu on startup:

Not sure what it's called (ribbon, menu bar, etc). I am able to hide it using

DoCmd.RunCommand acCmdWindowHide
DoCmd.ShowToolbar "Ribbon", acToolbarNo

...in the OnLoad event, but this only works when running the opening form from the form list. When the form runs at startup the menus do not hide.

Also I would still like to have the file menu available because sometimes the user need to access the print menu to choose an alternate printer.

View 14 Replies View Related

Startup Form Very Slow Over Network

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

Changing Startup Position Of Form

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

Forms :: Display Value From Query On Sub Form

Jul 28, 2013

How can I display the count value from a query on a subform for the related/selected record?

I've tried a DLookUp without success (the text box remains empty):

=DLookUp("[CountOfMethodID]","Methods count","[MethodsRungVisitID] = Form![Form4b]")

Here's my table/query/form info:
Query is called "Methods Count"
Field of that query which I want displayed on the sub form is "CountOfMethodID"
Sub form is "Quarters and peals sub"
Main form is "Form4b"
Both form and sub are parent/child linked

There is a Relationship between the VisitID field in the "Visit Dates" table and the MethodsRungVisitID field of the "Methods Rung" table.

View 1 Replies View Related

Forms :: How To Display Date On A Form

Nov 11, 2014

I want to display today's date on a form. No connection to a table or anything like that just a label or such. I have a placed a text box on the form and set the Control Source to '=Date()' and it displays the date in a short form, eg. 11/11/2014.

What I want to do is display it in what I think is called Medium Date so that it displays as 11-Nov-2014. I suspect I need to place something inside those parentheses, but what?

View 3 Replies View Related

Forms :: Display Records In Form

Sep 7, 2014

I am putting together a database in access 2013.

I need to put in a form which basically lists all the clients names, with a button next door to each name, allowing them to edit their details. Is this possible.

Basically when loading the form, all client names are displayed in alphabetical order. Clicking on the edit button next door to the client, displays the client details in another form for easy editing. How can I do this .

View 1 Replies View Related

Forms :: Cannot Get Calculation To Display On A Form

Nov 12, 2014

I have a field called PriceSoldFor and I need to calculate and display this field multiplied by 3.4%. This is what I have tried and reading elsewhere it should work.In the Control Source of an unbound TextBox I have entered the following:

=[PriceSoldFor]*[.034]

But when I view the form the field displays the following:

#Name?

View 2 Replies View Related

How To Startup My Form Only Without Access's Default Form

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

Startup Form Bypass Security Password

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

Load Form On Startup In Access 2007

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

Startup - Open Form In Maximised View

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

Form Startup Variable And Inert On New Line

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

Forms :: How To Control Display Of Fields In Form

Nov 20, 2013

How can I control the display of fields in a form? I see in a given database, that in the design view that some fields exist in a form but in the form-view some of them are not displayed.

I can't find how it was done, i see no difference in the fields' properties. Another question is how can i make a comboBox to display just the text without the ID number...

View 12 Replies View Related

Forms :: Display Data From Query Into Form

Mar 19, 2013

Display data from Query into Form..I am attaching the database dbtest.zip which contains a table, couple of queries and form.I have done what ever settings I could after going thru some tutorials / discussion forums online, but to no avail.

All that I want is, when I open the form "frmtest" in "form view", and select CS in Combo 8, the corresponding fields in the form viz Item name, Sl No and System Name should get updated on the form. I want to view it in "Single Form" format.

View 1 Replies View Related

Forms :: Display Records Of Table On The Form

Jul 15, 2013

I am trying to display a table records on the form with this code:

Private Sub Form_Load()
Dim rs As DAO.Recordset
Dim str As String

On Error GoTo Err_cmd_vimport_Click
'defining the form recordset

[Code] ...

Err_cmd_vimport_Click:
MsgBox "Error No: " & Err.Number & "; Description: " & Err.Description
Resume Exit_cmd_vimport_Click
End Sub

however i could not be able get any results in the form as if the debugging is not showing an error.

View 1 Replies View Related

Forms :: Fields Won't Display In Form View

Dec 3, 2013

I have created a database to track our contacts for the office. I spent some time working on the relationships and making sure everything was normalized, as I've only just recently understood that concept. However, I'm afraid something got messed up in the process and I may have missed a step or done something wrong when creating the relationships.

Basically, I just created the form with all of my fields in it and when I try to view the form I see that no fields display (it's just a blank white screen). I wondered if I should actually be creating the form based off tblcontact, and then add subforms for each of the other tables.

See my attached database for further reference ...

View 8 Replies View Related

Forms :: Display Query Data In A Form

May 12, 2015

I have a form that displays employee details. I've also created a query that calculates the current age of all employees and updates automatically. I've also created a subform that displays the query data.

My question is, how do I get the query data to display on my main form? Can I do it directly from the query or do I have to use the subform? There are multiple columns on the form and I want to add it as a new column that displays the same as the rest but continues to update automatically.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved