How to Create Dynamic Tables in MS-Access?
I will just pass the Arguments and the Code will Create the tables dynamically/run-time.
7  11817 
You can use create table key word to create table like - CREATE TABLE tblTableName (lngNumericFieldName Long, strTextFieldName TEXT)
Sorry Hari, but that doesn't work with Access/VBA. The syntax for a make-table query is:
SELECT [ALL:DISTINCT] select_list
INTO new_table
FROM source_table
[WHERE criteria ]
This can be run from VBA using the DoCmd.RunSQL command.
Regards,
Scott
Sorry Hari, but that doesn't work with Access/VBA. The syntax for a make-table query is:
Okay No problem, But that query is common to all Database which will create table dynamically.
Okay No problem, But that query is common to all Database which will create table dynamically.
Actually it uses standard SQL language. However, Access uses a version of SQL that MS has 'optimized' for their own purposes. It's called Jet SQL, after the Jet database engine that MS Access has been using (at least up till A2003).
Regards,
Scott
Okay that's good information. Thank you to share with me.
Hi, everyone.
Actually Access does support CREATE TABLE statement.
Strangely enough, it does! Sorry Hari... I was under the impression that it didn't.
Thanks for pointing it out, Fish.
Regards,
Scott
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Cindy |
last post by:
hi,
Can someone point me to a website where I can find a "create dynamic rows"
javascript that work for IE, NS6 & NS7?
Thank You.
regards,
Cindy
|
by: Karsten |
last post by:
Hi,
I want to create dynamic reports with C# and MS SQL-Server 2005
Reporting Services.
Since the reporting service uses a data-table or data-view, I want to
create a view dynamically.
How...
|
by: BlueSky |
last post by:
Hi All,
I am planning to create dynamic pdf documents in .NET ( for example, I will
have to create tables with user input rows and columns). Can anyone recommend
me a 3rd party component that is...
|
by: brstowe |
last post by:
Firstly I consider myself quite an experienced SQL Server user, and
am
now using SQL Server 2005 Express for the main backend of my
software.
My problem is thus: The boss needs to run reports;...
|
by: plsHelpMe |
last post by:
How to create dynamic javascript arrays using dojo toolkits
Hello frens,
I am in a big trouble. My objective is:
I am having some categories shown by differnent radio buttons, on the click of...
|
by: MaryamSh |
last post by:
Create Dynamic Dropdownlist Controls and related event
--------------------------------------------------------------------------------
Hi,
I am creating a Dynamic Search in my application.
I...
|
by: murderof1 |
last post by:
Hello,
I'm new to Javascript, but I'm trying to create html tables based off a checkbox action. Is it possible to do this on the same page?
I've noticed that document.write() will create the...
|
by: DeanL |
last post by:
Hi guys,
Does anyone know of a way to create multiple tables using information
stored in one table? I have a table with 4 columns (TableName,
ColumnName, DataType, DataSize) and wanted to know...
|
by: Michael Munch |
last post by:
Hi
I want to read the value of af text-field, create dynamic, in a form.
Se below a small test-site to do that (but readning fails):
I use the function Test_Read for reading the value from the...
|
by: remya1000 |
last post by:
i'm using VB \ ASP.NET.
i'm trying to display some values in Gridview. but i don't know how many columns i need to display. at run time only i will come to know how many columns i need to...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
