G
Guest
Is it possible using vba to make the property sheet in a form visible?
Thanks
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Brendan Reynolds
In form view? That's controlled by the AllowDesignChanges property, and that
property can only be changed in design view ...
Public Sub TestAllowDesignChanges(ByVal strFormName As String)
DoCmd.OpenForm strFormName, acDesign
DoCmd.SelectObject acForm, strFormName, False
Forms(strFormName).AllowDesignChanges = _
Not (Forms(strFormName).AllowDesignChanges)
DoCmd.Close acForm, strFormName, acSaveYes
End Sub
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
property can only be changed in design view ...
Public Sub TestAllowDesignChanges(ByVal strFormName As String)
DoCmd.OpenForm strFormName, acDesign
DoCmd.SelectObject acForm, strFormName, False
Forms(strFormName).AllowDesignChanges = _
Not (Forms(strFormName).AllowDesignChanges)
DoCmd.Close acForm, strFormName, acSaveYes
End Sub
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
B
Brendan Reynolds
Almost forgot - once the AllowDesignChanges property is set to True, the
following code will toggle the display of the Properties window ...
Private Sub Command30_Click()
DoCmd.RunCommand acCmdProperties
End Sub
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
following code will toggle the display of the Properties window ...
Private Sub Command30_Click()
DoCmd.RunCommand acCmdProperties
End Sub
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
G
Guest
Thanks Brendan,
That's the line I was looking for.
That's the line I was looking for.