Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-13-2019, 07:50 AM   #1
Nastaran
Newly Registered User
 
Join Date: Jun 2019
Posts: 7
Thanks: 1
Thanked 0 Times in 0 Posts
Nastaran is on a distinguished road
temporary table of SOME records

hey guys,


can you tell me how to select some, but not all of the records [of forms] and save them in another temporary table?

tnx.

Nastaran is offline   Reply With Quote
Old 06-13-2019, 08:07 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,947
Thanks: 57
Thanked 1,297 Times in 1,278 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: temporary table of SOME records

Hi. What do you mean by selecting records from a form? How exactly would you select each one? If you want to select records from a table, you can use a query with a criteria. You can then convert this select query into a make-table query.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 06-13-2019, 08:19 AM   #3
Nastaran
Newly Registered User
 
Join Date: Jun 2019
Posts: 7
Thanks: 1
Thanked 0 Times in 0 Posts
Nastaran is on a distinguished road
Re: temporary table of SOME records

I have a form that has some records and my users should choose just one record, and when my user select this record, this record add to another form.

Actually, I want to make "add cart" in Access.

TNX

Nastaran is offline   Reply With Quote
Old 06-13-2019, 08:26 AM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,947
Thanks: 57
Thanked 1,297 Times in 1,278 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: temporary table of SOME records

Quote:
Originally Posted by Nastaran View Post
I have a form that has some records and my users should choose just one record, and when my user select this record, this record add to another form.

Actually, I want to make "add cart" in Access.

TNX
Hi. You don't add records to a form. You add them to a table. To add records to a table, you can use an APPEND query. So, in your "Add to Cart" button, you could execute the APPEND query.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 06-13-2019, 08:28 AM   #5
bastanu
Registered User
 
Join Date: Apr 2010
Location: Kelowna, Canada
Posts: 242
Thanks: 1
Thanked 69 Times in 67 Posts
bastanu is on a distinguished road
Re: temporary table of SOME records

Usually you do that by having a boolean field in the table named IsSelected or something similar then you use that ([IsSelected]=True) in a query used to populate your cart, This allows for multiple selection as well.

Cheers,
Vlad
bastanu is offline   Reply With Quote
Old 06-13-2019, 08:59 AM   #6
Nastaran
Newly Registered User
 
Join Date: Jun 2019
Posts: 7
Thanks: 1
Thanked 0 Times in 0 Posts
Nastaran is on a distinguished road
Re: temporary table of SOME records

Hi
my form is result of another query and table and I want to select one of this result and add it to my "add cart", I know that this result should save to another table, but I don't know How, and Unfortunately I don't know How can I use append query.
tnx
Nastaran is offline   Reply With Quote
Old 06-13-2019, 09:14 AM   #7
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,947
Thanks: 57
Thanked 1,297 Times in 1,278 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: temporary table of SOME records

Quote:
Originally Posted by Nastaran View Post
Hi
my form is result of another query and table and I want to select one of this result and add it to my "add cart", I know that this result should save to another table, but I don't know How, and Unfortunately I don't know How can I use append query.
tnx
Hi. See if this article helps.


__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
Nastaran (06-13-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
query for Inserting random records into temporary table BennyLinton Queries 2 07-16-2015 04:39 PM
Building a temporary table using records in two different tables. LadyMarmalade Modules & VBA 5 09-23-2014 07:04 AM
Help with Creating and Using Temporary Recordset to Delete Unwanted Records psimpson Modules & VBA 6 04-19-2012 12:45 PM
Append - data from temporary table to main table Morten Queries 6 03-16-2010 07:05 AM
[SOLVED] Temporary Table gupta_rahul Tables 0 07-29-2002 06:23 AM




All times are GMT -8. The time now is 12:03 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World