A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can't update table from Form



 
 
Thread Tools Display Modes
  #1  
Old June 8th, 2004, 07:19 PM
sara
external usenet poster
 
Posts: n/a
Default Can't update table from Form

I feel like this should be easy, but after 6 hours of web
search, online help, and books, I am still stuck. I hope
someone can help.

I have 3 tables in a query whose results are used to
display my first form - parameter Cashier Number.

Tables:
Cashier - Their Name, CashierNumber, OffRegister (No or
Yes indicating removal for poor performance), DateOff
Register
Employee - File# (which is link to Cashier Number),
HomeLocation
OverShort - CashierNumber, SaleDate, StoreNumber,
OverShort$, Ignore (No or Yes, indicating the record,
received from our outside source, is wrong and a
replacement has been created [what I'm trying to do]) and
VarType (I, M or D). Key to table: CashierNumber,
SaleDate, StoreNumber and Ignore

My form is fine to bring up the OverShort records based on
the search. I have a button "Update this Record" that,
when clicked, brings the data from that record to another
form that will (should) allow the user to update
OverShort$, Ignore and VarType. Since I don't want to
ever lose the original record, I want to first change
Ignore to YES (from default NO), so I can Append a record
with the same Key info, and the corrected OverShort $
amount.

I click "Update this record" and open a new form. I get
all the data from the first form (Source is Form!
F_CashierOS!FieldName), and I want to be able to update
the 3 fields, but I can't.

I first want the user to be able to click "Ignore this
Record" button that runs a query simply to change Ignore
NO to YES. This works when I run the query and manually
enter the fields (the form names pop up as parameters),
but won't work when I try to run it from the button.

I just want to change Ignore to YES, so we can then put in
the NEW record with the proper data, but NEVER delete what
we got from the vendor.

Once Ignore is YES, the user can change the $ amount and
Ignore (and type), and add a new record - with an Append
Query.

I am not sure the Update form is right; I run the initial
query and get 202 records. I go to the "Update this
record": form and I get 56,813 records - but They are all
the same record!

I can get the data from the first form to show on the
second, but it can't be updated.

I've tried all that I can find - DataEntry, Updatable,
with Inconsistencies, - but nothing has worked.

Any and All help is appreciated. I have a class at the
end of the month, but I'm not positive they'll cover these
topics. I think it's more VBA.

  #2  
Old June 8th, 2004, 07:27 PM
StCyrM
external usenet poster
 
Posts: n/a
Default Can't update table from Form

Hi Sara

If you open your query, can you add a record that way? If not, I would suspect
that your joins are not right.

Best regards
Maurice St-Cyr


Subject: Can't update table from Form
From: "sara"
Date: 6/8/2004 2:19 PM Eastern Daylight Time
Message-id:

I feel like this should be easy, but after 6 hours of web
search, online help, and books, I am still stuck. I hope
someone can help.

I have 3 tables in a query whose results are used to
display my first form - parameter Cashier Number.

Tables:
Cashier - Their Name, CashierNumber, OffRegister (No or
Yes indicating removal for poor performance), DateOff
Register
Employee - File# (which is link to Cashier Number),
HomeLocation
OverShort - CashierNumber, SaleDate, StoreNumber,
OverShort$, Ignore (No or Yes, indicating the record,
received from our outside source, is wrong and a
replacement has been created [what I'm trying to do]) and
VarType (I, M or D). Key to table: CashierNumber,
SaleDate, StoreNumber and Ignore

My form is fine to bring up the OverShort records based on
the search. I have a button "Update this Record" that,
when clicked, brings the data from that record to another
form that will (should) allow the user to update
OverShort$, Ignore and VarType. Since I don't want to
ever lose the original record, I want to first change
Ignore to YES (from default NO), so I can Append a record
with the same Key info, and the corrected OverShort $
amount.

I click "Update this record" and open a new form. I get
all the data from the first form (Source is Form!
F_CashierOS!FieldName), and I want to be able to update
the 3 fields, but I can't.

I first want the user to be able to click "Ignore this
Record" button that runs a query simply to change Ignore
NO to YES. This works when I run the query and manually
enter the fields (the form names pop up as parameters),
but won't work when I try to run it from the button.

I just want to change Ignore to YES, so we can then put in
the NEW record with the proper data, but NEVER delete what
we got from the vendor.

Once Ignore is YES, the user can change the $ amount and
Ignore (and type), and add a new record - with an Append
Query.

I am not sure the Update form is right; I run the initial
query and get 202 records. I go to the "Update this
record": form and I get 56,813 records - but They are all
the same record!

I can get the data from the first form to show on the
second, but it can't be updated.

I've tried all that I can find - DataEntry, Updatable,
with Inconsistencies, - but nothing has worked.

Any and All help is appreciated. I have a class at the
end of the month, but I'm not positive they'll cover these
topics. I think it's more VBA.









  #3  
Old June 8th, 2004, 09:24 PM
Sara
external usenet poster
 
Posts: n/a
Default Can't update table from Form

Well, Thanks. I now have the query and resulting form
allowing a new record to be added at the end, but I still
can't change Ignore to Yes.

I even tried putting the Button on the first screen, and
it then calls for the key fields (SaleDate, etc) as
parameters (Forms!F_CashierOS!SaleDate). And the button
on the second screen still gets "You are about to update 0
records".

Any further help you can offer?
Sara
-----Original Message-----
Hi Sara

If you open your query, can you add a record that way?

If not, I would suspect
that your joins are not right.

Best regards
Maurice St-Cyr


Subject: Can't update table from Form
From: "sara"
Date: 6/8/2004 2:19 PM Eastern Daylight Time
Message-id:

I feel like this should be easy, but after 6 hours of

web
search, online help, and books, I am still stuck. I

hope
someone can help.

I have 3 tables in a query whose results are used to
display my first form - parameter Cashier Number.

Tables:
Cashier - Their Name, CashierNumber, OffRegister (No or
Yes indicating removal for poor performance), DateOff
Register
Employee - File# (which is link to Cashier Number),
HomeLocation
OverShort - CashierNumber, SaleDate, StoreNumber,
OverShort$, Ignore (No or Yes, indicating the record,
received from our outside source, is wrong and a
replacement has been created [what I'm trying to do])

and
VarType (I, M or D). Key to table: CashierNumber,
SaleDate, StoreNumber and Ignore

My form is fine to bring up the OverShort records based

on
the search. I have a button "Update this Record" that,
when clicked, brings the data from that record to

another
form that will (should) allow the user to update
OverShort$, Ignore and VarType. Since I don't want to
ever lose the original record, I want to first change
Ignore to YES (from default NO), so I can Append a

record
with the same Key info, and the corrected OverShort $
amount.

I click "Update this record" and open a new form. I get
all the data from the first form (Source is Form!
F_CashierOS!FieldName), and I want to be able to update
the 3 fields, but I can't.

I first want the user to be able to click "Ignore this
Record" button that runs a query simply to change Ignore
NO to YES. This works when I run the query and manually
enter the fields (the form names pop up as parameters),
but won't work when I try to run it from the button.

I just want to change Ignore to YES, so we can then put

in
the NEW record with the proper data, but NEVER delete

what
we got from the vendor.

Once Ignore is YES, the user can change the $ amount and
Ignore (and type), and add a new record - with an Append
Query.

I am not sure the Update form is right; I run the

initial
query and get 202 records. I go to the "Update this
record": form and I get 56,813 records - but They are

all
the same record!

I can get the data from the first form to show on the
second, but it can't be updated.

I've tried all that I can find - DataEntry, Updatable,
with Inconsistencies, - but nothing has worked.

Any and All help is appreciated. I have a class at the
end of the month, but I'm not positive they'll cover

these
topics. I think it's more VBA.









.

  #4  
Old June 11th, 2004, 02:12 PM
Sara
external usenet poster
 
Posts: n/a
Default Not working- do I start a new thread?

I tried the suggestion here and my problem still exists.
Do I start a new thread or can someone help by reading
this?
thanks

-----Original Message-----
Well, Thanks. I now have the query and resulting form
allowing a new record to be added at the end, but I still
can't change Ignore to Yes.

I even tried putting the Button on the first screen, and
it then calls for the key fields (SaleDate, etc) as
parameters (Forms!F_CashierOS!SaleDate). And the button
on the second screen still gets "You are about to update

0
records".

Any further help you can offer?
Sara
-----Original Message-----
Hi Sara

If you open your query, can you add a record that way?

If not, I would suspect
that your joins are not right.

Best regards
Maurice St-Cyr


Subject: Can't update table from Form
From: "sara"
Date: 6/8/2004 2:19 PM Eastern Daylight Time
Message-id:

I feel like this should be easy, but after 6 hours of

web
search, online help, and books, I am still stuck. I

hope
someone can help.

I have 3 tables in a query whose results are used to
display my first form - parameter Cashier Number.

Tables:
Cashier - Their Name, CashierNumber, OffRegister (No or
Yes indicating removal for poor performance), DateOff
Register
Employee - File# (which is link to Cashier Number),
HomeLocation
OverShort - CashierNumber, SaleDate, StoreNumber,
OverShort$, Ignore (No or Yes, indicating the record,
received from our outside source, is wrong and a
replacement has been created [what I'm trying to do])

and
VarType (I, M or D). Key to table: CashierNumber,
SaleDate, StoreNumber and Ignore

My form is fine to bring up the OverShort records based

on
the search. I have a button "Update this Record" that,
when clicked, brings the data from that record to

another
form that will (should) allow the user to update
OverShort$, Ignore and VarType. Since I don't want to
ever lose the original record, I want to first change
Ignore to YES (from default NO), so I can Append a

record
with the same Key info, and the corrected OverShort $
amount.

I click "Update this record" and open a new form. I

get
all the data from the first form (Source is Form!
F_CashierOS!FieldName), and I want to be able to update
the 3 fields, but I can't.

I first want the user to be able to click "Ignore this
Record" button that runs a query simply to change

Ignore
NO to YES. This works when I run the query and

manually
enter the fields (the form names pop up as parameters),
but won't work when I try to run it from the button.

I just want to change Ignore to YES, so we can then put

in
the NEW record with the proper data, but NEVER delete

what
we got from the vendor.

Once Ignore is YES, the user can change the $ amount

and
Ignore (and type), and add a new record - with an

Append
Query.

I am not sure the Update form is right; I run the

initial
query and get 202 records. I go to the "Update this
record": form and I get 56,813 records - but They are

all
the same record!

I can get the data from the first form to show on the
second, but it can't be updated.

I've tried all that I can find - DataEntry, Updatable,
with Inconsistencies, - but nothing has worked.

Any and All help is appreciated. I have a class at the
end of the month, but I'm not positive they'll cover

these
topics. I think it's more VBA.









.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:23 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.