Hi:
As those who have looked at this newsgroup recently will realize, I am a neophyte with
Access, although I have experienced with Approach (the Lotus product). There are things I
could easily do in Approach that appear to require some subtle and complex manipulation in
Access. Herein lies my present problem.
I have a number of tables, including one called "tblPO", which contains purchase orders.
Some of the details of these change over time, and I want to be able to programmatically
select all the purchase orders for a specific client, key in changes, and go on my way. I
have developed a query which will pull out all the record for a given client, but that
query wont let me update the purchase order data.
The query in question consists of a table (setup) which contains the Client ID for the
client whose POs I want to update. I am using a standard query with he tblPO table and the
setup table, and this neatly produces an output that shows all the purchase orders. I want
to be able to change the data in these purchase orders, and it just wont let me. I tried
using a Update query, and that didn't work! So I am flummoxed. I have been through two
manuals and still don't quite understand what's happening and why i cant do updating and,
most important, what I can do to make this do what I need to. There is something
fundamental that I am missing and am desperate for help!
Thanks in advance
John Baker 6 2110
John,
Post your table structures and someone can more easily help you.
"John Baker" <Ba******@Verizon.net> wrote in message
news:uk********************************@4ax.com... Hi:
As those who have looked at this newsgroup recently will realize, I am a
neophyte with Access, although I have experienced with Approach (the Lotus product).
There are things I could easily do in Approach that appear to require some subtle and complex
manipulation in Access. Herein lies my present problem.
I have a number of tables, including one called "tblPO", which contains
purchase orders. Some of the details of these change over time, and I want to be able to
programmatically select all the purchase orders for a specific client, key in changes, and
go on my way. I have developed a query which will pull out all the record for a given
client, but that query wont let me update the purchase order data.
The query in question consists of a table (setup) which contains the
Client ID for the client whose POs I want to update. I am using a standard query with he
tblPO table and the setup table, and this neatly produces an output that shows all the
purchase orders. I want to be able to change the data in these purchase orders, and it just wont
let me. I tried using a Update query, and that didn't work! So I am flummoxed. I have been
through two manuals and still don't quite understand what's happening and why i cant
do updating and, most important, what I can do to make this do what I need to. There is
something fundamental that I am missing and am desperate for help!
Thanks in advance
John Baker
DFS:
How would I do that? I would be please to try, the tables and things are 7 pages using the
data documentation tools. I suppose I could make a PDF of them, but then where would I
post them?
Regards
John
"DFS" <no******@nospam.com> wrote: John,
Post your table structures and someone can more easily help you.
"John Baker" <Ba******@Verizon.net> wrote in message news:uk********************************@4ax.com.. . Hi:
As those who have looked at this newsgroup recently will realize, I am a neophyte with Access, although I have experienced with Approach (the Lotus product). There are things I could easily do in Approach that appear to require some subtle and complex manipulation in Access. Herein lies my present problem.
I have a number of tables, including one called "tblPO", which contains purchase orders. Some of the details of these change over time, and I want to be able to programmatically select all the purchase orders for a specific client, key in changes, and go on my way. I have developed a query which will pull out all the record for a given client, but that query wont let me update the purchase order data.
The query in question consists of a table (setup) which contains the Client ID for the client whose POs I want to update. I am using a standard query with he tblPO table and the setup table, and this neatly produces an output that shows all the purchase orders. I want to be able to change the data in these purchase orders, and it just wont let me. I tried using a Update query, and that didn't work! So I am flummoxed. I have been through two manuals and still don't quite understand what's happening and why i cant do updating and, most important, what I can do to make this do what I need to. There is something fundamental that I am missing and am desperate for help!
Thanks in advance
John Baker
This note is in response to the request for more information about my problem.
The data structures are:
a. tblSetup
This file is N OT linked to anything in the relationship window, and contains a number
of parameters, including a client identification . This is NOT the record key, but rather
the name of the client. This is extracted from a client record on selection and stored in
the setup table.
b tblPO had Purchase order data in it, and has a key and a PO number (a real text field)
c. The query has both files in the query setup, and under the PO Number from the tblPO is
an expression: [tblSetup]![PO Number]. The expression does a fine job of selecting the
records I want to change, BUT I am unable to modify them! The system just wont let me. If
I take out the tblSetup and remove the expression, then I can update fine. If I remove the
expression and leave the setup table, I still cant update the records.
The issue appears to be that you cant update when there is another file in the query
expression, but this makes no sense in the real world, where one to many selection is the
rule rather than the exception. I am missing something, but don't know what!
Help Please
Regards
John Baker
"DFS" <no******@nospam.com> wrote: John,
Post your table structures and someone can more easily help you.
"John Baker" <Ba******@Verizon.net> wrote in message news:uk********************************@4ax.com.. . Hi:
As those who have looked at this newsgroup recently will realize, I am a neophyte with Access, although I have experienced with Approach (the Lotus product). There are things I could easily do in Approach that appear to require some subtle and complex manipulation in Access. Herein lies my present problem.
I have a number of tables, including one called "tblPO", which contains purchase orders. Some of the details of these change over time, and I want to be able to programmatically select all the purchase orders for a specific client, key in changes, and go on my way. I have developed a query which will pull out all the record for a given client, but that query wont let me update the purchase order data.
The query in question consists of a table (setup) which contains the Client ID for the client whose POs I want to update. I am using a standard query with he tblPO table and the setup table, and this neatly produces an output that shows all the purchase orders. I want to be able to change the data in these purchase orders, and it just wont let me. I tried using a Update query, and that didn't work! So I am flummoxed. I have been through two manuals and still don't quite understand what's happening and why i cant do updating and, most important, what I can do to make this do what I need to. There is something fundamental that I am missing and am desperate for help!
Thanks in advance
John Baker
This note is in response to the request for more information about my problem.
The data structures are:
a. tblSetup
This file is N OT linked to anything in the relationship window, and contains a number
of parameters, including a client identification . This is NOT the record key, but rather
the name of the client. This is extracted from a client record on selection and stored in
the setup table.
b tblPO had Purchase order data in it, and has a key and a PO number (a real text field)
c. The query has both files in the query setup, and under the PO Number from the tblPO is
an expression: [tblSetup]![PO Number]. The expression does a fine job of selecting the
records I want to change, BUT I am unable to modify them! The system just wont let me. If
I take out the tblSetup and remove the expression, then I can update fine. If I remove the
expression and leave the setup table, I still cant update the records.
The issue appears to be that you cant update when there is another file in the query
expression, but this makes no sense in the real world, where one to many selection is the
rule rather than the exception. I am missing something, but don't know what!
Help Please
Regards
John Baker
John, a good way >not< to get help is to post the same question twice within
a few hours, under different subject lines.
I just answered your other one. Now I see that someone else has answered
this one. So I have effectively wasted my time in answering the other one.
Please give everyone >at least a day< to answer your question. Or, post back
to the >original thread<. This is only considerate of those who answer
questions for free.
HTH,
TC
"John Baker" <Ba******@Verizon.net> wrote in message
news:uk********************************@4ax.com... Hi:
As those who have looked at this newsgroup recently will realize, I am a
neophyte with Access, although I have experienced with Approach (the Lotus product).
There are things I could easily do in Approach that appear to require some subtle and complex
manipulation in Access. Herein lies my present problem.
I have a number of tables, including one called "tblPO", which contains
purchase orders. Some of the details of these change over time, and I want to be able to
programmatically select all the purchase orders for a specific client, key in changes, and
go on my way. I have developed a query which will pull out all the record for a given
client, but that query wont let me update the purchase order data.
The query in question consists of a table (setup) which contains the
Client ID for the client whose POs I want to update. I am using a standard query with he
tblPO table and the setup table, and this neatly produces an output that shows all the
purchase orders. I want to be able to change the data in these purchase orders, and it just wont
let me. I tried using a Update query, and that didn't work! So I am flummoxed. I have been
through two manuals and still don't quite understand what's happening and why i cant
do updating and, most important, what I can do to make this do what I need to. There is
something fundamental that I am missing and am desperate for help!
Thanks in advance
John Baker
"John Baker" <Ba******@Verizon.net> wrote in message
news:pf********************************@4ax.com... DFS: How would I do that? I would be please to try, the tables and things are 7
pages using the data documentation tools. I suppose I could make a PDF of them, but then
where would I post them?
Just list the name of each table and the field names.
Regards
John
"DFS" <no******@nospam.com> wrote:
John,
Post your table structures and someone can more easily help you.
"John Baker" <Ba******@Verizon.net> wrote in message news:uk********************************@4ax.com.. . Hi:
As those who have looked at this newsgroup recently will realize, I am
aneophyte with Access, although I have experienced with Approach (the Lotus product). There are things I could easily do in Approach that appear to require some subtle and
complexmanipulation in Access. Herein lies my present problem.
I have a number of tables, including one called "tblPO", which contains purchase orders. Some of the details of these change over time, and I want to be able to programmatically select all the purchase orders for a specific client, key in changes,
andgo on my way. I have developed a query which will pull out all the record for a given client, but that query wont let me update the purchase order data.
The query in question consists of a table (setup) which contains the Client ID for the client whose POs I want to update. I am using a standard query with he tblPO table and the setup table, and this neatly produces an output that shows all the purchase orders. I want to be able to change the data in these purchase orders, and it just
wontlet me. I tried using a Update query, and that didn't work! So I am flummoxed. I have
beenthrough two manuals and still don't quite understand what's happening and why i
cantdo updating and, most important, what I can do to make this do what I need to. There is something fundamental that I am missing and am desperate for help!
Thanks in advance
John Baker This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: shank |
last post by:
1) I'm getting this error: Syntax error (missing operator) in query
expression on the below statement. Can I get some advice.
2) I searched ASPFAQ and came up blank. Where can find the "rules"...
|
by: xixi |
last post by:
i have a very serious memory problem, we have db2 udb v8.1 load on a
HP titanium machine with 4 G memory, it is 64bit machine, currently on
DB2 instance , i have three databases, but only one is...
|
by: Carl |
last post by:
Please can anyone tell me how I can create a macro to save the results
of a query as an excel file? The query is called Student List and I
would like to save it to "My Documents".
We have had...
|
by: Ryan Hubbard |
last post by:
Is it possible to get the recordset from an open query window? So you
run the query. The window is open. Can vba retrieve this data?
|
by: BBFrost |
last post by:
We just recently moved one of our major c# apps from VS Net 2002 to VS Net
2003. At first things were looking ok, now problems are starting to
appear.
So far ...
(1) ...
|
by: amith.srinivas |
last post by:
Hi all,
From a word macro in VBA, I am trying to create a report in
access DB. The report is based on a query with a parameter. I am using
Set rpt = Application.CreateReport
rpt.RecordSource =...
|
by: Frank |
last post by:
A few days ago I posted a question where I asked about how I could call/run
a query in an Access97 db from a Wndows Application I am writing with VS.Net
2003 in C#.
I had a couple of replies...
|
by: Stan |
last post by:
I am working with Access 2003 on a computer running XP. I am new at
using Access. I have a Db with a date field stored as mm/dd/yyyy. I
need a Query that will prompt for the month, ie. 6 for...
|
by: jaceyk |
last post by:
Is it even remotely possible to update field names to the correct field name for the same table using a data definition query? We have a utility that spits out data in an Access database for use in...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |