Dynamically creating table using form
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
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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.
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?
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:
- 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
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
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.
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.
My problem is that the VBA editor window is launched. Is there a way to prevent its display (by code or something else)?
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,