Topics Search

Create Form Dynamically

Create Form Dynamically
Views: 3
I have a database that creates a dynamic table of data for 6 current months. This is shown in datasheet view on my form. The problem is, the form points specifically to 6 columns in the original table.

These columns are actually months (2/1/2012, 3/1/2012, 4/1/2012, etc.) When this table is recreated, those column names will change based on the months that are being run. I think that I need to also dynamically create this form so that it reads the table correctly.
Sponsored Links:

More topics

 

how to create unbound text-fields dynamically

Preview
How to create text-fields dynamically in a form using a VBA script.

my problem is: I have to create a multi dimensional control array (textfeilds) in a form to collect data and save it to a table, I tried several methods to create text-fields but couldn't make it.
 

Customisation of dynamically populated forms

Preview
I have a series of forms and subforms which cascade to dynamically create a checklist form of certain questions and answers dependant on the choices selected by the user.

This works by dynamically populating the form with whatever questions are required from the relevant tables

The check-list actually works quite well however I can only get the form to display 1 question at a time in single form view or all questions at a time for continuous form view. I do not want to use datasheet view

So therefore is there more customisation I can do with continuous view in code to show a certain number of questions per page for example, I don't like the scroll options I want to do everything with command buttons?
 

Customisation of dynamically populated forms

Preview
I have a series of forms and subforms which cascade to dynamically create a checklist form of certain questions and answers dependant on the choices selected by the user.

This works by dynamically populating the form with whatever questions are required from the relevant tables

The check-list actually works quite well however I can only get the form to display 1 question at a time in single form view or questions at a time for continuous form view. I do not want to use datasheet view

So therefore is there more customisation I can do with continuous view in code to show a certain number of questions per page for example, I don't like the scroll options I want to do everything with command buttons?
 

Problem dynamically removing controls

Preview
So now we've having tons of fun. edit, and remove records which relate to pedagogical items on a whim. There is no scenario where the number of these items will ever exceed 75.

These items are then used to create table columns on a separate table. This also means that the user entry form must be updated to reflect these fields.

Right now I'm able to pull the names and build the fields dynamically; however, I'm having a problem removing them:
 

Dynamically creating table using form

Preview
I am trying to dynamically creating tables in Access 2010.
I would like to get the info from the user (Table name, number&type of columns)
and then creating the table using an SQL Query.

I know how to write the query, but I need help with passing the arguments to the query
 

Trying to use a macro to load a form dynamically

Preview
Windows Vista
Access 2007

This is my first post here and I need a little help. I'm trying to load a form dynamically and it doesn't seem to be working. I'm using the OpenForm macro and in the "Where condition" field I'm using '[Forms]![toddler_times]![student_id]=[Forms]![bathroom_chart]![bt_student_id]'. When the form loads it doesn't load any of the corresponding records (and yes there are records in the table
 

Is there a way to prevent a form from updating its content dynamically?

Preview
I was wondering if anyone knew of any way to prevent a form from updating its content against the tables dynamically?

I have some subroutines that check what values the fields have, and deactivates some of the fields based on the values.
(Every field that is not "0" is deactivated with on current).

The problem is that when two or more users are using the database, and one of them changes one of the fields, this changes suddenly appears in the other users' form as well.
This as I huge problem, as the fields doesn't get deactivated when the data appears in this way.

I would really need some way to prevent this from happening, so that the only time the form would update its info is when the record is changed or manually updated
 

Dynamically pass parameter from form to report

Preview
I'm working with Access 2010 and converted my Access project to an ADP file. In order for me to write a report which can accept a parameter I need to write a stored procedure - which I've done.

I've got a form with a command button to open the report, but my problem is that I would like the command button to dynamically pick up the active record id (record id currently displayed on the form) and pass that through to the report as a parameter instead of the report prompting me for the record id parameter.
 

Hiding code

Preview
I have created specific functions (Public () as.) whose code is stored in table fields. When some of these specific functions are needed, I read the table content,dynamically create a new module, put the function code within, make an Eval() to get a result, and erase the dynamically created module.

My problem is that the VBA editor window is launched. Is there a way to prevent its display (by code or something else)?
 

Load Subforms Dynamically

Preview
Subforms are one of the great features of Microsoft Access. If you have ever tried to replicate the Form/Subform paradigm of Access in Visual Basic, you will appreciate how simple the process really is.
1. Create the master form
2. Create the child form
3. Drag child form and drop on master form
4. Set the Link Master Field and Link Child Field properties