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  

Updates Access 2007



 
 
Thread Tools Display Modes
  #1  
Old February 28th, 2010, 07:45 PM posted to microsoft.public.access.forms
Abay
external usenet poster
 
Posts: 112
Default Updates Access 2007

Hello,

I have to make updates to forms in a database not created by me, and I have
two problems with which I need help as follows:

There is a form with a key field, which will not allow me to update the
data, when I try I get a message to the effect " the changes you requested
would create a duplicate key". I have created such a form in other data
bases with no problem. I am missing something but can't see what ...

Another form in this data base shows a scroll bar across the screen in an
area which contains an array of totals. How can I see the fields behind the
scroll bars?

Any help with these problems would be most appreciated.

Abay


  #2  
Old March 1st, 2010, 02:06 AM posted to microsoft.public.access.forms
John_G via AccessMonster.com
external usenet poster
 
Posts: 23
Default Updates Access 2007

Hi -

Your first problem is not directly related to the form - forms do not have
"key" fields; in fact they don't have fields at all. Forms have controls,
which display data from fields in the form's source table or query. You are
getting the error because you are either a) attempting to enter a new record
with a key value the same as one that already exists in the database, or b)
attempting to change the key value of an existing record to a value that
already exists in another record. (This is NOT a good practice, BTW - you
should not change key values). So, your problem is with the data, not the
form.

The second problem results from the form being larger than the screen. This
can happen if the form was designed on a computer with a different screen
size from the one you are using, or (more likely) the resolution on the PC
where the form was designed was higher than the resolution on the PC you are
using. You can increase the resolution of your screen using the "Display"
module in the Control Panel.

HTH

John


Abay wrote:
Hello,

I have to make updates to forms in a database not created by me, and I have
two problems with which I need help as follows:

There is a form with a key field, which will not allow me to update the
data, when I try I get a message to the effect " the changes you requested
would create a duplicate key". I have created such a form in other data
bases with no problem. I am missing something but can't see what ...

Another form in this data base shows a scroll bar across the screen in an
area which contains an array of totals. How can I see the fields behind the
scroll bars?

Any help with these problems would be most appreciated.

Abay


--
John Goddard
E-Mail: jrgoddard AT cyberus DOT ca

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201003/1

  #3  
Old March 1st, 2010, 02:49 AM posted to microsoft.public.access.forms
Abay
external usenet poster
 
Posts: 112
Default Updates Access 2007

Many thanks John for your reply, which is much appreciated. Forgive me for
wrongly describing the situation. The form's source is a table with a key
field of Psr_id, the id of the only record in the table is "A1".

When I have the record displayed on the screen and when I try to change one
of the fields I get the error message.

I will change the resolution on the monitor at work and hopefully I will be
able to see the total fields.

Again I would appreciate your thoughts on the updating problem.

Abay


The form displays the record A1, but I cannot update it, when I change the
data I get the error msg previously described.

Thanks
"John_G via AccessMonster.com" u53600@uwe wrote in message
news:a455598809807@uwe...
Hi -

Your first problem is not directly related to the form - forms do not have
"key" fields; in fact they don't have fields at all. Forms have controls,
which display data from fields in the form's source table or query. You
are
getting the error because you are either a) attempting to enter a new
record
with a key value the same as one that already exists in the database, or
b)
attempting to change the key value of an existing record to a value that
already exists in another record. (This is NOT a good practice, BTW - you
should not change key values). So, your problem is with the data, not the
form.

The second problem results from the form being larger than the screen.
This
can happen if the form was designed on a computer with a different screen
size from the one you are using, or (more likely) the resolution on the PC
where the form was designed was higher than the resolution on the PC you
are
using. You can increase the resolution of your screen using the "Display"
module in the Control Panel.

HTH

John


Abay wrote:
Hello,

I have to make updates to forms in a database not created by me, and I
have
two problems with which I need help as follows:

There is a form with a key field, which will not allow me to update the
data, when I try I get a message to the effect " the changes you requested
would create a duplicate key". I have created such a form in other data
bases with no problem. I am missing something but can't see what ...

Another form in this data base shows a scroll bar across the screen in an
area which contains an array of totals. How can I see the fields behind
the
scroll bars?

Any help with these problems would be most appreciated.

Abay


--
John Goddard
E-Mail: jrgoddard AT cyberus DOT ca

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201003/1




  #4  
Old March 1st, 2010, 05:52 AM posted to microsoft.public.access.forms
John_G via AccessMonster.com
external usenet poster
 
Posts: 23
Default Updates Access 2007

Hi -

Try opening the table itself, without using the form. Are you able to change
the data in any of the fields? Are you able to add new records to the table,
again without using the form? Try adding another record with Psr_ID = "A1" -
you should get the error message.

If you can update the existing record and add new ones, then there is a
problem with the form - is there any VBA code in it, or is it executing any
macros? It could be that the form is running code that is causing the error
in a table other than the one used as the form source.

Let us know how things go.

John



Abay wrote:
Many thanks John for your reply, which is much appreciated. Forgive me for
wrongly describing the situation. The form's source is a table with a key
field of Psr_id, the id of the only record in the table is "A1".

When I have the record displayed on the screen and when I try to change one
of the fields I get the error message.

I will change the resolution on the monitor at work and hopefully I will be
able to see the total fields.

Again I would appreciate your thoughts on the updating problem.

Abay

The form displays the record A1, but I cannot update it, when I change the
data I get the error msg previously described.

Thanks
Hi -

[quoted text clipped - 43 lines]

Abay


--
John Goddard
E-Mail: jrgoddard AT cyberus DOT ca

Message posted via http://www.accessmonster.com

  #5  
Old March 2nd, 2010, 04:32 AM posted to microsoft.public.access.forms
Abay
external usenet poster
 
Posts: 112
Default Updates Access 2007

Apologies in the delay in getting back .. can't access the news group while
at work and just got home.

Entering data into the table works fine, and also when I use generate the
form automatically ie using the Create form option. When I create the form
myself, placing the fields where I want, I have the problem, does not make
sense to me. I can also create a subform within a master form & update the
master form with no problems sigh

As I am running out of time I will go with the auto generated form.

Thanks so much for your help and suggestions.

Abay


"John_G via AccessMonster.com" u53600@uwe wrote in message
news:a4575405a5659@uwe...
Hi -

Try opening the table itself, without using the form. Are you able to
change
the data in any of the fields? Are you able to add new records to the
table,
again without using the form? Try adding another record with Psr_ID =
"A1" -
you should get the error message.

If you can update the existing record and add new ones, then there is a
problem with the form - is there any VBA code in it, or is it executing
any
macros? It could be that the form is running code that is causing the
error
in a table other than the one used as the form source.

Let us know how things go.

John



Abay wrote:
Many thanks John for your reply, which is much appreciated. Forgive me
for
wrongly describing the situation. The form's source is a table with a key
field of Psr_id, the id of the only record in the table is "A1".

When I have the record displayed on the screen and when I try to change
one
of the fields I get the error message.

I will change the resolution on the monitor at work and hopefully I will
be
able to see the total fields.

Again I would appreciate your thoughts on the updating problem.

Abay

The form displays the record A1, but I cannot update it, when I change the
data I get the error msg previously described.

Thanks
Hi -

[quoted text clipped - 43 lines]

Abay


--
John Goddard
E-Mail: jrgoddard AT cyberus DOT ca

Message posted via http://www.accessmonster.com



 




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 08:33 PM.


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