Tiffany-
What two tables? If data is in one table that you want "copied" to another, build an Append query on the table that contains the data you want copied, and make the other table the target. "Run" the query to copy the records.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of cc0623
Sent: Friday, October 07, 2011 11:01 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] I need help understanding something....
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.
________________________________
From: cc0623 <cc0623@yahoo.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, October 7, 2011 10:20 AM
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
________________________________
From: Duane Hookom <duanehookom@hotmail.com>
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Sent: Friday, October 7, 2011 10:09 AM
Subject: RE: [MS_AccessPros] I need help understanding something....
Since the forms are "identical" you can use a single datasheet form and open it with a filter for active or a filter for sold. Most of us use code to open forms using the DoCmd.OpenForm method. The line of code that uses DoCmd.OpenForm allows us to specify a WHERE CONDITION. Let's assume 1) your form name is "frmMyForm"2) you have a [Status] field with values of either "Active" or "Retired" Your code to open with active records might look like: DoCmd.OpenForm "frmMyForm", acFormDS, , "[Status]='Active'"to open to the Retired records: DoCmd.OpenForm "frmMyForm", acFormDS, , "[Status]='Retired'" Typically we might grab the "Active" or "Retired" value from a combo box or other control on the form that has the code to open frmMyForm. Duane HookomMS Access MVP To: MS_Access_Professionals@yahoogroups.com
From: cc0623@yahoo.com
Date: Fri, 7 Oct 2011 15:27:13 +0000
Subject: [MS_AccessPros] I need help understanding something....
If all my records were in one table could I make two identical datasheet forms from that table and in one datasheet a person could see all the active assets and in the other sheet all the sold assets?
I am having a real problem explaining to my boss we should just keep all the records in one table and then she could use either form to see "active assets" and "retired assets". The control from one datasheeet form to the other would be a checkbox titled sold.
Thanks,
Tiffany
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar