If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I delete a subform and keep all the information?
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. "Carol M" wrote: 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" wrote: 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" wrote in message ... 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 "John Vinson" wrote: On Wed, 3 Aug 2005 08:38:42 -0700, "Carol M" wrote: 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] |
Thread Tools | |
Display Modes | |
|
|