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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Editable Queries, Access 2013    
 
   
mcbrox
post Jul 14 2019, 11:24 AM
Post#1



Posts: 69
Joined: 13-June 12
From: Sunny (& Muggy) Florida


tblLots contains both LotID (primary key) and RetnLbs.

Results of a query A gives varying records of LotID from tblLots. I want to then open an EDITABLE query B showing only those records of LotID from the query A, allowing user to edit RetnLbs in the query B.

--------------------
______________________________________________
trying my utmost to look like stephen hawking.

Living the Dream off the Government Cheese
Go to the top of the page
 
theDBguy
post Jul 14 2019, 11:33 AM
Post#2


Access Wiki and Forums Moderator
Posts: 76,000
Joined: 19-June 07
From: SunnySandyEggo


Hi. Something like this might work.
CODE
SELECT * FROM TableName WHERE ID In(SELECT ID FROM QueryA)

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
mcbrox
post Jul 14 2019, 01:31 PM
Post#3



Posts: 69
Joined: 13-June 12
From: Sunny (& Muggy) Florida


works but is NOT editable

--------------------
______________________________________________
trying my utmost to look like stephen hawking.

Living the Dream off the Government Cheese
Go to the top of the page
 
theDBguy
post Jul 14 2019, 02:28 PM
Post#4


Access Wiki and Forums Moderator
Posts: 76,000
Joined: 19-June 07
From: SunnySandyEggo


Can you post a sample db with test data? Thanks.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
GroverParkGeorge
post Jul 14 2019, 05:33 PM
Post#5


UA Admin
Posts: 35,506
Joined: 20-June 02
From: Newcastle, WA


Sometimes we abstract away so much of the context, hoping to "simplify" the question, that we lose the very details that make it possible to address those details in an answer. Thanks for providing enough detail to get to the next step.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
strive4peace
post Jul 14 2019, 07:59 PM
Post#6


strive4peace
Posts: 20,445
Joined: 10-January 04



1. varying records of LotID from tblLots
2. edit RetnLbs

If this data is coming from 2 tables, as your post suggests that it should be (one table for Lots and another for test and results), then perhaps you need a main form based on the table with Lots and then a subform to enter the results from analyses, as there may be more than one done for a given sample.

The tables and subform (control) would be linked on the LotID. To be able to edit, it is best for each form/subform to be based on just one table.

just a guess based on what you've said ...




This post has been edited by strive4peace: Jul 14 2019, 08:09 PM

--------------------
have an awesome day,
crystal
Go to the top of the page
 
gemmathehusky
post Jul 15 2019, 08:52 AM
Post#7


UtterAccess VIP
Posts: 4,725
Joined: 5-June 07
From: UK


you might need to save the output results (ie - the lots you want to manage) in a temporary table - then the labels for the lots matching the temporary table will definitely be editable.

--------------------
Dave (Male)

(Gemma was my dog)
Go to the top of the page
 
dale.fye
post Jul 15 2019, 09:29 AM
Post#8



Posts: 129
Joined: 28-March 18
From: Virginia


alot depends on what you mean by:

Results of a query A gives varying records of LotID from tblLots.

There are a lot of reasons that a query will not be updateable (here is a list).

What is the SQL you are using in Query A

--------------------
Dale Fye
Microsoft Access MVP 2013-2016
Developing Solutions, LLC
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    17th August 2019 - 06:15 PM