Hi Tiffany,
> Tim I would love to that! But I have a much bigger problem right now and I could desperately use some help. I lost all my data, the database is still there but the data is gone. How do I append data from an old database? I just keeping getting error messages..
> How can I copy data from one table to another? I lost ALL the data I was working on in my latest version and I need to restore the data from previous table I was using. My database is still intact but the data is gone. And, I do not want to have to start over on the imported one. I just need to get the data moved over from one table to the other.
If the table is empty and you have another copy in your newest database or in an older database you can delete the *empty* table and copy and paste or import the table with data.
If your data is in another table in your latest database:
Right click on the name of the table with data in the Database Window or Navigation Pane and copy it. Then you can paste it into the database window and rename it if needed. If you are using Access 2007 or 2010 right click on the top bar of the Navigation Pane and select Paste. Give the table the old table's name.
If your data is in a table in an earlier version:
You can import the table from the old database into the newer one. You can then rename the imported table if needed. First you will need to delete the existing *empty* table if it still exists.
Access 2003
On the Menu Bar click File > Get External Data > Import. Then browse to and select the old database and click the Import button. The Import Object dialog should appear. Click on the tables tab and select the table you need to import. Click on the Options button and under Import, check Relationships. Next click the OK button. After the table is imported you can rename the table if needed.
Access 2007
Click on the External Database Tab and then click on the Access icon. Select Import tables, etc. Then click on the Browse button and browse to and select the old database click OK and then click OK again. You should see a tabbed dialog. Click on the tables tab and select the table you need to import. After it is imported you can rename the table if needed.
Patrick Wood, Access MVP
http://gainingaccess.net
--- In MS_Access_Professionals@yahoogroups.com, cc0623 <cc0623@...> wrote:
>
> Tim I would love to that! But I have a much bigger problem right now and I could desperately use some help. I lost all my data, the database is still there but the data is gone. How do I append data from an old database? I just keeping getting error messages..
>
>
>
>
>
> ________________________________
> From: juiceplustim <tritter@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Friday, October 7, 2011 3:25 PM
> Subject: [MS_AccessPros] Re: I need help understanding something....
>
>
> Â
> Tiffany,
> Just another 2 cents to throw in here. If the boss wants to see them flipping back and forth between 2 spreadsheets, you can do that with the 1 table and 1 form - similar to what everyone else is suggesting, with just 1 sneaky addition.
> On the form you can put a tab control. Make it look just like tabs the boss is used to using. You can then either put a version of the datasheet on a subform on each tab - filtered to show sold or active. Or, with a bit of coding - you could just have a single datasheet sitting outside of the tab controls (nothing on the tab pages - just for show), and when a tab is clicked - the datasheet refreshes with a new filter to show sold or active assets according to which tab the boss clicks.
> Keep the form simple for your sake with a single form - but you can usually make it work and look like the user needs - with a little creative usage of the controls.
> FWIW,
> Tim Ritter
> Fort Wayne, IN
>
> > Subject: Re: [MS_AccessPros] I need help understanding something....
> >
> > I wish it was that simple.... The reason why I need two forms is because my boss
> > wants to visually see in a datasheet view the "active assets"Â in one form and
> > the "sold" in the other. What it basically comes down to is she is to used to
> > flipping back and forth between the spreadsheets she has been using for the last
> > 6 years.Â
> > Â
> > So... based on the table "Assets" I have created a datasheet form called Assets,
> > then copied that form and renamed the new form "Sold Assets". There is a
> > checkbox titled "sold" in all three. I want her to be able to check the box in
> > the "Assets" form and it will move the record into the "Sold" form. The original
> > record will always stay in the Assets table.
> > Â
> > How would I be able to do this?
> > Â
> > Thanks,
> > Â
> > Tiffany
> >
> >
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar