UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Uneditable query    
 
   
dchapma123
post Jul 23 2004, 06:27 PM
Post #1

UtterAccess Enthusiast
Posts: 61
From: Ventura, CA
Hi, everyone.

I've set up queries for my department to use when they want to look at and sort large set of information (as opposed to search forms when they want to look up just one thing). I don't want them to be able to edit the information in the queries, however.

Is there a way to make a query uneditable without affecting forms that source back to the same table? OR...is there a better way to approach this?
Go to the top of the page
 
+
Jack Cowley
post Jul 23 2004, 06:39 PM
Post #2

Retired Moderator
Posts: 37,716
From: The San Francisco Bay Area
You can base forms on the queries and lock the indiviual controls on the forms and this will prevent users from changing the data. This obviously affect the forms but I can't think of a way to use a form without making some changes to it....

hth,
Jack
Go to the top of the page
 
+
dchapma123
post Jul 23 2004, 07:09 PM
Post #3

UtterAccess Enthusiast
Posts: 61
From: Ventura, CA
Oh, that should work. I forgot that forms had datasheet view. Thanks, Jack!
Go to the top of the page
 
+
R. Hicks
post Jul 23 2004, 07:34 PM
Post #4

UA Forum Administrator
Posts: 38,131
From: Birmingham, Alabama USA
You can set the "RecordsetType" property of the form to make it non-updateable ...
CODE
Private Sub Form_Open(Cancel As Integer)
Me.RecordsetType = 2
End Sub

RDH
Go to the top of the page
 
+
Jack Cowley
post Jul 24 2004, 10:50 AM
Post #5

Retired Moderator
Posts: 37,716
From: The San Francisco Bay Area
You are still teaching this old dog new tricks! Thanks Ricky!

I hope this finds you well, happy and not in Dripwater, Texas....

Jack
Go to the top of the page
 
+
Jack Cowley
post Jul 24 2004, 10:51 AM
Post #6

Retired Moderator
Posts: 37,716
From: The San Francisco Bay Area
You are welcome, but I like Mr. Hicks solution better... Use what works best for you.
Jack
Go to the top of the page
 
+
R. Hicks
post Jul 24 2004, 01:59 PM
Post #7

UA Forum Administrator
Posts: 38,131
From: Birmingham, Alabama USA
LOL ...

No, not in Texas ...
I have been home in Birmingham the past 3 or 4 weeks working on a project for another client.

RDH
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 08:46 PM