I.T. Discussion Community!
chemistwendy [Unspecified] -Collapse +Expand
-Collapse +Expand
chemistwendy
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (14)

Search chemistwendy:

Advanced
Personal Account . . .
chemistwendy
Nashville, TN, USA



Real Name:  chemistwendy [Unspecified]
Primary Role:  Coder
Joined: Feb 2001 (19 years ago)
Visits: 17
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Message Boards Activity

14 posts.
More...

Thread 6 of 6
Thread Starter or a Reply (but not last)  Group

chemistwendy
Trapping Access Error 3200
I have another post that is related to this one. In my claim form, if I change the key and then tab until I would normally go to the next record, I get error 3200. What I would like to do is trap it. So, I tried putting in the OnCurrent event this code, , on Error Goto err_try, err_try:, if err.number=3200 then, msgbox "blah blah blah", sendkeys "{esc}" to put form back the way it was, end if, , However, I continue to get error 3200 instead of my message box. Have i tried the wrong event? I also tried before and after update and lostfocus. Help!!
Posted to MB Topic: MS Access Interactive « Access Board
19 years ago

mahi77.m
good and also select it from the listing of tools shown at the top, in Xcode. Kodi Chromecast   an "Organisation Identifier". For this guide nice.
37 months ago
Nothing New Since Your Last Visit
2578
Hits

Microsoft Access

Thread 5 of 6
Thread Starter or a Reply (but not last)  Group

chemistwendy
Trapping Input Mask Errors
{Too Long!}
Posted to MB Topic: Access VBA Programming « Access Board
19 years ago

dynamictiger
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
1297
Hits

Microsoft Access

Thread 4 of 6
Thread Starter or a Reply (but not last)  Group

chemistwendy
HELP! How to get Close Form Button to recognize re
I have a form where a user can either enter a new claim type or change an existing claim type. If they change the claim type code which is the key and there are related records in another table, they currently only get the standard error message "The record can not be deleted or changed..." when they tab to a new record. I also have a close form button on this form and I need for that button to have a similar error message attached to it so that if they make a change and then hit that button they are informed that their change is not going to go into effect. We do not want to allow cascade updates so they just need to see a message letting them know they need to change it back. Can anyone help?
Posted to MB Topic: Access VBA Programming « Access Board
19 years ago

dynamictiger
I would copy your code or better yet refer to the function that you are using on the tab control, and add a docmd.cancel to the close button to acheive this outcome., , HTH, Big Grin!
18 years ago
Nothing New Since Your Last Visit
2024
Hits

Microsoft Access

Thread 3 of 6
Thread Starter or a Reply (but not last)  Group

chemistwendy
Trapping Access Error 3200
I have another post that is related to this one. In my claim form, if I change the key and then tab until I would normally go to the next record, I get error 3200. What I would like to do is trap it. So, I tried putting in the OnCurrent event this code, , on Error Goto err_try, err_try:, if err.number=3200 then, msgbox "blah blah blah", sendkeys "{esc}" to put form back the way it was, end if, , However, I continue to get error 3200 instead of my message box. Have i tried the wrong event? I also tried before and after update and lostfocus. Help!!
Posted to MB Topic: Access VBA Programming « Access Board
19 years ago
Nothing New Since Your Last Visit
3227
Hits

Microsoft Access

Thread 2 of 6
Thread Starter or a Reply (but not last)  Group

chemistwendy
HELP! How to get Close Form Button to recognize re
I have a form where a user can either enter a new claim type or change an existing claim type. If they change the claim type code which is the key and there are related records in another table, they currently only get the standard error message "The record can not be deleted or changed..." when they tab to a new record. I also have a close form button on this form and I need for that button to have a similar error message attached to it so that if they make a change and then hit that button they are informed that their change is not going to go into effect. We do not want to allow cascade updates so they just need to see a message letting them know they need to change it back. Can anyone help?
Posted to MB Topic: MS Access Interactive « Access Board
19 years ago
Nothing New Since Your Last Visit
2143
Hits

Microsoft Access

Thread 1 of 6
Thread Starter or a Reply (but not last)  Group

chemistwendy
Trapping Input Mask Errors
{Too Long!}
Posted to MB Topic: MS Access Interactive « Access Board
19 years ago
Nothing New Since Your Last Visit
1783
Hits

Microsoft Access
More...

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech