Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / June 2007

Tip: Looking for answers? Try searching our database.

Dynamic Forms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dmericksen - 15 Jun 2007 17:07 GMT
I am trying to create a dynamic form.  Here is how it works: the user selects
a query, and hits submit on a menu form.  A form is then created and the
record source is assigned based on the users initial query selection.  Now
the question/problem:

Once the form is loaded, all of the captions/labels are generic.  I would
like to change this using vba.  Is there any way to get column header
information on the query programmatically?

Ideas?
James A. Fortune - 15 Jun 2007 23:38 GMT
> I am trying to create a dynamic form.  Here is how it works: the user selects
> a query, and hits submit on a menu form.  A form is then created and the
[quoted text clipped - 6 lines]
>
> Ideas?

I posted some (rough) form creation code here:

http://groups.google.com/group/microsoft.public.access/msg/0fd179f25848911f

If I'm not mistaken, it sounds like you want to look at the Fields
collection of the QueryDef object to obtain the names of the fields to
use within control names on your dynamic form.  Including the query name
as a hidden column in the combobox is a simple way to obtain the chosen
QueryDef name.

James A. Fortune
MPAPoster@FortuneJames.com
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.