Software

General discussion

Access2000question

Hi everyone! I am fairly new at this so any help you could provide would be greatly appreciated. I actually have two questions. (1) I am trying to calculate one field by using another field in the same table. I have the expression builder and the expression I need to use, however the expression builder will not show any of tables, forms, reports, or queries, therefore it doesn't recognize my expression because it doesn't recognize my field that I manually inputted. Can anybody tell me how I can add my tables, etc. to the expression builder so I can create my expression? (2)I also would like to open only 2 of my forms only for viewing through the start-up switchboard for my shop employees to view, but not edit, can anybody tell me how to do this? Thanks a million.

All Comments

In response to your first question: It is generally considered bad design to store a calculated value in a your data tables (and its therefore rather difficult). Calculated values should be handled "on the fly" using queries, form controls, etc. For example, you want to find the circumference of a circle based on a "diameter" value in Table1. Your select query should have the following format "Circumference: [table1].[diameter]*3.14". This will give you a field in your query called Circumference and the value will be calculated when the query is run. Or if you prefer the SQL statement: SELECT Table1.name, [table1].[diameter]*3.14 AS CircumferenceFROM Table1;

As for the second question, you can control read or edit/admin access to forms using Tools>Security>User and Group Permissions and User and Group Accounts. First open the Permissions interface and change the Users group to the security desired for each object (forms, queries, etc.). Then open the Accounts group and create a new "User" account, and add it to the "Users" group you just assigned permissions to. You can create more groups and accounts as necessary, assigning granular permissions to edit/administer various parts of the database.

Start or search

Create a new discussion

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

Post type

Subject title

Topic Tags

Select up to 3 tags (1 tag required)

Cloud

Piracy

Security

Apple

Microsoft

IT Employment

Google

Open Source

Mobility

Social Enterprise

Community

Smartphones

Operating Systems

Windows

Mac

Malware

Tablets

Networking

Browser

Hardware

Software

Web Developerment

Linux

Off Topic

Message Body

Track this discussion and email me when there are updates

Please note: Do not post advertisements, offensive material, profanity, or personal attacks. Please remember to be considerate of other members. If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. All submitted content is subject to our Terms Of Use.