473,699 Members | 3,103 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Serious Query Problem for Inexperienced Access user -- Help Please

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 programmaticall y
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
Nov 12 '05 #1
6 2141
DFS
John,

Post your table structures and someone can more easily help you.
"John Baker" <Ba******@Veriz on.net> wrote in message
news:uk******** *************** *********@4ax.c om...
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 programmaticall y 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

Nov 12 '05 #2
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******@nospa m.com> wrote:
John,

Post your table structures and someone can more easily help you.
"John Baker" <Ba******@Veriz on.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

programmatical ly
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


Nov 12 '05 #3
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******@nospa m.com> wrote:
John,

Post your table structures and someone can more easily help you.
"John Baker" <Ba******@Veriz on.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

programmatical ly
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


Nov 12 '05 #4
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

Nov 12 '05 #5
TC
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******@Veriz on.net> wrote in message
news:uk******** *************** *********@4ax.c om...
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 programmaticall y 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

Nov 12 '05 #6
DFS
"John Baker" <Ba******@Veriz on.net> wrote in message
news:pf******** *************** *********@4ax.c om...
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******@nospa m.com> wrote:
John,

Post your table structures and someone can more easily help you.
"John Baker" <Ba******@Veriz on.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

programmatical ly
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

Nov 12 '05 #7

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

Similar topics

29
2477
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" for when and how to use single quotes and double quotes in ASP? thanks! ---------------------- SQL = SQL & "WHERE '" & REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE("GenKTitles.
4
5199
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 being used, on the same machine, i have an application server running connect to this DB2 server, every day there are around 12 persons has connection through the app server to db server, the database has 9 G data/index, problem is in the morning...
5
24197
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 some problems with our database crashing. We would therefore like another way to have access to basic student data and thought we automatically save the results of this query when we close Access. Any suggestions on how we could do this would be...
5
10596
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?
10
2405
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) ComboBox.SelectedValue = db_value; If the db_value was not included in the ComboBox value list the ComboBox.SelectedIndex used to return -1, Now the very same code is
2
9344
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 = <<Query_Name>> Once I create the report, I m trying to create labels to display the Report title in the Report Header section.
0
1090
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 and good suggestions but none fully helped me get the thing in gear because I guess I am too inexperienced in this area to fully understand how to implement their suggestions.
22
31201
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 June, and will return all records in that month.
1
4678
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 reporting (can't really go into too much detail...it's a legal application). Anyway, I always have to customize the field names every single time a production is to go out. The original field names are always the same, and the field names I want to...
0
8704
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9053
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8936
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7776
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6540
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4390
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4636
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2360
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2015
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.