Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

access 2007 tables question

Posted on 2013-02-07
4
Medium Priority
?
221 Views
Last Modified: 2013-02-08
Hi. Simple question.

Can you lockout some columns in a table or do you have tocreate a form or something else.
I have a table where the information is put there by a query and I only want two fields to be updated. The other fields are not to be touched.
0
Comment
Question by:PawloA
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 38865099
You can only do this in a form.
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 38865291
>I only want two fields to be updated.
Another possibility is to write a query that has only those two fields, then expose the query to the user for whatever manipulation they need to do.

peter is correct in that tables don't have 'column-lock' abilities.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 38865509
Yes,

Use the form wizard to make the form
set the Form to be ("Datasheet") to make it look like a query.

Set the Locked property of the control
You can also set the "enabled" property of the control to: No
...so that they cannot even click into the field/control...
0
 
LVL 52

Expert Comment

by:Gustav Brock
ID: 38867351
> I have a table where the information is put there by a query and
> I only want two fields to be updated.

Then adjust your query to update these two fields only.

/gustav
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question