Help Unlocking Detail View Please

Oct 11, 2006

I haven't used Access in a couple of years. I created a DB some years ago where I did not want the users to be able to view/change the forms, queries, etc.

I only wanted them to be able to view the "finished" product and do the data input.

I remember there was an "alt+key" combination I hit when I opened the db file in order to view/change queries, forms, etc.

Now, I've forgotten the key combination at open which allows me to see the details of the db.

I have some formulaes in that old db that I now need.

Could someone please advise on the key combination at open which will allow me to view/modify the details of the db?

Thank you in advance for your assistance.

Sincerely,

Joel

View Replies


ADVERTISEMENT

General :: Unlocking Access Application Form View

Jul 7, 2012

I do not know Microsoft Access that well when it comes to development.

A colleague and myself have inherited a project that requires us to research an application developed in Access.

We both have worked at SQL Server Administrators. All we have been provided is an .mdb.

The .mdb opens right up into the form view if you will.

When working with Access many years ago I know there are other views to Access when it comes to design, tables and relationships.

Does the .mdb need to be unlocked or opened in another way?

View 1 Replies View Related

Tabbing To Next Line In Detail View

Dec 11, 2007

Hi,

I created a form based on head/detail/foot kind of setup.

Now in the detail I have a combo box and a textbox. Is it possible for me to set focus to the next line textbox after the combo box fires onExit trigger?

so for instance:

form is empty. Fill in textbox, choose from dropdown, and then on Exit the focus is set to the next line textbox.

Thanks,

View 2 Replies View Related

Forms :: Adding Delete Button To Every Row In Detail View

Oct 7, 2013

I have taken over an Access database and I need to be able to add a delete button to every row in a detail view.

The rows contain a filename and a hyperlink which are pulled from an MS Sql server table.

I need to be able to put a small delete button at the end of each row which, when clicked will delete the relevant entry. How can I achieve this.

View 8 Replies View Related

Unlocking A File?

Feb 1, 2006

Hi,

I was wondering if there's a way to remove the security that a third party designer has added to a file. Is there an easy way to do this at all? Or is it really necessary to contact the original designer?

Thanks everyone!

View 6 Replies View Related

Unlocking Database

Jun 12, 2006

Apologies if this is in the wrong section.

I am completely new to access and have just started a new job which involves the building of databases using access 97. The person who I replaced has very helpfully locked all the databases.

What I would like to know is there any way to unlock them again? I can view the page as a user but I need to get into the tables etc so I can modify the design slightly.
Is this possible or am I going to have to build a brand new database?
Bearing in mind I know next to nothing so if I cant get in then I will be here asking all sorts of questions:D

Thanks

View 5 Replies View Related

Reports :: Show Detail - Using Section Header As Hyperlink To Show / Hide Detail

Aug 13, 2013

I'm trying to create a report where I can use a section header as a hyperlink to show/hide detail, but only for that section. For example, my customer names are:

Code:
ABC Co.
ZYX Co.
123 Co.

If I click on ZYX Co., I want it to show the contracts for ONLY that customer:

Code:
ABC Co.
ZYX Co.
Contract 1
Contract 2
123 Co.

Right now, my code looks like this for On_Click:

Code:
If Me.Detail.Visible = False Then
Me.Detail.Visible = True
Else
Me.Detail.Visible = False
End If

But it shows and hides detail for ALL customers when I do this. Is there a way to only show/hide for the customer on which I click?

View 1 Replies View Related

Unlocking Fields On A Subform

Nov 16, 2006

Hi

I have a subform on a form. All the fields on the form and subform are locked and not enabled.
I have a amend button which should unlock and enable the fields on the form and subform, although, i can unlocked and enable the fields on the form, but cant seem to do it on the subform, the code i use is:


Forms!participantSUBForm2.role.Locked = False
Forms!participantSUBForm2.CDSID.Locked = False
Forms!participantSUBForm2.role.Enabled = True
Forms!participantSUBForm2.CDSID.Enabled = True


Can anyone help?

View 2 Replies View Related

Forms :: Text Boxes Showing In Design View But Not Display In Form View

Apr 19, 2014

I have a Form which I have linked correctly to a subform. The Text boxes are showing in the Design view but are not when one switches to the Form View. Labels for Fields are visible in the Form View. Have even created a new subform and that will also not display the Text Boxes.

View 1 Replies View Related

Forms :: Unable To View Object Properties In Form Design View (Access 2010)

May 16, 2014

Why the ability to view the properties of an object within a form is not available when you double click on it in design view?

I was happily working away double clicking on a command button to edit some code when for some reason the next time I tried to edit it did not open up for me.

I was unable to access it even by right clicking on the object & selecting properties as that also appears to be disabled, not greyed out or anything but just does nothing when selected.

Have I inadvertently changed a setting somewhere that prevents the properties from being displayed?

View 3 Replies View Related

How Do I Show The Subform As Form View Instead Of Datasheet View :confused:

Jul 19, 2007

See title :)

I have seen that in some sample db's rightclicking the mouse showed the menu with an option to check or uncheck the dataview option, unchecked the formview was applied, but when i 'just' import the subform, i cannot find somewhere the possibility to change from dataview to formview.

Maybe someone can help me with this, probably very simple(?), question?

View 4 Replies View Related

!!??? All My Forms Are Blank Under Form View - But Fine Under Design View!!!

Jul 13, 2006

Anybody ever heard of this before? I open a form, and it is empty, just a blank window. I open the same form in Design View, all appears well. :mad:

View 2 Replies View Related

Field In Design View Not Showing In Table View

Jul 2, 2007

I have a table called NewTransactions_tbl that I have been using for some time. I am trying to add a new field called CustomerProjectNumber. It's not being displayed when I look at the table view. I've attached an image showing the settings for the field. I am probably missing something obvious.

Any ideas why it is not showing?

I am using Access 2000.

View 7 Replies View Related

Forms :: No Filters - Cannot View All Records In Form View

Aug 27, 2013

I have 4 tables and around 440 records but can only view up to 417 in the form I have designed. I have been adding new records via form and it has been added to my main table, but when i try to view it in form view - the record is not available to view. What do I need to do to correct this problem?

I have checked that there are no filters, data entry is set to No, Auto deletions, additions and edits are set to yes.

Also to mention it seems that the problem has arisen since I set up some new queries, there is a one to one relationship between the tables!

View 1 Replies View Related

Forms :: From Pivot View To Filtered Datasheet View

Nov 14, 2013

I want to "zoom" to the underliyng data from pivot view. When in excel someone doubleclicks a field in a pivot table, it automatically creates a table containing all the lines that field were made up from. I want to achieve the same behaviour in Access.I started to think towards a VBA coda, that could be initiated from the form's double click event. It should go to datasheet view with the prpoer filter criterias.

View 1 Replies View Related

I Want Datasheet View... Why Does It Keep Showing Form View?

Apr 6, 2006

I have a form which is opened with a filter from another form. For some reason it views the form in form view, although it was set up as datasheet view. I even went to the form properties and the default was datasheet and i made it not to allow other views. This still didnt solve it. I want it to be in datasheet view because i want to show multiple records at the same time.

If u kno how i could resolve this please offer ur help

thanks

View 6 Replies View Related

"unlocking" My DB

Mar 27, 2006

Hi,

I created an access DB and "locked" the working version (i.e. selected the settings where users could not see the full menu bar). I had another version that I was working on to improve/upgrade the DB, but that one got corrupted and I only have the working version left. Now, I don't want to have to re-create the DB from scratch and would like to know if there is a way to get the full menu bar to show up, so that I can access the admin options on the DB?

Thank you!!!

View 4 Replies View Related

Hide Parent Detail.

Dec 5, 2005

I have a sub Report in the detail section of its parent. I need to hide the detail part of the parent if the subReport corresponding to the record has no data.
Here is what iam trying to do but failing, any ideas...
Private Sub Report_NoData(Cancel As Integer)
Me.Parent.Section(0).Visible = False
End Sub

View 3 Replies View Related

Details And Detail Groups

Nov 16, 2006

Hello!

I have a problem figuring out a solution for following problem.

I have a database of details and their properties.
All the details have been described in one table.
As there is a need to describe groups of details I have found myself in a hard situation that needs to be resolved.
The structure of described detail groups is as follows:

Product

Detail Group1


Detail groupx etc.

Detail4

Detail groupx etc.
Detail groupx etc.




Detail1
Detail2
Detail3

Detail Group2

Detailx
Detailx


Detail groupx etc.


Detail groupx etc.





Is there a way of decribing my products in access so that there are no limits of how many groups does a product have and how many levels of groups the product have.

Thank you

View 1 Replies View Related

Concatenate Detail Value In One Column

Jun 11, 2007

i'm using Master and Detail table. Master table i have TaskId, ResId where ResId is mapped to Detail table which contains resource working on the task. i want to generate a query where for each task i want to display resource id in single column like below.

Task Id Resource Id
1 222,233,244,255

Do i need to use recursive query or any other method to get results like above.

View 1 Replies View Related

Header & Detail Keys

Apr 22, 2008

Straghtforward problem I hope!

Header table keyed on ProjectID
Detail file keyed on ProjectID and then IssueID

IssueID shoud start at 1 for each project, then 2,3,4 etc.

Autonumber seems to just increment by 1 regardless of ProjectId, rather than within it.

I'm new to Access, so what options do I have for autonumbering, or what other technique can I use?

Thanks in advance

View 1 Replies View Related

Detail Area Blank

Jul 11, 2005

I am a novice to Access so bear with me please. I've just created a form to populate some tables.

When I switch from design view to form view, the detail area in the form view is blank. :mad:

The header is fine but fields, which are present in design view are not present in form view.

Any suggestions, I've tried font/background colors and searching for a switch setting.

Thanks in advance,

JA

View 1 Replies View Related

Hide The Detail Section

Jun 2, 2006

I currently use

Me!frmPatientLookupResults.Form.Visible = False


to hide a subform on my form that is in the detail section of my form.


Is there a way to collapse or Hide the Detail section of the main Form??

I notice that their is a property under the Detail section called Visible
with an option for Yes or No.. How would I manipulate that option through
VBA? I am assuming that is the option that I am looking for

View 3 Replies View Related

Edit My Detail By Using Combo Box...

Sep 3, 2006

Hi Everyone,

I have a problem here... i need help... could someone know that how to using a combo box to edit the details?

Now i am using the Employee Name as my primary key and i set it as a combo box to let user to select the name and list all the detail like IC, Job Position, Date of Employment and etc. But when i try to edit the detail of the employee, the access program do not allow!! And i know is because i am going to create a duplicate record by the employee name.

So, do someone know how to use the combo box to list out all the details and after i doing editing by pressing a 'Save' button then the detail just change without creating a deplicate record? Maybe someone just give me a little bit idea then is enough... Thank you!!!!

View 3 Replies View Related

Printing Form Detail

Jun 4, 2007

I am looking for a way to only print the detail section (no header, no footer) using a print button on a form. it also needs to fit to 1 page. do i need code for this or is there a property that can be adjusted?

View 4 Replies View Related

Length Of Detail In A Report

Oct 22, 2007

Hello and Good Morning,

I am trying to create a 5 page report filled with colorful tables, charts, and graphs. This report will need to be reproduced 115 times. I am almost finished with page 2 of 5. When I try to start page 3, it appears that the height of the report is capped.

I have reset my computer to clear my RAM, but I still have the same problem. I try extending the length of the report, but the window will not scroll down beyond 22". Is there a way to extend the height of the report?

Thank you in advance, and I will try to answer your question in return.

View 1 Replies View Related







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