473,324 Members | 2,400 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

A select query don't update key fields

Hi,

I have a select query of 12 tables. The SQL code is as follows:

SELECT OptChannelRangeAve.ChannelRangeMin,
OptChannelRangeAve.ChannelRangeMax,
OptChannelRangeAve.SampleAveraging,
OptChannelADcard.ChannelRangeAveID, OptChannelChannel.ADcardID,
OptChannelNameChannel.ChannelEveryID, OptChannelNameChannel.ChannelID,
OptChannelNameChannel.NameID, OptChannelNameChannel.SignAnalID,
OptChannelName.ChanName, OptChannelName.Units,
OptChannelSignalAnalysis.FuncParamID,
OptChannelSignalAnalysis.WindowID, OptChannelSAWindFN.WFName,
OptChannelSAOffsetName.OffsetName, OptChannelSAFuncParComb.FunctionID,
OptChannelSAFuncParComb.ParameterID,
OptChannelSAFunction.FunctionName,
OptChannelSAFunctParam.ParameterName
FROM OptChannelName INNER JOIN (((OptChannelRangeAve INNER JOIN
OptChannelADcard ON OptChannelRangeAve.ChannelRangeAveID=OptChannelADc ard.ChannelRangeAveID)
INNER JOIN OptChannelChannel ON
OptChannelADcard.ADcardID=OptChannelChannel.ADcard ID) INNER JOIN
(((OptChannelSAFunctParam INNER JOIN (OptChannelSAFunction INNER JOIN
OptChannelSAFuncParComb ON
OptChannelSAFunction.FunctionID=OptChannelSAFuncPa rComb.FunctionID) ON
OptChannelSAFunctParam.ParameterID=OptChannelSAFun cParComb.ParameterID)
INNER JOIN ((OptChannelSAWindFN INNER JOIN (OptChannelSAOffsetName
INNER JOIN OptChannelSAWindFNOffset ON
OptChannelSAOffsetName.OffsetID=OptChannelSAWindFN Offset.OffsetFlg) ON
OptChannelSAWindFN.WFNameID=OptChannelSAWindFNOffs et.WFNameID) INNER
JOIN OptChannelSignalAnalysis ON
OptChannelSAWindFNOffset.FuncNameOffsetID=OptChann elSignalAnalysis.WindowID)
ON OptChannelSAFuncParComb.FuncParamCombID=OptChannel SignalAnalysis.FuncParamID)
INNER JOIN OptChannelNameChannel ON
OptChannelSignalAnalysis.SignAnalID=OptChannelName Channel.SignAnalID)
ON OptChannelChannel.ChannelID=OptChannelNameChannel. ChannelID) ON
OptChannelName.NameID=OptChannelNameChannel.NameID ;

When I make an autoform of this query the fields ChannelRangeAveID and
ADcardID do not update. So, when I try to save a new record using this
form a message "The Microsoft Jet database engine cannot find a record
in the table "OptChannelChannel" with key matching field(s)
"ChannelID" appears. After that, the saving is disabled. What is wrong
in the query or is there some point (in key fields?) that I have not
noticed? I have Access 2002.
Nov 13 '05 #1
1 1734
septen wrote:
Hi,

I have a select query of 12 tables. The SQL code is as follows:

SELECT OptChannelRangeAve.ChannelRangeMin,
OptChannelRangeAve.ChannelRangeMax,
OptChannelRangeAve.SampleAveraging,
OptChannelADcard.ChannelRangeAveID, OptChannelChannel.ADcardID,
OptChannelNameChannel.ChannelEveryID, OptChannelNameChannel.ChannelID,
OptChannelNameChannel.NameID, OptChannelNameChannel.SignAnalID,
OptChannelName.ChanName, OptChannelName.Units,
OptChannelSignalAnalysis.FuncParamID,
OptChannelSignalAnalysis.WindowID, OptChannelSAWindFN.WFName,
OptChannelSAOffsetName.OffsetName, OptChannelSAFuncParComb.FunctionID,
OptChannelSAFuncParComb.ParameterID,
OptChannelSAFunction.FunctionName,
OptChannelSAFunctParam.ParameterName
FROM OptChannelName INNER JOIN (((OptChannelRangeAve INNER JOIN
OptChannelADcard ON OptChannelRangeAve.ChannelRangeAveID=OptChannelADc ard.ChannelRangeAveID)
INNER JOIN OptChannelChannel ON
OptChannelADcard.ADcardID=OptChannelChannel.ADcard ID) INNER JOIN
(((OptChannelSAFunctParam INNER JOIN (OptChannelSAFunction INNER JOIN
OptChannelSAFuncParComb ON
OptChannelSAFunction.FunctionID=OptChannelSAFuncPa rComb.FunctionID) ON
OptChannelSAFunctParam.ParameterID=OptChannelSAFun cParComb.ParameterID)
INNER JOIN ((OptChannelSAWindFN INNER JOIN (OptChannelSAOffsetName
INNER JOIN OptChannelSAWindFNOffset ON
OptChannelSAOffsetName.OffsetID=OptChannelSAWindFN Offset.OffsetFlg) ON
OptChannelSAWindFN.WFNameID=OptChannelSAWindFNOffs et.WFNameID) INNER
JOIN OptChannelSignalAnalysis ON
OptChannelSAWindFNOffset.FuncNameOffsetID=OptChann elSignalAnalysis.WindowID)
ON OptChannelSAFuncParComb.FuncParamCombID=OptChannel SignalAnalysis.FuncParamID)
INNER JOIN OptChannelNameChannel ON
OptChannelSignalAnalysis.SignAnalID=OptChannelName Channel.SignAnalID)
ON OptChannelChannel.ChannelID=OptChannelNameChannel. ChannelID) ON
OptChannelName.NameID=OptChannelNameChannel.NameID ;

When I make an autoform of this query the fields ChannelRangeAveID and
ADcardID do not update. So, when I try to save a new record using this
form a message "The Microsoft Jet database engine cannot find a record
in the table "OptChannelChannel" with key matching field(s)
"ChannelID" appears. After that, the saving is disabled. What is wrong
in the query or is there some point (in key fields?) that I have not
noticed? I have Access 2002.


Maybe your table link to OptChannelChannel needs to be a Left, not Inner
join.

Create a copy of the query, cut out a few tables (for debugging
purposes) and try to add a record in the query. Keep the talbes that
are linked to OptChannelChannel.
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Andrew McNab | last post by:
Hi folks, I have a problem with an MS Access SQL query which is being used in an Access Report, and am wondering if anyone can help. Basically, my query (shown below) gets some records from a...
14
by: Jos? | last post by:
This one droves me completely mad. I did not succeed to exploit the track given to me by Bob. I have : three tables : Clubs, Persons and ClubsPersons that join the two first in a many to many...
6
by: GSteven | last post by:
(as formerly posted to microsoft.public.access.forms with no result) I've created a continuous form which is based on a straightforward table (ex - customers - 100 records). On the form there is...
22
by: MP | last post by:
vb6,ado,mdb,win2k i pass the sql string to the .Execute method on the open connection to Table_Name(const) db table fwiw (the connection opened via class wrapper:) msConnString = "Data Source="...
9
by: P3Eddie | last post by:
Hello all! I don't know if this can even be done, but I'm sure you will either help or suggest another avenue to accomplish the same. My problem may be a simple find duplicates / do something...
16
by: ARC | last post by:
Hello all, So I'm knee deep in this import utility program, and am coming up with all sorts of "gotcha's!". 1st off. On a "Find Duplicates Query", does anyone have a good solution for...
3
by: pedalpete | last post by:
I think this is pretty easy to build, but not sure how well it will scale, and therefore if it will actually work. I am trying to attach an indexer to a request so that as a search query gets...
4
by: Constantine AI | last post by:
I am trying to code a SAVE button which will automatically change numerous rows of data within a table. I have created the appropriate query and checked it works when the form is open. However the...
4
by: hapnendad | last post by:
In the question statement below Field names are in and variables are in (). All fields referenced are in what I have named the ‘PAR’ Table. Using MS Access 2003, I am working on a project...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.