1ad84 SQL sentence for make table
Sign Up |  Live StatsLive Stats    Articles 37,308| Comments 177,006| Members 19,397, Newest birinder| Online 427
Home Contact
 (Forgotten?): 
    Sikhism
    For best SPN experience, use Firefox Internet Browser!


                                                                   Your Banner Here!    




SQL sentence for make table

Our Donation Goal : Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters
Goal this month: 500 USD, Received: 100 USD (20%)
Please Donate...
     
Related Topics...
Thread Thread Starter Forum Replies Last Post
Make Table Query and AutoNumbers Nicholajlg Information Technology 4 28-Jul-2006 08:42 AM
Parameter for Database in a make table query BD Information Technology 1 28-Jul-2006 08:23 AM
Make-table Query - Destination DB question Scott Information Technology 4 28-Jul-2006 08:10 AM
Yes/No field in a table-Make exclusive or default? Karl H Information Technology 3 13-Nov-2005 17:33 PM
How to make a formal THANK YOU sentence ? Martin Information Technology 4 05-Nov-2005 12:48 PM


Tags
make, sentence, sql, table
Reply Post New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!
  #1 (permalink)  
Old 28-Jul-2006, 08:19 AM
yaniv d's Avatar yaniv d
Guest
 
Posts: n/a
   
   
SQL sentence for make table

  Donate Today!   Email to Friend  Tell a Friend   Show Printable Version  Print   Contact sikhphilosophy.net Administraion for any Suggestions, Ideas, Feedback.  Feedback  

Register to Remove Advertisements
hi all,
i built SQL sentences that are making tables dinamicly,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11232-sql-sentence-for-make-table.html
my problem is that everytime a table is going to be made,the is a
message asking for approval of the make table.
how can i make the table without this message?


*







Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 28-Jul-2006, 08:19 AM
strive4peace's Avatar strive4peace
Guest
 
Posts: n/a
   
   
Re: SQL sentence for make table -- use CurrentDb.Execute

instead of using

doCmd.RunSQL strSQL

use

CurrentDb.Execute strSQL, dbFailOnError

why are you making a bunch of tables as opposed to using
select queries?

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232
remote programming and training
strive4peace2006 at yahoo.com

*

yaniv d wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232
> hi all,
> i built SQL sentences that are making tables dinamicly,
> my problem is that everytime a table is going to be made,the is a
> message asking for approval of the make table.
> how can i make the table without this message?
>

Reply With Quote
  #3 (permalink)  
Old 28-Jul-2006, 08:19 AM
Steve Schapel's Avatar Steve Schapel
Guest
 
Posts: n/a
   
   
Re: SQL sentence for make table

Yaniv,

I assume you are using the
DoCmd.OpenQuery
method in your code, to run the make-table query.

You can put this before...
DoCmd.SetWarnings False

.... and this after...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232
DoCmd.SetWarnings True

--
Steve Schapel, Microsoft Access MVP

yaniv d wrote:
> hi all,
> i built SQL sentences that are making tables dinamicly,
> my problem is that everytime a table is going to be made,the is a
> message asking for approval of the make table.
> how can i make the table without this message?
>

Reply With Quote
  #4 (permalink)  
Old 28-Jul-2006, 08:19 AM
yaniv d's Avatar yaniv d
Guest
 
Posts: n/a
   
   
Re: SQL sentence for make table -- use CurrentDb.Execute

i need to make a table contain data from a table and a query when
opening a form and delete the table after leaving the form

thanks for your help

strive4peace wrote:
> instead of using
>
> doCmd.RunSQL strSQL
>
> use
>
> CurrentDb.Execute strSQL, dbFailOnError
>
> why are you making a bunch of tables as opposed to using
> select queries?
>
> Warm Regards,
> Crystal
> Microsoft Access MVP 2006
>
> *
> Have an awesome day
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232
>
> remote programming and training
> strive4peace2006 at yahoo.com
>
> *
>
> yaniv d wrote:
> > hi all,
> > i built SQL sentences that are making tables dinamicly,
> > my problem is that everytime a table is going to be made,the is a
> > message asking for approval of the make table.
> > how can i make the table without this message?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232
> >


Reply With Quote
  #5 (permalink)  
Old 28-Jul-2006, 08:19 AM
Michael Gramelspacher's Avatar Michael Gramelspacher
Guest
 
Posts: n/a
   
   
Re: SQL sentence for make table

In article <1150097288.394383.10020@y43g2000cwc.googlegroups.c om>,
yaniv.dg@gmail.com says...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232
> hi all,
> i built SQL sentences that are making tables dinamicly,
> my problem is that everytime a table is going to be made,the is a
> message asking for approval of the make table.
> how can i make the table without this message?
>
>

You should look for a Microsoft Access 2000 Technical Article,
Fundamental Microsoft Jet SQL for Access 2000.

An example of a Make Table query:

Dim cmd As New ADODB.Command
Dim strSQL As String

cmd.ActiveConnection = CurrentProject.AccessConnection

strSQL = "CREATE TABLE MediaOptions " & _
"(media_type INTEGER NOT NULL PRIMARY KEY, " & _
"description CHAR(10) NOT NULL, " & _
"price DECIMAL(12, 4) NOT NULL, " & _
"CHECK (price >= 0.00)); "
cmd.CommandText = strSQL
cmd.Execute
'Debug.Print "Table MediaOptions created."

strSQL = "CREATE TABLE Sales " & _
"(sales_ticket INTEGER NOT NULL, " & _
"CONSTRAINT validate_sales_ticket " & _
"CHECK (sales_ticket LIKE '[0-9][0-9][0-9][0-9][0-9]'), " & _
"media_type INTEGER NOT NULL " & _
"References MediaOptions(media_type) " & _
" ON UPDATE CASCADE, " & _
"sale_date DATETIME DEFAULT Now() NOT NULL);"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232
cmd.CommandText = strSQL
cmd.Execute
'Debug.Print "Table Sales created."



Reply With Quote
  #6 (permalink)  
Old 28-Jul-2006, 08:19 AM
yaniv d's Avatar yaniv d
Guest
 
Posts: n/a
   
   
Re: SQL sentence for make table

thanks alot to all of you!!!

Michael Gramelspacher wrote:
> In article <1150097288.394383.10020@y43g2000cwc.googlegroups.c om>,
> yaniv.dg@gmail.com says...
> > hi all,
> > i built SQL sentences that are making tables dinamicly,
> > my problem is that everytime a table is going to be made,the is a
> > message asking for approval of the make table.
> > how can i make the table without this message?
> >
> >

> You should look for a Microsoft Access 2000 Technical Article,
> Fundamental Microsoft Jet SQL for Access 2000.
>
> An example of a Make Table query:
>
> Dim cmd As New ADODB.Command
> Dim strSQL As String
>
> cmd.ActiveConnection = CurrentProject.AccessConnection
>
> strSQL = "CREATE TABLE MediaOptions " & _
> "(media_type INTEGER NOT NULL PRIMARY KEY, " & _
> "description CHAR(10) NOT NULL, " & _
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232
> "price DECIMAL(12, 4) NOT NULL, " & _
> "CHECK (price >= 0.00)); "
> cmd.CommandText = strSQL
> cmd.Execute
> 'Debug.Print "Table MediaOptions created."
>
> strSQL = "CREATE TABLE Sales " & _
> "(sales_ticket INTEGER NOT NULL, " & _
> "CONSTRAINT validate_sales_ticket " & _
> "CHECK (sales_ticket LIKE '[0-9][0-9][0-9][0-9][0-9]'), " & _
> "media_type INTEGER NOT NULL " & _
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232
> "References MediaOptions(media_type) " & _
> " ON UPDATE CASCADE, " & _
> "sale_date DATETIME DEFAULT Now() NOT NULL);"
> cmd.CommandText = strSQL
> cmd.Execute
> 'Debug.Print "Table Sales created."


Reply With Quote
  #7 (permalink)  
Old 28-Jul-2006, 08:19 AM
Steve Schapel's Avatar Steve Schapel
Guest
 
Posts: n/a
   
   
Re: SQL sentence for make table -- use CurrentDb.Execute

Yaniv,

As Crystal intimated, this is a very unusual requirement, and I also
would suspect there is an easier way.

--
Steve Schapel, Microsoft Access MVP

yaniv d wrote:
> i need to make a table contain data from a table and a query when
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232
> opening a form and delete the table after leaving the form

Reply With Quote
  #8 (permalink)  
Old 28-Jul-2006, 08:19 AM
yaniv d's Avatar yaniv d
Guest
 
Posts: n/a
   
   
Re: SQL sentence for make table -- use CurrentDb.Execute

  Donate Today!  
there is a simple way.but my problem for now is that i need to make it
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232
for a multi-user and that complicating the issue becaouse i need to
make tables that will be attached for every user that will use it
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232

Steve Schapel wrote:
> Yaniv,
>
> As Crystal intimated, this is a very unusual requirement, and I also
> would suspect there is an easier way.
>
> --
> Steve Schapel, Microsoft Access MVP
>
> yaniv d wrote:
> > i need to make a table contain data from a table and a query when
> > opening a form and delete the table after leaving the form


Reply With Quote
  #9 (permalink)  
Old 28-Jul-2006, 08:19 AM
John Vinson's Avatar John Vinson
Guest
 
Posts: n/a
   
   
Re: SQL sentence for make table -- use CurrentDb.Execute

On 12 Jun 2006 22:48:36 -0700, "yaniv d" wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232

>there is a simple way.but my problem for now is that i need to make it
>for a multi-user and that complicating the issue becaouse i need to
>make tables that will be attached for every user that will use it


Why?

What can you do with individual tables which cannot be done with a
select query, filtering on the UserID field (which you might need to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232
add to your table)? Storing data (a user's identity) in a tablename is
probably a Very Bad Idea.

Or, could you use a split database, with the source table in the
backend, and the individual tables in each user's frontend .mdb file?

John W. Vinson[MVP]
Reply With Quote
   Click Here to Donate Now!

Support Us!
Become a Promoter!
Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh!
ReplyPost New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!

Bookmarks


(View-All Members who have read this thread : 0
There are no names to display.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Tools Search
Search:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

» Active Discussions
Iman: Sack Liberal...
Today 01:34 AM
0 Replies, 1 Views
Why are There so Many...
Today 01:09 AM
55 Replies, 4,897 Views
Do you believe in...
Today 01:06 AM
176 Replies, 3,640 Views
BHOOTS (Ghosts) and...
Today 00:22 AM
95 Replies, 13,772 Views
How does Sikhi help you...
Today 00:19 AM
15 Replies, 426 Views
Thought of the Moment!
Yesterday 19:38 PM
106 Replies, 5,013 Views
Panjabi
Yesterday 19:35 PM
10 Replies, 216 Views
Textbooks Terming Sikhs...
Yesterday 18:52 PM
13 Replies, 203 Views
Map shows world's 'most...
Yesterday 18:12 PM
14 Replies, 208 Views
Friends. A Testimony to...
Yesterday 17:31 PM
3 Replies, 81 Views
Hidden, in plain sight -...
Yesterday 17:00 PM
0 Replies, 24 Views
Nitnem Gutka - Gurmukhi...
By Ishna
Yesterday 12:27 PM
15 Replies, 16,404 Views
Poetry Corner
Yesterday 12:13 PM
83 Replies, 9,596 Views
Learn Punjabi Yourself...
Yesterday 05:41 AM
15 Replies, 7,621 Views
Sikh Spokesman (ਪੰਜਾਬੀ...
Yesterday 05:32 AM
167 Replies, 4,311 Views
» Books You Should Read...
Powered by vBadvanced CMPS v3.2.3
All times are GMT +6.5. The time now is 01:37 AM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2 Copyright © 2004-12, All Rights Reserved. Sikh Philosophy Network


Page generated in 0.50859 seconds with 32 queries
0