The copy text and add new record Button Events are not working (3 Viewers)

[access2010]

No it is not.

The process is that you click the Reply button and enter your answer.
Then click the "Attach Files" button and navigate to the database file you want to upload.
Make sure that you compress the file into a zipped format.
Then select the compressed/zipped file and click Open.
The file will then be attached to your message for upload to the Forum.

No it is not.

The process is that you click the Reply button and enter your answer.
Then click the "Attach Files" button and navigate to the database file you want to upload.
Make sure that you compress the file into a zipped format.
Then select the compressed/zipped file and click Open.
The file will then be attached to your message for upload to the Forum.

I hope you received the file now as I am following the instructions Nicole left for me

 

[access2010]

No it is not.

The process is that you click the Reply button and enter your answer.
Then click the "Attach Files" button and navigate to the database file you want to upload.
Make sure that you compress the file into a zipped format.
Then select the compressed/zipped file and click Open.
The file will then be attached to your message for upload to the Forum.

I hope Mike that you received the file now as I am following the instructions Nicole left for me

 

[access2010]

No luck again I'm afraid. Are you using the Attach files button at the bottom of the reply window to attach your file?

No luck again I'm afraid. Are you using the Attach files button at the bottom of the reply window to attach your file?

No it is not.

The process is that you click the Reply button and enter your answer.
Then click the "Attach Files" button and navigate to the database file you want to upload.
Make sure that you compress the file into a zipped format.
Then select the compressed/zipped file and click Open.
The file will then be attached to your message for upload to the Forum.

I hope Ken that you received the file now as I am following the instructions Nicole left for me and I am using my home computer instead of the office computer.

 

[access2010]

Barbara, I asked TWO questions and I numbered them to bring that to your attention so you would answer the two questions specifically. I know you are not technical but you didn't answer either. Maybe you thought they were meaningless but I've been doing this for a long time and with debugging, you start with the simple stupid stuff and work to the more exotic. It is reallllllly hard to help you when you don't answer specific questions.

Thank you for your note, Pat.
I am resending my response from home because the office is having internet problems and you did not receive my original reply.
You have a copy of the form that has been used since around 2010, but it stopped working properly about two years ago.
Users have lived with the problem and worked around the error.
We are trying to fix the problem with this form now because we will be updating our databases and would like everything to work properly before our upgrade..
All of our other Access 2003 databases are working properly, so I don't believe any of the upgrades caused the problem. We have six-month volunteer intern positions, so it's possible that one of them did something to this database.
I hope this answers your questions.
Barbara

 

[mike60smart]

Thank you for your note, Pat.
I am resending my response from home because the office is having internet problems and you did not receive my original reply.
You have a copy of the form that has been used since around 2010, but it stopped working properly about two years ago.
Users have lived with the problem and worked around the error.
We are trying to fix the problem with this form now because we will be updating our databases and would like everything to work properly before our upgrade..
All of our other Access 2003 databases are working properly, so I don't believe any of the upgrades caused the problem. We have six-month volunteer intern positions, so it's possible that one of them did something to this database.
I hope this answers your questions.
Barbara

Hi Barbara
The database you uploaded has a table named "Investments01_tbl" with 18 Records.
The other related table named "Investments01_tbl_SubForm" has over 24000 Records.
We need the original "Investments01_tbl" with all current records.

Also the Form with the error is based on a Query?

The normal setup is a Main Form based on "Investments01_tbl"
With a Subform based on "Investments01_tbl_SubForm"

 

[arnelgp]

the K button should work.
note also i commented the "Lost focus" events of most of your controls.
since it will make the form "dirty" (in edit mode), even when you are
not editing any record.

 

[Ken Sheridan]

The code in the K button's Click event procedure in itself looks OK, but it's execution is conditional on the value of the unbound cboSymbolStock control in the form header. This control's RowSource property references two columns, PortfolioCode and Sergey, which don't exist in the Investments01_tbl table. You'll need to correct this.

The New Record button is navigating to an empty new record as expected. However, your extensive use of the LostFocus event procedures, as mentioned by arnelgp is causing problems if the user exits the control without entering any data. Generally speaking, the best place to validate data is the control's and/or form's BeforeUpdate event procedure. This includes a Cancel argument whose return value can be set to TRUE if the validation criteria are not met.

Some of the bound controls in the form seem to have the names of non-existent columns in the qryInvestments01_Sort01 query as their ControlSource properties. These ned to be corrected.

 

[access2010]

Barbara, I asked TWO questions and I numbered them to bring that to your attention so you would answer the two questions specifically. I know you are not technical but you didn't answer either. Maybe you thought they were meaningless but I've been doing this for a long time and with debugging, you start with the simple stupid stuff and work to the more exotic. It is reallllllly hard to help you when you don't answer specific questions.

I am resending my response from home because the office is having internet problems and you did not receive my original reply.
You have a copy of the form that has been used since around 2010, but it stopped working properly about two years ago.

Users have lived with the problem and worked around the error.
We are trying to fix the problem with this form now because we will be updating our databases and would like everything to work properly before our upgrade..
All of our other Access 2003 databases are working properly, so I don't believe any of the upgrades caused the problem. We have six-month volunteer intern positions, so it's possible that one of them did something to this database.
I hope this answers your questions.
Barbara

 

[access2010]

Barbara, I asked TWO questions and I numbered them to bring that to your attention so you would answer the two questions specifically. I know you are not technical but you didn't answer either. Maybe you thought they were meaningless but I've been doing this for a long time and with debugging, you start with the simple stupid stuff and work to the more exotic. It is reallllllly hard to help you when you don't answer specific questions.

Thank you for your note, Pat.
I am resending my response from home because the office is having internet problems and you did not receive my original reply.
You have a copy of the form that has been used since around 2010, but it stopped working properly about two years ago.
Users have lived with the problem and worked around the error.
We are trying to fix the problem with this form now because we will be updating our databases and would like everything to work properly before our upgrade..
All of our other Access 2003 databases are working properly, so I don't believe any of the upgrades caused the problem. We have six-month volunteer intern positions, so it's possible that one of them did something to this database.
I hope this answers your questions.
Barbara

 

[access2010]

The code in the K button's Click event procedure in itself looks OK, but it's execution is conditional on the value of the unbound cboSymbolStock control in the form header. This control's RowSource property references two columns, PortfolioCode and Sergey, which don't exist in the Investments01_tbl table. You'll need to correct this.

The New Record button is navigating to an empty new record as expected. However, your extensive use of the LostFocus event procedures, as mentioned by arnelgp is causing problems if the user exits the control without entering any data. Generally speaking, the best place to validate data is the control's and/or form's BeforeUpdate event procedure. This includes a Cancel argument whose return value can be set to TRUE if the validation criteria are not met.

Some of the bound controls in the form seem to have the names of non-existent columns in the qryInvestments01_Sort01 query as their ControlSource properties. These ned to be corrected.

Thank you, Ken. I will try to work with your suggestions.
Batbara

 

[access2010]

Thank you ALL for your suggestions.

We have tried to FIX the problems with this form, which was created around 2010.

Instead, I will start from scratch and create a new for,, incorporating in your many suggestions.

THANK YOU

Barbara

 

[access2010]

Thank you ALL for your suggestions.

We have tried to FIX the problems with this form, which was created around 2010.

Instead, I will start from scratch and create a new for,, incorporating in your many suggestions.

THANK YOU

Barbara

 

[access2010]

the K button should work.
note also i commented the "Lost focus" events of most of your controls.
since it will make the form "dirty" (in edit mode), even when you are
not editing any record.

Thank you Arnelgp, for your file and suggestions.

I will incorporate them into our live database.

I / we appreciate your suggestions.

Barbara

 

[arnelgp]

goodluck Madam Barbara! I think you are more knowledgeable with regards to programming in Access than Nicole.