A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Creating Forms is tedious



 
 
Thread Tools Display Modes
  #11  
Old October 5th, 2004, 04:53 PM
Michel Walsh
external usenet poster
 
Posts: n/a
Default

Hi,


use a sub-form?


Vanderghast, Access MVP


"John Marshall, MVP" wrote in message
...


(...)


Ideally I would like to see the form designers have the ability to create
a set of objects that can be placed on a page and that modifying these
objects would be reflected across all forms that use the objects.


(...)


  #12  
Old October 5th, 2004, 09:11 PM
John Marshall, MVP
external usenet poster
 
Posts: n/a
Default

I had considered sub forms for some of the common elements, ie customer
description, but not for some of the smaller groupings.

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
"Michel Walsh" vanderghast@VirusAreFunnierThanSpam wrote in message
...
Hi,


use a sub-form?


Vanderghast, Access MVP


"John Marshall, MVP" wrote in message
...


(...)


Ideally I would like to see the form designers have the ability to create
a set of objects that can be placed on a page and that modifying these
objects would be reflected across all forms that use the objects.


(...)



  #13  
Old October 6th, 2004, 11:50 AM
Michel Walsh
external usenet poster
 
Posts: n/a
Default

Hi,


Alternatively, you can use the unsupported functions SaveAsText, to get
the an all text representation of your Access object, edit it from a text
editor, and LoadAsText the modified text. At your own risks.

Application.SaveAsText acForm, FormName, fullPathAndFileNameDotTxt

Would produce the text representation of your form.

That is not completely an automatism, but it may be somehow easier than
to open the form in design mode and use VBA automation to modify the
controls.

Being not supported, these functions may change in behavior from
versions to versions, and can even kill an application. Not necessary a good
idea to use such possible bomb in application deliver to many clients.


Vanderghast, Access MVP


"John Marshall, MVP" wrote in message
...
I had considered sub forms for some of the common elements, ie customer
description, but not for some of the smaller groupings.

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
"Michel Walsh" vanderghast@VirusAreFunnierThanSpam wrote in message
...
Hi,


use a sub-form?


Vanderghast, Access MVP


"John Marshall, MVP" wrote in message
...


(...)


Ideally I would like to see the form designers have the ability to
create a set of objects that can be placed on a page and that modifying
these objects would be reflected across all forms that use the objects.


(...)





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
creating controls on open forms Kenneth_J Setting Up & Running Reports 0 June 23rd, 2004 06:44 PM
Creating Forms Michelle New Users 2 May 21st, 2004 02:09 AM


All times are GMT +1. The time now is 10:27 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.