|
 |
access thread: Delete Table
Message #1 by "Maha Arupputhan Pappan" <mahap@p...> on Tue, 21 May 2002 11:50:25
|
|
Hi all,
Good day.
I have 2 databases. DB1 does all the job and DB2 practically collects
data. DB2 contains only 1 table (TBL1). I wish delete this table (TBL1)
from DB1 form. There is no link tables from DB1 to DB2.
How to complete this task?
Thanks,
Maha
Message #2 by ProDev <prodevmg@y...> on Tue, 21 May 2002 07:24:41 -0700 (PDT)
|
|
--0-597737428-1021991081=:89057
Content-Type: text/plain; charset=us-ascii
Open the database. Go to the database window. Go to the tables tab. Highlight the table. Hit the delete button on your keyboard.
I hope I understood you correctly.
Maha Arupputhan Pappan <mahap@p...> wrote: Hi all,
Good day.
I have 2 databases. DB1 does all the job and DB2 practically collects
data. DB2 contains only 1 table (TBL1). I wish delete this table (TBL1)
from DB1 form. There is no link tables from DB1 to DB2.
How to complete this task?
Thanks,
Maha
Lonnie Johnson
ProDev, Builders of MS Access Databases
http://www.galaxymall.com/software/PRODEV
---------------------------------
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
Message #3 by "Maha Arupputhan Pappan" <mahap@p...> on Wed, 22 May 2002 02:30:23
|
|
Hi Lonnie,
Good day.
May be I made a mistake in my earlier message. I need assistance in
writing code to delete the table.
I have a form (F1) with a command button (CB1) in DB1. When I click CB1,
the action should delete TBL1 in DB2.
Now, thats what I want.
Thanks,
Maha
> --0-597737428-1021991081=:89057
Content-Type: text/plain; charset=us-ascii
Open the database. Go to the database window. Go to the tables tab.
Highlight the table. Hit the delete button on your keyboard.
I hope I understood you correctly.
Maha Arupputhan Pappan <mahap@p...> wrote: Hi all,
Good day.
I have 2 databases. DB1 does all the job and DB2 practically collects
data. DB2 contains only 1 table (TBL1). I wish delete this table (TBL1)
from DB1 form. There is no link tables from DB1 to DB2.
How to complete this task?
Thanks,
Maha
Lonnie Johnson
ProDev, Builders of MS Access Databases
http://www.galaxymall.com/software/PRODEV
---------------------------------
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
Message #4 by "Wesley Kendrick" <wez.k@n...> on Wed, 22 May 2002 08:44:59 +0100
|
|
Hi, hope you dont mind me butting in, you can delete a table like this:-
DoCmd.DeleteObject acTable, "your table name"
Regards, Wesley Kendrick
----- Original Message -----
From: "Maha Arupputhan Pappan" <mahap@p...>
To: "Access" <access@p...>
Sent: Wednesday, May 22, 2002 2:30 AM
Subject: [access] Re: Delete Table
> Hi Lonnie,
>
> Good day.
>
> May be I made a mistake in my earlier message. I need assistance in
> writing code to delete the table.
>
> I have a form (F1) with a command button (CB1) in DB1. When I click CB1,
> the action should delete TBL1 in DB2.
>
> Now, thats what I want.
>
> Thanks,
> Maha
>
> > --0-597737428-1021991081=:89057
> Content-Type: text/plain; charset=us-ascii
>
>
> Open the database. Go to the database window. Go to the tables tab.
> Highlight the table. Hit the delete button on your keyboard.
> I hope I understood you correctly.
>
> Maha Arupputhan Pappan <mahap@p...> wrote: Hi all,
>
> Good day.
>
> I have 2 databases. DB1 does all the job and DB2 practically collects
> data. DB2 contains only 1 table (TBL1). I wish delete this table (TBL1)
> from DB1 form. There is no link tables from DB1 to DB2.
>
> How to complete this task?
>
> Thanks,
> Maha
>
> Lonnie Johnson
> ProDev, Builders of MS Access Databases
> http://www.galaxymall.com/software/PRODEV
>
>
>
>
> ---------------------------------
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience
> --0-597737428-1021991081=:89057
> Content-Type: text/html; charset=us-ascii
>
> <P> Open the database. Go to the database window. Go to the tables tab.
> Highlight the table. Hit the delete button on your keyboard.
> <P>I hope I understood you correctly.
> <P>
> <P> <B><I>Maha Arupputhan Pappan <mahap@p...></I></B>
> wrote:
> <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT:
> #1010ff 2px solid">Hi all,<BR><BR>Good day.<BR><BR>I have 2 databases. DB1
> does all the job and DB2 practically collects <BR>data. DB2 contains only
> 1 table (TBL1). I wish delete this table (TBL1) <BR>from DB1 form. There
> is no link tables from DB1 to DB2.<BR><BR>How to complete this task?
> <BR><BR>Thanks,<BR>Maha<BR>---<BR>
> http://p2p.wrox.com/manager.asp or <BR>to unsubscribe send a blank email
> to </BLOCKQUOTE><BR><BR>Lonnie Johnson
> <BR><STRONG>ProDev</STRONG>, Builders of MS Access Databases<BR><A
> href="http://www.galaxymall.com/software/PRODEV
">http://www.galaxymall.com
> /software/PRODEV <BR></A><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br>
> <a
href="http://rd.yahoo.com/welcome/*http://launch.yahoo.com">LAUNCH</a> -
> Your Yahoo! Music Experience
> --0-597737428-1021991081=:89057--
>
Message #5 by "Maha Arupputhan Pappan" <mahap@p...> on Wed, 22 May 2002 11:26:41
|
|
Hi Wesley,
Thank you very much for your advise.
This command, yes can delele a table if you are sending this command from
within a database.
How if I wish to delete a table in another database from within another
database. Let me explain again:
I need to send this delete command from DB1 to delete a table in DB2.
Please help.
Thanks,
Maha
> Hi, hope you dont mind me butting in, you can delete a table like this:-
DoCmd.DeleteObject acTable, "your table name"
Regards, Wesley Kendrick
----- Original Message -----
From: "Maha Arupputhan Pappan" <mahap@p...>
To: "Access" <access@p...>
Sent: Wednesday, May 22, 2002 2:30 AM
Subject: [access] Re: Delete Table
> Hi Lonnie,
>
> Good day.
>
> May be I made a mistake in my earlier message. I need assistance in
> writing code to delete the table.
>
> I have a form (F1) with a command button (CB1) in DB1. When I click CB1,
> the action should delete TBL1 in DB2.
>
> Now, thats what I want.
>
> Thanks,
> Maha
>
> > --0-597737428-1021991081=:89057
> Content-Type: text/plain; charset=us-ascii
>
>
> Open the database. Go to the database window. Go to the tables tab.
> Highlight the table. Hit the delete button on your keyboard.
> I hope I understood you correctly.
>
> Maha Arupputhan Pappan <mahap@p...> wrote: Hi all,
>
> Good day.
>
> I have 2 databases. DB1 does all the job and DB2 practically collects
> data. DB2 contains only 1 table (TBL1). I wish delete this table (TBL1)
> from DB1 form. There is no link tables from DB1 to DB2.
>
> How to complete this task?
>
> Thanks,
> Maha
>
> Lonnie Johnson
> ProDev, Builders of MS Access Databases
> http://www.galaxymall.com/software/PRODEV
>
>
>
>
> ---------------------------------
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience
> --0-597737428-1021991081=:89057
> Content-Type: text/html; charset=us-ascii
>
> <P> Open the database. Go to the database window. Go to the tables tab.
> Highlight the table. Hit the delete button on your keyboard.
> <P>I hope I understood you correctly.
> <P>
> <P> <B><I>Maha Arupputhan Pappan <mahap@p...></I></B>
> wrote:
> <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT:
> #1010ff 2px solid">Hi all,<BR><BR>Good day.<BR><BR>I have 2 databases.
DB1
> does all the job and DB2 practically collects <BR>data. DB2 contains only
> 1 table (TBL1). I wish delete this table (TBL1) <BR>from DB1 form. There
> is no link tables from DB1 to DB2.<BR><BR>How to complete this task?
> <BR><BR>Thanks,<BR>Maha<BR>---<BR>
> http://p2p.wrox.com/manager.asp or <BR>to unsubscribe send a blank email
> to </BLOCKQUOTE><BR><BR>Lonnie Johnson
> <BR><STRONG>ProDev</STRONG>, Builders of MS Access Databases<BR><A
> href="http://www.galaxymall.com/software/PRODEV
">http://www.galaxymall.com
> /software/PRODEV <BR></A><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br>
> <a
href="http://rd.yahoo.com/welcome/*http://launch.yahoo.com">LAUNCH</a> -
> Your Yahoo! Music Experience
> --0-597737428-1021991081=:89057--
>
|
|
|
View Cart
