When Opening A Database I Can Only View & Edit The Form...

Jul 9, 2007


When I attempt to open any of my Access databases I am presented only with the form that has been selected as the 'startup' option. Furthermore, it seems to be impossible to switch to 'design' view and my only options on the toolbar are File, Edit, Insert, Records, Windows, Help. As far as I can tell, none of these enable me to select the options required to give me my entire database back.

I am something of an Access novice, so if the above problem seems familiar to anyone i'd be grateful for the solution! The help option within MS Access hasn't been particularly useful.

Many thanks,


View Replies


Forms :: Button To Change Form From View To Edit

Mar 12, 2014

I have created a form in Access 2010 that opens in view only mode. I do this as I do not want data being changed in error. There are times when the user may need to edit some data on the form.

Any way to place an "Edit" button on the form that allows the user to edit the current record? I thought about creating two sepasrate forms, but I really don't want to maintain two of them.

View 1 Replies View Related

Forms :: Opening A Form In Datasheet View

Sep 17, 2014

I'm trying to open a form in datasheet view using the following code

Private Sub Run_Activity_Duration_Totals_Click()
DoCmd.OpenForm ("frm_Activity_Duration_Totals_25_Hours"), AcFormView = acFormDS
End Sub

I keep getting a message saying

Compile Error: Type Mismatch

and the equals sign is highlighted in my code.

View 2 Replies View Related

Opening Specific Form View From External Link

May 19, 2015

I have 4 forms in my access file. Now I have 4 buttons in html and I wanted to know if there was a way to open a specific form view based on the button click in the html page.

So access will open and show the form that is linked to the selected button in html.

View 14 Replies View Related

Opening Form To View Latest Form

Mar 12, 2008

Form: entryform

7 text fields
6 memo

What I am looking to do is be able to click on a combo box for departments so that once a department is selected, the latest record for that department is populated in the form, however, it is opened as a NEW record so that when any changes are made to the information in the form to the text or memo fields, it is saved as a new record.

I'm having a lot of trouble with this.
Thank you very much in advance for your help.

View 7 Replies View Related

Datasheet With Edit/view Button HELP!

Sep 10, 2006

I seen this awhile ago. And I was interested i knowing does anyone know where I can get an example of this. I saw what looked like a datasheet but on the right side of the datasheet there was an edit button. So every field on the datasheet had an edit button which opened up the specific row in a form layout. Can someone

View 3 Replies View Related

Split Access Database Doesn't Load Records In Form To Edit

Aug 23, 2011

I have an Access 2010 database that I have split. In the database I have a couple tables, forms and two reports. I have entered some data into one of the tables, but when I go to edit the data in the form the next time, there is no data (though I have verified that there is data in the table). Also, there are two reports that can pull the data without any problem.

Why the data wouldn't show up in the form.

View 3 Replies View Related

Edit A Query In SQL View To Perform Multiple Actions

Aug 11, 2005


How can I edit a query in SQL view to run multiple lines of SQL?

For example I can use the GUI to create a query, then in SQL view enter the following:

FROM Employees_copy;

which clears the Employees_copy table. Perfect. But what if I want to do this for mulitple tables in the same query eg for a second table Employees_copy_2 as well? I've tried

FROM Employees_copy
FROM Employees_copy_2;

which gives a syntax error, as does

FROM Employees_copy,
FROM Employees_copy_2;

any suggestions?

View 2 Replies View Related

How To Make Mainform View Only While Allowing To Edit On Subform

Jun 25, 2005

May be this is easy for your guys. I want to freeze or lock the mainform data fields while allowing users to input, edit, delete data on a subform. I tried to change mainform properties so it can not edit, add or delete data on mainform. By doing so, I cannot do anything with subform, it seem read only as well.

Thank you for help


View 1 Replies View Related

Forms :: Form To Open Only When Opening Database

Nov 19, 2013

I've made my database, now I can remember in older access I could make it so when I click the database you would only see the form and not access its self. Is it still possible to do this in access 2010.

View 1 Replies View Related

Opening Database To A Windowed Navigation Form?

Mar 13, 2015

I want to have my users open the database to a windowed navigation form. Maybe a shortcut but how would I set it to when the database first opens it goes strait to that windowed(or dialog) box.

View 1 Replies View Related

Modules & VBA :: Form Window To Popup On Opening Database

Dec 4, 2013

How I configure my Form Window to pop up as soon as I open my Access Database?

View 3 Replies View Related

Forms :: User Login Form On Opening Of Database

Feb 17, 2015

I need to know the procedure or event code for user login form at opening.

I am working on database which is almost done and i defined tables for users with passwords.

I need to know how i can assign Login Form to be appear on opening of database no other person than listed users should be able to enter or open database without password, to enforce this i made a login form.

View 5 Replies View Related

Opening In Design View

May 23, 2007


I've got a DB where I need to simply change a few images on the form buttons. When I open the file I cannot access design view at all. There is no toolbar and the menu doesn't contain View, just file, edit etc. I can edit the properties of the records etc but this is all I can do. I thought maybe it had something to do with it being created in a different version of Access but still it will open in this way only. There is no messae telling me I'm locked from anything and I've tried ctrl + enter etc. I'm running Access 2003.

Does anyone know what's wrong? Its driving me nuts. :confused:

View 4 Replies View Related

General :: Opening A Form From A Form In Different Database

Aug 31, 2012

Is there a way to open a form from a form in a different database? I'm pretty sure it needs to be done in VBA and have seen some code floating around that suggests it can be done, but I'm thinking there's more to it, like maybe one or both of the DB's need to be in a different format?

View 9 Replies View Related

Forms :: Split Database - Opening Related Record On Different Form

Aug 11, 2014

I have a split DB that is in its (hopefully) finally stages of development. Using Access 2010. It is being developed both at work and at home on a 64 bit machine. The remainder of the machines are 32 bit.

All of a sudden one of my most basic sets of code doesn't want to work, but only on my machine at work. It works fine on my home computer and on other computers at work. It is the simplest of codes, run from frmNameA:

DoCmd.OpenForm "frmNameB", acNormal, , "[SequenceNumber] = " & Me![SequenceNumber], acFormEdit, acWindowNorm

The desired sequence of events is to open frmNameA, find the active clients and then click on the [SequenceNumber] to bring up the related record on frmNameB.

When I do this on my computer at work, it asks for the query criteria for the [SequenceNumber] and the criteria for another field. On the home computer and others at work, it works just fine.

In a related problem, I have the following code on the OnLoad event for frmNameB. It opens all the related records for active clients that are in frmNameB. But if there are no related records, it is supposed to cancel the event. Again, it works fine on my home computer and others at work, but not my work computer.

Private Sub Form_Open(Cancel As Integer)
'code when opened from frmNameA and no record exists in frmNameB
Dim MyReply
If ClientID = "" Or IsNull(ClientID) Then
MyReply = MsgBox("No record exits in frmNameB, Do You Want to Exit?", vbOKOnly)
If MyReply = vbOK Then
DoCmd.RunCommand acCmdUndo
DoCmd.Close acForm, "frmNameB", acSaveNo
End If
End If
End Sub

What I can't figure out is why this may be happening, where I might look for errors, and what I might do to correct this.

View 9 Replies View Related

General :: Display Selected Form Using Drop Down On Opening Database

Jun 23, 2015

I have created a Db in MS Access 2010 and under Options > Current Database I have done the following:

- Used drop down to select a form I want to display on opening
- Unchecked display navigation pane
- Unchecked allow full menus

This works how I want it to, perfectly. I then send it to a client who also has MS Access 2010 and when they open the file the form I have told it to open doesn't open, the navigation bar is displayed (with the form I want to open highlighted) and the full menus show but are locked.

What's going on? Is it some security setting the client has that isn't letting the opening procedure execute properly?

View 1 Replies View Related

Cannot Move Database Up To Front View Behind Form Switchboard

Apr 13, 2012

Hard to see the image but basically, I can't seem to bring the database behind the form to the front to view it when I click on it. I've never encountered this before.

View 5 Replies View Related

Opening A Report As A Normal View?

Mar 19, 2006

Im sorry about the stupid questions!

How can I open a report in a view which will let me test my buttons? I only seem to be able to open it in print preview!

View 4 Replies View Related

Opening Forms In Data Sheet View

Jun 30, 2005

I have a main menu that I select things to open. Most of the things I open I open in form view but some I want to open in data sheet view.

Without recoding my menu code is there a way to specify in the form to be opened that it should open in data sheet veiw?

Right now I have the default view as data sheet view in the forms but because my calling code is not specifying any view they default to form view, and again I don't want to edit that code in my main menu.

View 3 Replies View Related

Query Opening In Report, Not Record View?

Feb 5, 2007

I have a query that searched thru records based on a person's last name. It runs fine and returns the results I want. However, the view of the results is in record-view. I'd like the results to be in a report format. Is this possible? The macro that calls the query is set to display in report view, but the query always come back showing the records. What am I missing here? Thanks a ton for your time!


View 1 Replies View Related

Modules & VBA :: Opening Forms In Datasheet View

May 8, 2014

I have read various answers on how to open a form in Datasheet view from VBA code, but I can't get my syntax correct.

Here is one of my 50 attempts to guess at the format. Removing different components, separators, variables only gets me a syntax error of missing separator or "expected =".

DoCmd.OpenForm ("frm_OrdersHOTHeadersOnlyWORKSHEET", [View as acFormView=acFormDS], , , , ,[acFormEdit])

View 3 Replies View Related

Opening Single Records From Datasheet View

Apr 15, 2015

I have a form in datasheet view that has a user directory with a list of each person. On each row you can click to open another form that contains the users details using the below VBA:

DoCmd.OpenForm "User Details", , , "[ID] = " & Me.ID

But once you open to that specific record, no other records are available to navigate to.

I want to be able to stay on that detail form that was opened and go to another record.

How do I continue to pull up that specific user in my detail form, but also load the others so I can navigate to them from the detail form without having to go back out to the datasheet form?

View 7 Replies View Related

Modules & VBA :: Database Audit Trail To Work With A Form In Datasheet View

Aug 11, 2014

Is there way a to get this audit trail module to work with a form in Datasheet view? It works fine with a form in Single Form view; I can open the table where the audits are saved and everything looks good. But when implemented on a form in datasheet view, nothing happens. I don't get any errors and nothing is saved to the audit table.

Link : [URL] ....

Here's the vba code:

Sub AuditChanges(IDField As String, UserAction As String)
On Error GoTo AuditChanges_Err
Dim db As DAO.Database
Dim rsT As DAO.Recordset
Dim ctl As Control
Dim datTimeCheck As Date
Dim strUserID As String

[Code] ...

You call it in the BeforeUpdate event like so:

Private Sub Form_BeforeUpdate(Cancel As Integer)
'Track all changes made to the record
If Me.NewRecord Then
Call AuditChanges("Asset_ID", "NEW")
Call AuditChanges("Asset_ID", "EDIT")
End If
End Sub

View 2 Replies View Related

Queries :: Opening Query In Pivot Chart View

Sep 17, 2014

So I have a code that opens a query but I want the PivotChart to show. Below is my code related to opening the query.

If vartyp = 0 Then
varQueryName = DLookup("Query", FileName, Criteria)
If IsNull(varQueryName) = False Then
DoCmd.OpenQuery varQueryName, acNormal
End If

View 1 Replies View Related

Show Only Forms And Prevent Users From Opening Design View?

Dec 17, 2013

I'm trying to protect the frontend of my database from unwanted changes. How to disable the navigation pane, ribbon, and only display my navigation form. My navigation form has 10 buttons that open forms for data entry. I only want the users to be able to open forms and add data. I don't want them to be able to go to the navigation pane or anything other than the forms.

View 2 Replies View Related

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