Glad to hear you found and fixed your problem with this code.
Continued success with your project.
George
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art Lorenzini
Sent: Monday, September 12, 2011 11:24 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Correct syntax for form name
Thank you for your feedback. I found out that the [] works I just had something typed incorrectly.
With warm regards,
Arthur Lorenzini| SQL Server/Access Developer l alorenzin@live.com<mailto:alorenzin%40live.com>
Office: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-0947
1316 E. 7th Street
Sioux Falls, SD 57103
SQL Server Development
Database Adminstration Services
Microsoft Access Development
Grant Writing TA Services
IT Assessment Services
Software Application Training
From: George <george_hepworth@hotmail.com<mailto:george_hepworth%40hotmail.com>>
To: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogroups.com>
Sent: Monday, September 12, 2011 12:12 PM
Subject: RE: [MS_AccessPros] Correct syntax for form name
Are you sure the form is open when this code runs? Are you certain the
form's actual name is "Change Password"? As you have probably heard before,
spaces in object names (along with special characters) tend to cause more
problems than they are worth in "readability". It's almost always a better
strategy to avoid that whole issue by adopting a naming convention which
avoids them. I.e. Why not call this "ChangePassword"?
HTH
From: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogroups.com>] On Behalf Of Art
Sent: Monday, September 12, 2011 10:08 AM
To: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: [MS_AccessPros] Correct syntax for form name
I am trying to reference a form called Change Password in the following
code:
Select Case intResponse
Case vbYes
DoCmd.Quit
Case Else
Forms![Change Password].Visible = True
End Select
But it errors that it can;t find Change Password form.
I tried Change_Password but that didn't work either.
Any ideas?
Art Lorenzini
Siou Falls, SD
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar