Topics Search

Dynamically creating table using form

Dynamically creating table using form
Views: 9
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
Sponsored Links:

Similar posts...

 

how to create unbound text-fields dynamically

how to create unbound text-fields dynamically Icon
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

Customisation of dynamically populated forms Icon
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?
 

Problem dynamically removing controls

Problem dynamically removing controls Icon
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:
 

Covering Microsoft Access 2007 and 2010

Covering Microsoft Access 2007 and 2010 Icon
- Brief overview of Relational Databases and Database Applications
- A Business Example
- Starting Microsoft Access
- Creating Table using Design View and Viewing Tables
- Viewing and Adding Data to a Table
- Creating Relationships Between tables
- Creating and Running Queries
- Single and Multiple Table Queries
- Creating and Running a Data Entry Form
- Creating a Single Table Form using the Wizard
- Review of Creating and Running a Data Entry Form
- Creating and Running a Report
- Creating a Single Table Report using the wizard
- Exercise: Creating a Single Table Report
- Review of Creating and Running a Report
- Creating and Running a Master/Detail Form
- Creating and Running a Switchboard
 

Trying to use a macro to load a form dynamically

Trying to use a macro to load a form dynamically Icon
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
 

Subform showing same record x times

Subform showing same record x times Icon
I have a form which has a listbox containing my tables. From that, I can successfully select a table and click on a button. There is a sub-form that has a recordsource that is set to the selected table.

I am able to dynamically change the captions to the correct field names for the table and can successfully display data for the fields.

However, where a table has x records, I get x instances of the SAME record (the first on the table) rather than seeing x separate records. x happily changes according to the selected table.

I am displaying the data in a datasheet as the sub-form;am using Access 2007; it is an Access Project with a SQL Server 2008 back-end.

Here is the code fired by the button when the table has been chosen from the list box.
 

How to calculate a field value dynamically in a table

How to calculate a field value dynamically in a table Icon
I have two tables. Product table has "product price" column. OrderLine table has "quantity ordered" column. I have a column "LineItemCost" in OrderLine table. The value for line item cost is (product price*quantity ordered). This needs to be updated dynamically in the OrderLine table when each row is created. Could someone help me with this? I am totally stuck and I am not very familiar with Access
 

Display web content on a form.

Display web content on a form. Icon
Is there a way to get web content to be displayed on a form. I have a form, and on it I would like to have the weather.

I only want to be able to display the web table that holds the 5 day forecast along with the graphics. What kind of object do I need to create on the form to hold the content and how would I go about retrieving it? Obviously it would need to update dynamically.
 

Hiding Code stored in the db (to execute with eval() function)

Hiding Code stored in the db (to execute with eval() function) Icon
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)?
 

Logic. What is better to creat a form from? A table or a query?

Logic. What is better to creat a form from? A table or a query? Icon
I've seen responses to my and other people problems and I've noticed that the gurus will sometimes recommend creating a form based on a query.

Can someone explain why that would be more beneficial or prudent rather than creating a form directly from a table? Or, maybe I misunderstood and it doesn't really matter. Either way,