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)?
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