Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-24-2018, 12:39 AM   #1
Elie00
Newly Registered User
 
Join Date: Jul 2008
Location: Beirut
Posts: 21
Thanks: 7
Thanked 0 Times in 0 Posts
Elie00 is on a distinguished road
appending a single entry

Hello everyone,

The database i'm creating is for my sent and received quotations sent (me being the middle man).

I created all the tables and forms I need for this, I would like to add an append query that would let me add a single entry from the "Quotation Requests Received" table to the "jobs" table, the append query would add all the table to the other, while i want it to add a single entry.

I understand it should be a button with an on click event procedure.

Bottom line, i want a a query that would let me add a single entry from one table to another :P

Elie00 is offline   Reply With Quote
Old 09-24-2018, 01:24 AM   #2
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 5,696
Thanks: 138
Thanked 1,532 Times in 1,504 Posts
Minty has a spectacular aura about Minty has a spectacular aura about Minty has a spectacular aura about
Re: appending a single entry

This sounds very inefficient, you shouldn't duplicate entire data sets in this way.

Why not have a status field in your data to indicate Sent, Received, then maybe a DateAgreed ? Then you only need to store the data once and can run queries on one table to get most of your results.
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

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.
Minty is offline   Reply With Quote
Old 09-24-2018, 01:24 AM   #3
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,847
Thanks: 55
Thanked 2,183 Times in 2,094 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: appending a single entry

instead of adding to another table why not add another field for quotation status or some sort.

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 09-24-2018, 01:35 AM   #4
Elie00
Newly Registered User
 
Join Date: Jul 2008
Location: Beirut
Posts: 21
Thanks: 7
Thanked 0 Times in 0 Posts
Elie00 is on a distinguished road
Re: appending a single entry

Hey Minty,

I do not wish to duplicate the entire data set, just the ones that were accepted.
I want them separate and accepted quotes to be moved to the table "Jobs" since there will be another set of fields needed in the "jobs" table.

In any case, if it's difficult i will add a field for accepted or not and get it done.

Quote:
Originally Posted by Minty View Post
This sounds very inefficient, you shouldn't duplicate entire data sets in this way.

Why not have a status field in your data to indicate Sent, Received, then maybe a DateAgreed ? Then you only need to store the data once and can run queries on one table to get most of your results.
Elie00 is offline   Reply With Quote
Old 09-24-2018, 01:43 AM   #5
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 5,696
Thanks: 138
Thanked 1,532 Times in 1,504 Posts
Minty has a spectacular aura about Minty has a spectacular aura about Minty has a spectacular aura about
Re: appending a single entry

If you must have a seperate table for the job details, then simply create a new record and save the quote ID in to it and you can then link the quote data to the job data, without having to copy it over.

Assuming you have unique QuoteID, a simple append query will do this. Create a new query, call it something like qryNewJob. In the query you can reference the form that the button is on using the syntax

Forms!YourFormName!YourControlName

Where the control with the quoteID would be used to populate the value of the new JobRecord. Add a button to the form to run the query.
Have a play with it and if you can't get it to work post back with your code, and any errors you get.

__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

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.
Minty is offline   Reply With Quote
The Following User Says Thank You to Minty For This Useful Post:
Elie00 (09-24-2018)
Reply

Tags
append , form , query

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Single form entry to report preview James_deville Forms 5 05-28-2015 06:23 AM
Single record data entry w0od0o Forms 7 01-16-2009 05:28 AM
Single entry for two tables? soojosie Tables 2 07-13-2003 02:00 AM
Appending single record data Sam Summers Queries 2 02-26-2003 12:07 PM
creating single entry tables bink_m Tables 2 01-02-2003 03:23 AM




All times are GMT -8. The time now is 11:57 PM.


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

Sponsored Links

How to advertise

Media Kit


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