Copy n Paste thru MainSwitchBoard

  • Thread starter Thread starter SeRene
  • Start date Start date
S

SeRene

Hi, I have provided command buttons for the user to view
all the tables on the form, frmMainSwitchBoard. However,
is it possible for me to allow the user to view and save
that table with the structure and data in it under another
name through the MainSwitchBoard?
I can't seem to find any macros or means to do this.

I can only copy n paste the desired table on the Access
main window.
I want to do this through the frmMainSwitchBoard. Is this
attainable??
 
What are you trying to accomplish by "saving the table ... under another
name"? I've done a lot of Access work in all versions and can't imagine a
situation where that would be either necessary or desirable. If you clarify,
it's possible someone may have a suggestion for accomplishing your purpose
in a simpler way.

If you are talking about the Form generated by the Switchboard Manager,
someone else would have to assist, in any case. I don't use the Switchboard
Manager, because I view it as a "complex solution to a simple problem". I
think the number of newsgroup questions on Switchboard Manager confirms my
view. I use simple, plain (usually unbound) forms with command buttons to
create switchboards -- it's simple, straightforward, and easy to maintain
(even for someone else who comes along after me to take over a database).

Larry Linson
Microsoft Access MVP
 
Actually, what i need to do is to have two identical
tables. The 1st table will contain all the information
which i import from a text file everyday. At the end of
the month, i need to have another copy of that table. The
2nd table is just an exact duplicate of the 1st table.

My frmMainSwitchBoard is not created using Wizard. Just a
simple, plain form.
 
Actually, what i need to do is to have two identical
tables. The 1st table will contain all the information
which i import from a text file everyday. At the end of
the month, i need to have another copy of that table. The
2nd table is just an exact duplicate of the 1st table.
Click to expand...

I'm with Larry. What EARTHLY good does this completely redundant table
do?
 
Hi John,

Umm... haha actually it doesnt really serve much purpose.
HOWEVER, my supervisor insisted on me doing it so what can
i do ya? =)

I can only copy and paste a table structure and its data
on the Access Main Window. I can't seem to do it on a
form! That's why i need help on this.
 
I have done this before....not that easy. I found the easiest way was to
create an update query to update the switchboard table and use the data from
another table ie.
Create the following tables:-

Switchboard - the built in access table
tblSwitchboard1 - User defined table1
tblSwitchboard2 - User defined table1
tblSwitchboard3 - User defined table1

Hope that helps.

Then create SQL statements that read from your table 1,2,3 to update the
Switchboard table.
 
Hi John,

Umm... haha actually it doesnt really serve much purpose.
HOWEVER, my supervisor insisted on me doing it so what can
i do ya? =)

I can only copy and paste a table structure and its data
on the Access Main Window. I can't seem to do it on a
form! That's why i need help on this.
Click to expand...

Create a MakeTable query based on the original table, with all fields
and no criteria, then. Sheesh. Some bosses!
 
Back
Top