Topic: 2467 Runtime Error? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8) @ AskWoody

2467 Runtime Error? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » 2467 Runtime Error? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
- This topic has 7 replies, 3 voices, and was last updated 19 years, 2 months ago.
Author

Topic
New Reply

WSSupport4John
AskWoody Lounger

March 24, 2006 at 5:01 pm #430727

I have the following code Private Sub Close_Form_Click() in frm_CR_Duplicates

When the Close Command Button is clicked I display following message

Yes – click works OK, lngViolTypeID is a Combo Box on the form I

Reply | Quote

Viewing 1 reply thread
Author

Replies
- WSchuckrau
  AskWoody Lounger
  
  March 24, 2006 at 6:30 pm #1006595
  
  Why are you closing the form before the routine?
  
  Reply | Quote
- WSHansV
  AskWoody Lounger
  
  March 24, 2006 at 6:58 pm #1006600
  
  Try changing
  
  DoCmd.Close
  
  to
  
  DoCmd.Close acForm, Me.Name
  
  Reply | Quote
- WSSupport4John
  AskWoody Lounger
  
  March 25, 2006 at 11:08 am #1006693
  
  No Joy
  
  [Delete_Record_Click] is a Command Button on the Form Footer I
  
  Reply | Quote
  
  WSHansV
  AskWoody Lounger
  
  March 25, 2006 at 11:20 am #1006694
  
  Does it help if you use
  Forms!frm_CR_ACD.SetFocus Forms!frm_CR_ACD![Delete_Record_Click].SetFocus
  
  Reply | Quote
  
  WSSupport4John
  AskWoody Lounger
  
  March 25, 2006 at 11:53 am #1006697
  
  Same error
  
  I really only want to run Private Sub Delete_Record_Now() in the form I
  
  Reply | Quote
  
  WSHansV
  AskWoody Lounger
  
  March 25, 2006 at 12:04 pm #1006698
  
  You could make the Delete_Record_Now sub Public instead of Private. You should then be able to use
  Form_frm_CR_ACD.Delete_Record_Now
  
  Reply | Quote
  
  WSSupport4John
  AskWoody Lounger
  
  March 25, 2006 at 12:39 pm #1006699
  
  That got it, much better technique
  
  Thanks for all your help
  
  John
  
  Reply | Quote
Viewing 1 reply thread

Reply To: 2467 Runtime Error? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
You can use BBCodes to format your content.
Your account can't use all available BBCodes, they will be stripped before saving.

Your information:
Name (required):

Mail (will not be published) (required):

Website:

Cancel

Plus Membership

Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.

AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.

Welcome to our unique respite from the madness.

It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.

S	M	T	W	T	F	S
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31

2467 Runtime Error? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

Plus Membership

Search Newsletters

Search Forums

View the Forum

Search for Topics

Recent Topics

Recent blog posts

My Profile

Key Links

Remembering Woody

2467 Runtime Error? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

Plus Membership

Search Newsletters

Search Forums

View the Forum

Search for Topics

Recent Topics

Recent blog posts

My Profile

Login and Registration

Key Links

Remembering Woody