C
Carol M
I am rebuilding an Access database and trying to delete a subform, but keep
all the data.
all the data.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
BruceM
Deleting a subform will not affect the data, which are stored in tables.
C
Carol M
The problem I have is that it does delete the stored data. My customer
database is linked to a customer category database which is the subform. Upon
deleting it, it also deletes the required information to create the new
database.
database is linked to a customer category database which is the subform. Upon
deleting it, it also deletes the required information to create the new
database.
J
John Vinson
The problem I have is that it does delete the stored data. My customer
database is linked to a customer category database which is the subform. Upon
deleting it, it also deletes the required information to create the new
database.
This isn't making sense, Carol.
As Bruce correctly says, the Subform doesn't contain any data. It
doesn't contain "the information needed to create the new database". A
subform (like any form) is *just a window* - a tool used to view and
edit data stored in Tables. The customer database IS NOT THE SUBFORM -
the subform is used to view and edit the customer database; but it is
no more the database than my office window is the Owyhee Mountain
range.
Are you deleting a Subform in Forms Design view? Or are you deleting a
Table? Could you explain how you're determining that it "deletes the
required information"? Just how are you deleting it?
John W. Vinson[MVP]
C
Carol M
What I'm trying to do is build a new database from old information, but I
have to leave out certain information. How can I find out what table my
subform is looking at short of viewing the relationships? When I delete a
subform it is after I have collapsed in back. As you might have guessed I am
new to this kind of form and that is why I am asking for help.
Thank you,
Carol M
have to leave out certain information. How can I find out what table my
subform is looking at short of viewing the relationships? When I delete a
subform it is after I have collapsed in back. As you might have guessed I am
new to this kind of form and that is why I am asking for help.
Thank you,
Carol M
R
Rick B
Is this a "subform" that is being viewed in a FORM as you have said, or a
"sub datasheet" that is being seen in the TABLE view by clicking the plus
sign to the left of the record? They are very different things.
In answer to your question, you say you want to create a new database with
only some of the data. Why not just create a new database and copy over the
tables with the data you want?
Your original question says you want to delete the subform (I'll assume you
mean subdatasheet) but keep the data. Why do you care if there is a
subdatasheet? You should not be in the tables. Once you build your
database structure, you should not go into the tables again. You should be
using forms, reports, and queries for all your user interface. Don't worry
about the subdatasheet. If you must get rid of it, Open your TABLE in
design-view, go to the PROPERTIES box and change the Subdatasheet Name to
[none].
"sub datasheet" that is being seen in the TABLE view by clicking the plus
sign to the left of the record? They are very different things.
In answer to your question, you say you want to create a new database with
only some of the data. Why not just create a new database and copy over the
tables with the data you want?
Your original question says you want to delete the subform (I'll assume you
mean subdatasheet) but keep the data. Why do you care if there is a
subdatasheet? You should not be in the tables. Once you build your
database structure, you should not go into the tables again. You should be
using forms, reports, and queries for all your user interface. Don't worry
about the subdatasheet. If you must get rid of it, Open your TABLE in
design-view, go to the PROPERTIES box and change the Subdatasheet Name to
[none].
C
Carol M
This is a "sub datasheet" that is being seen in the TABLE by clicking on the
plus sign. If I create a new database like suggested how do I copy over all
the information from the tables?
As far as my original question about deleting a subdatasheet without loss of
data, by changing the properities to none will that solve my problem. I have
to end up with a new file to be imported into a different kind of program,
but I have to keep all the records including any history that has been kept.
plus sign. If I create a new database like suggested how do I copy over all
the information from the tables?
As far as my original question about deleting a subdatasheet without loss of
data, by changing the properities to none will that solve my problem. I have
to end up with a new file to be imported into a different kind of program,
but I have to keep all the records including any history that has been kept.
Rick B said:Is this a "subform" that is being viewed in a FORM as you have said, or a
"sub datasheet" that is being seen in the TABLE view by clicking the plus
sign to the left of the record? They are very different things.
In answer to your question, you say you want to create a new database with
only some of the data. Why not just create a new database and copy over the
tables with the data you want?
Your original question says you want to delete the subform (I'll assume you
mean subdatasheet) but keep the data. Why do you care if there is a
subdatasheet? You should not be in the tables. Once you build your
database structure, you should not go into the tables again. You should be
using forms, reports, and queries for all your user interface. Don't worry
about the subdatasheet. If you must get rid of it, Open your TABLE in
design-view, go to the PROPERTIES box and change the Subdatasheet Name to
[none].
--
Rick B
Carol M said:What I'm trying to do is build a new database from old information, but I
have to leave out certain information. How can I find out what table my
subform is looking at short of viewing the relationships? When I delete a
subform it is after I have collapsed in back. As you might have guessed I am
new to this kind of form and that is why I am asking for help.
Thank you,
Carol M
R
Rick B
I don't know. You don't really provide enough detail to answer. Changing
the name to [none] as I suggested will NOT change your data at all.
subdatasheets are just a feature for you to view. Whether you can see them
or not does not affect your data in the slightest, so don't even mess with
them.
As far as exporting to another application, I guess it would all depend on
that application. Can it read jet database structure? Do you plan to
export your data to an Excel format? How about a csv file?
Have you tried exporting all the data? Or, ahve you tried the opposite
approach - going into your other application and importing the data? Access
is a very very popular database application and most programs should
recognize it.
--
Rick B
the name to [none] as I suggested will NOT change your data at all.
subdatasheets are just a feature for you to view. Whether you can see them
or not does not affect your data in the slightest, so don't even mess with
them.
As far as exporting to another application, I guess it would all depend on
that application. Can it read jet database structure? Do you plan to
export your data to an Excel format? How about a csv file?
Have you tried exporting all the data? Or, ahve you tried the opposite
approach - going into your other application and importing the data? Access
is a very very popular database application and most programs should
recognize it.
--
Rick B
Carol M said:This is a "sub datasheet" that is being seen in the TABLE by clicking on the
plus sign. If I create a new database like suggested how do I copy over all
the information from the tables?
As far as my original question about deleting a subdatasheet without loss of
data, by changing the properities to none will that solve my problem. I have
to end up with a new file to be imported into a different kind of program,
but I have to keep all the records including any history that has been kept.
Rick B said:Is this a "subform" that is being viewed in a FORM as you have said, or a
"sub datasheet" that is being seen in the TABLE view by clicking the plus
sign to the left of the record? They are very different things.
In answer to your question, you say you want to create a new database with
only some of the data. Why not just create a new database and copy over the
tables with the data you want?
Your original question says you want to delete the subform (I'll assume you
mean subdatasheet) but keep the data. Why do you care if there is a
subdatasheet? You should not be in the tables. Once you build your
database structure, you should not go into the tables again. You should be
using forms, reports, and queries for all your user interface. Don't worry
about the subdatasheet. If you must get rid of it, Open your TABLE in
design-view, go to the PROPERTIES box and change the Subdatasheet Name to
[none].
--
Rick B
guessed ICarol M said:What I'm trying to do is build a new database from old information, but I
have to leave out certain information. How can I find out what table my
subform is looking at short of viewing the relationships? When I delete a
subform it is after I have collapsed in back. As you might have
amnew to this kind of form and that is why I am asking for help.
Thank you,
Carol M
:
On Wed, 3 Aug 2005 08:38:42 -0700, "Carol M"
The problem I have is that it does delete the stored data. My customer
database is linked to a customer category database which is the subform. Upon
deleting it, it also deletes the required information to create the new
database.
This isn't making sense, Carol.
As Bruce correctly says, the Subform doesn't contain any data. It
doesn't contain "the information needed to create the new database". A
subform (like any form) is *just a window* - a tool used to view and
edit data stored in Tables. The customer database IS NOT THE SUBFORM -
the subform is used to view and edit the customer database; but it is
no more the database than my office window is the Owyhee Mountain
range.
Are you deleting a Subform in Forms Design view? Or are you deleting a
Table? Could you explain how you're determining that it "deletes the
required information"? Just how are you deleting it?
John W. Vinson[MVP]
B
BruceM
I can't figure out quite what you need to do, but I wonder if there is some
confusion of terminology. An Access database is a file that contains what
are referred to as Objects (tables, queries, forms, reports, and a couple of
other things). Another database would be a separate file.
Looking at relationships is the way to see what table another table is
"looking at". It is not a big deal, and could provide information pertinent
to the question at hand.
It would help if you explain what your database does, how it is set up (in
general terms), and to what type of file you wish to export the data. If you
are exporting data from related tables into a flat file such as a spreadsheet
you may not be able to achieve satisfactory results.
confusion of terminology. An Access database is a file that contains what
are referred to as Objects (tables, queries, forms, reports, and a couple of
other things). Another database would be a separate file.
Looking at relationships is the way to see what table another table is
"looking at". It is not a big deal, and could provide information pertinent
to the question at hand.
It would help if you explain what your database does, how it is set up (in
general terms), and to what type of file you wish to export the data. If you
are exporting data from related tables into a flat file such as a spreadsheet
you may not be able to achieve satisfactory results.
Carol M said:This is a "sub datasheet" that is being seen in the TABLE by clicking on the
plus sign. If I create a new database like suggested how do I copy over all
the information from the tables?
As far as my original question about deleting a subdatasheet without loss of
data, by changing the properities to none will that solve my problem. I have
to end up with a new file to be imported into a different kind of program,
but I have to keep all the records including any history that has been kept.
Rick B said:Is this a "subform" that is being viewed in a FORM as you have said, or a
"sub datasheet" that is being seen in the TABLE view by clicking the plus
sign to the left of the record? They are very different things.
In answer to your question, you say you want to create a new database with
only some of the data. Why not just create a new database and copy over the
tables with the data you want?
Your original question says you want to delete the subform (I'll assume you
mean subdatasheet) but keep the data. Why do you care if there is a
subdatasheet? You should not be in the tables. Once you build your
database structure, you should not go into the tables again. You should be
using forms, reports, and queries for all your user interface. Don't worry
about the subdatasheet. If you must get rid of it, Open your TABLE in
design-view, go to the PROPERTIES box and change the Subdatasheet Name to
[none].
--
Rick B
Carol M said:What I'm trying to do is build a new database from old information, but I
have to leave out certain information. How can I find out what table my
subform is looking at short of viewing the relationships? When I delete a
subform it is after I have collapsed in back. As you might have guessed I am
new to this kind of form and that is why I am asking for help.
Thank you,
Carol M
:
On Wed, 3 Aug 2005 08:38:42 -0700, "Carol M"
The problem I have is that it does delete the stored data. My customer
database is linked to a customer category database which is the subform. Upon
deleting it, it also deletes the required information to create the new
database.
This isn't making sense, Carol.
As Bruce correctly says, the Subform doesn't contain any data. It
doesn't contain "the information needed to create the new database". A
subform (like any form) is *just a window* - a tool used to view and
edit data stored in Tables. The customer database IS NOT THE SUBFORM -
the subform is used to view and edit the customer database; but it is
no more the database than my office window is the Owyhee Mountain
range.
Are you deleting a Subform in Forms Design view? Or are you deleting a
Table? Could you explain how you're determining that it "deletes the
required information"? Just how are you deleting it?
John W. Vinson[MVP]
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.