2nd Level Subform

Aug 13, 2006

Hi,

I've created some subforms and wanted to create a subform of one of the subforms. When I try that Access creates just another subform of the original parent form.

Is there a way of doing that please? It doesn't seem to be covered in the Help section.

Thanks in advance.
Bee

View Replies


ADVERTISEMENT

Subform Requery (beginners Level)

Jun 23, 2006

Apologies in advance for the basic nature of this, but in the past two years I have forgotten everything i ever knew!


I have two tables - Holders (holderID, name, current address) and Addresses (addressID, address1, city, etc)

current address is linked to addressID


I am trying to create a form (frmHolders) that shows the details from holders and pulls in the address using a subform (sfrmHolders)

On the main form I have used a combo box for current address so that it can be changed. What I want is for the address on the subform to refresh when the current address is changed in the combo.

I am using this:

Private Sub cboAddress_Change()
Me!sfrmHolders.Requery
End Sub

and it doesnt work


where did i go wrong?



thanks
chancer

View 1 Replies View Related

Report With Three Labels As Heading On One Level / Display Rest Of Headings On Another Level

Nov 21, 2011

I need to create a report that has three labels as a heading on one level and then it will display the rest of the headings on another level.

View 2 Replies View Related

Security Level Help..plz

Jul 17, 2006

Hi. I am trying to complete my access database by creating some security for it. I want to know how to setup the database file so when I execute, let say in my document folder so that when it opens it only shows my switchboard and not the editable(table,queries...) panel on the left hand side. I know i can hide it via the startup option but I want to completly blocking it so it doesn't allow any user to edit the design of the database.
If anyone can help I realy appreciate it...thank you

View 1 Replies View Related

Low Level Security

Apr 4, 2007

how to make low security level, when i'm installing database only with access runtime? i my computer i have low level, but when I installing DB on other computer i need access to set level of database from medium to low.

View 1 Replies View Related

A Level Course Work

Feb 28, 2008

hi
im doing a booking database for my a level coursework, i have got everything working in the tables and queries, just need to know how i can search a query in a form using a subform, and enter a new appointment into the query and have it update the current table?
ive done the subform bit before but have forgotten how lol.. help would be appreciated thanks:)

View 4 Replies View Related

Low Level Parameter?

Jul 18, 2006

I was wondering if somebody new how to make a query that started off asking (as parameter) for a number (this number represents the low number of performance) and the query would only show the performance below this amount.
Thanks

View 2 Replies View Related

Two-Level Checklist

Sep 27, 2007

Hi - I am an Access newbie. I would like to use Access to develop a checklist that uses a two dimensional parent table (with row and column titles) that, when a check box is selected in a given row/column location, a specific sub-table is displayed. Likewise, when certain conditions are satisfied on a given sub-table by clicking on a check box(es), I would like to indicate the status with color and/or text in the associated row/column location on the parent table. Any ideas on how to accomplish this would be greatly appreciated.

Thanks - Mike F.

View 3 Replies View Related

A Level Database Test Please

Apr 26, 2006

I have offered to help a local school ICT Dept with their A level projects. the first database they send me and I can't get further than the sub menus.
I would appreciate any assistance as I don't know wether it is something I am doing wrong or something within the structure. I've opened it using the Shift key to look at the code and can't see anything wrong. Any help will be very much appreciated. Regards. Bernard

View 3 Replies View Related

Macro Security Level

Oct 6, 2006

Why does Excel have an emphasis on macro security level (high, medium, low) but Access doesn't? Both use VBA.

Also when Excel loads it always requests a virus scan but when Access loads it just loads? How come?

On another note why doesn't Access have a Macro Recorder?

Thanks.

View 3 Replies View Related

User-Level Security

Mar 12, 2007

Hi, I need to add a security feature to my database. Basically I want different users to access the database with different permissions. I want a "basic user" to be only able to access the the forms with their respective default settings. I want an "admin" to obviously be able to access all the content and edit the design. I know I can do this with User-Level Security somehow, but i've tried it and it isn't working like I want it to. DOes anyone know or have any experience with this security feature.

View 10 Replies View Related

Access Level Question

Nov 26, 2007

How can i make the following access level in a MS ACCESS 2003 database?
level1----------->[Table A : Data Entry],[Table B : Only view]
level2----------->[Table B : Data Entry],[Table A : Only view]

View 2 Replies View Related

User Level Security

Mar 26, 2008

How do you set up user level security for your database?

View 2 Replies View Related

Table-Level Validation

Jun 12, 2006

I have 2 tables: Components and Lot Codes

In the Components table I have the following fields:
ModelType
Component

In the Lot Codes table I have the following fields:
Serial Number
Model
Component
LotCode Number

I want to restrict the data in the Lot Code Table so that when a model number is entered the only possible values for the Component field is one where ModelType and Component match in the Component Table.

This sounds confusing. . .basically selecting one item drills down the options for the next.

Can anyone help?

View 2 Replies View Related

Arithmetic At Table Level..

Jan 22, 2007

lets say i have three fields in my table..

all currency fields..

jobprice..
jobcarpark..
jobtotalfare..

is there a way at table level.. to set jobtotalfare as jobprice + jobcarpark because at the moment i am simply ensuring that in all the forms.. if the price or carpark is updated.. so is the total fare..

it would be much easier to do this at table level..

View 7 Replies View Related

User Level Security

Jan 30, 2005

I have a small problem here

I was creating a human resource database for a large firm. The number of records ranges from 5000 to 6000. Initially everything went well. My designs and development were highly appreciated. But now because of just security my DB is being rejected. The problem aroused because of the security issues. I tried using the Logging On database as presented here in the Code section of this Site. But it was completely rejected by the authorities. They wanted something like following

1.The administrator has the power to give the user special privileges like mentioned in the User level security i.e making users like read-only, backup, data entry etc
2.The administrator has the power to block any user from opening any form whenever he likes.

When I presented them with the user level security as in Ms Access they were completely lost and they find it really difficult to use. Further more the names of the forms as I have used are starting with “frm” where as they want only the simple names of each form. If I start changing my form names I would complete mess up my DB

Please advice what should I do to make the user level security easy for them to use.
Or how can I develop my own security system in which user can use my above mentioned points.

View 2 Replies View Related

User Level Security

Jul 21, 2004

I have implemented user level security on a database and it seems to work fine. The issue is that every other database on that computer seems to have inherited the permissions. I only want these permissions to refer to that one database.

What have I done wrong?

Thanks
Niall

View 2 Replies View Related

Login For Many Level Users

May 7, 2006

Dear All,
Hello,

In my MS-Access have many Tables,Reports,Forms.Want give read,write permitions to admins’ and ‘users’ have only read permitions for reports ,Pls help me how to create permitions
for admins’ and ‘users’ by login.

Thanks
Manish

View 1 Replies View Related

Asking About User-level Security

Jul 18, 2006

Hi,

I have a question.

When we create a user-level security, we can do it of the Tools-Security-> user-level security.

However,
can we use VBA code to create user-level security? Yes/No.

I just curiously want to know.

Because I just know that VBA can update the user-level security.

Please let me know, thanks.

View 4 Replies View Related

What Is A Form Level Variable?

Aug 24, 2006

When you are given the instruction (for code) which says "Create a form level variable" - what does this mean?

View 3 Replies View Related

Basic Concept For 3-Level RDB

Jan 2, 2008

I have been asked to create an RDB for my homeowners association that has 420 lots. That number, and the addresses, will never change. The purpose of the DB is to contain contact data between the homeowners to the association. I thought I would use 3 tables to do this:

tLots (lotID, name, address,etc.) PK=lotID
Relationship: 1 lotID to many caseIDs

tCase (caseID, lotID, type, date, status, detailID) PK=caseID
Relationship: 1 caseID to many detailIDs

tDetails (detailID, caseID, date, details, etc.) PK=detailID

I would also create pass-thru queries for these 3 tables on which to base my input form and my reports.

I have done a 2-level input form (i.e. the top half shows data from tLot and the bottom half shows a table with data from tCase, but I draw a blank how to show data from tDetails in the form. Can somebody point me in the right direction? Like maybe there is a sample of this already built somewhere that I could modify? I'm using Access 2000.

View 9 Replies View Related

User-level Security. How Effective

Dec 23, 2005

I want to put 2 Dbs on a network server. Below are the groups that can get to each directory.
Directory Students: Students, faculty, few staff
Directory Staff: all Staff

I will have a separate workgroup for each Db because each group of users is so different. Each Db will have all deselected user permissions and assigned groups and group permissions.

Questions:
-Could a computer programmer student get into any code in the Db in the Students directory, even tho they would not have user-level permission to do so?
-Could a student somehow affect in any way the other Db in the Staff directory?
In other words, could somebody use the Db in the Students directory to cause trouble anywhere else in our network?

Thanks

View 1 Replies View Related

How To Prepare 'user Level Security'

Mar 21, 2006

Hello guys

i want to prepare User level security for accessing database/tables/fors and reports.

So can anyone have step wise procedure? I am using wizard, but am not able to set up.

Thank very much:)

View 2 Replies View Related

Help Building A Stock Level Database

Jun 25, 2006

hey, is there anyone who wil be of help to me by creating me a quick and simple database. It needs to keep track how many spare parts I have. Therefore it needs to show how many of each spare part i have, and be able to update the stock levels with a submit request page that when the submit button is pressed the stock levels automatically update. the information required for each spare part is article (what the product is from), article number ( the unique article number of the product), colour (the colour which its from), spare part (what it actually is) and quantity.

Any more questions please ask

thanks

View 1 Replies View Related

User Level Security Wizard

Aug 23, 2006

I need to give different users different levels of access to my database.

I ran the user level security wizard and have correctly created user accounts. I chose to make my account a member of the Admins group, and that appears to have worked in that I can go into User and Group Accounts and create accounts, remove passwords, change group membership etc.

However, I am no longe able to access the User Level Security wizard. Access gives me a message when I try, saying that I need to be a member of the Admins group to control security settings.

Can anyone confirm if this is correct or if I have done something wrong? I don't want to let my users start using the database and then find out I've actually locked myself out of some vital settings at a later date!

Thanks in advance,

Gary

View 2 Replies View Related

Abour User Level Security

Jan 21, 2007

I created my user group in access and I want each user to reach different datas in the same database. I can do that for tables, forms, and reports and I also did bat I am just asking how each user can see different datas in the same table? If anybody can help thanks from now. :)

View 5 Replies View Related







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