Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 290
  • Last Modified:

Can I export a certain record into a seperate table

Hello Experts,

I have a A 2003 .mdb and was curious if I could export or save a forms data to another table/form.

Let's say I had a form full of values that I no I would need to use at later time. Is it possible to save a forms data into a different table so only the Important data would be in the table called Important.

Every record can be viewed in the existing form called Costs, but I would like to save certain records to another form/table called Important.

Thanks,
patentinv
0
patentinv
Asked:
patentinv
  • 6
  • 5
  • 2
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
yes you can, by using vba codes.

dim rs as dao.recordset
set rs=currentdb.openrecordset("Important")
rs.addnew
   !field1=me.text1
   !field2=me.text2


rs.update
0
 
patentinvAuthor Commented:
Hello Capricorn1,

So can this code be ran on a command buttons on click procedure, and will it be able to save the record that the form is currently in, to a different table?

Thanks,
patentinv
0
 
Rey Obrero (Capricorn1)Commented:
yes, use the click event of a command button
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Or you could add another field to the table where you could set a record to be "Important" - a yes/no field, for example. Storing data in two different places is generally not a good idea.
0
 
patentinvAuthor Commented:
How would I recall only the records marked "yes/important" when I needed them?

Thanks
patnetinv
0
 
Rey Obrero (Capricorn1)Commented:
you can create a query lke this

select * from table
where important=true
0
 
patentinvAuthor Commented:
select * from table <- This will need a table to be saved to correct?  If this is the case I might as well use  the command button approach and save it now to a table then there will be no need to run a query later to save it.

Hope I'm seeing this correctly.

Thanks,
patentinv
0
 
Rey Obrero (Capricorn1)Commented:
if you are asking about the comment posted by LSM,

select * from table << the "table" is the name of your current table, not the "Important" table.
0
 
patentinvAuthor Commented:
My point is the data will eventually end up being stored in two different places, sooner or later.

So I may as well store it now in a different location by using the command button approach, and then I create form bound to it, so I can view it now.

Thanks
patentinv
0
 
Rey Obrero (Capricorn1)Commented:
ok, then. use the codes i posted at http:#a35011098

0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
<My point is the data will eventually end up being stored in two different places, sooner or later.>

In most cases, that's not true. Data is generally only stored in ONE place, and is used from there. There are some legitimate reasons to break data out from tables, but in most cases those involve archiving data that will never again be in "live" use.

My point is that if you include a field in your CURRENT table where you can "flag" a record as important, you can then use a query to filter those records. capricorn has shown you how to do this by building a simple query.

All in all, you should strive to ONLY store data in a single location. There is no reason to store data in multiple locations, and in fact doing so can cause you to have troubles down the road (since you're never really sure if the data you're looking at is the "right" data or not).

0
 
patentinvAuthor Commented:
I understand my options I'll think it over and decide which will work the best for me.

Thanks for all the help!!
patentinv
0
 
patentinvAuthor Commented:
Now I can make a plan on how to make this work in my case!!

Thanks,
patentinv
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 6
  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now