Solved

Updating

Posted on 2015-01-07
15
124 Views
Last Modified: 2015-01-07
Hello,

If my form is based off a table ..and I am only pulling in certain records on the form based off the query...How can I just copy that one record that was updated??
0
Comment
Question by:Jass Saini
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
  • 2
  • +1
15 Comments
 
LVL 30

Accepted Solution

by:
hnasr earned 500 total points
ID: 40536465
Form displays few records.
You display record with id: x
Record updated.

In form after update:

QueryUpdated.SQL = "Select * from tbl where [id] ='" & Me!x & "'"
DoCmd.OpenQuery "QueryUpdated"
0
 
LVL 19

Expert Comment

by:Eric Sherman
ID: 40536480
...How can I just copy that one record that was updated??

Copy the one record where???  To a new table???

ET
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40536541
^ what etsherman asked...

..in addition, it is still unclear as to why you need to "Copy" this data/record...
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

Author Comment

by:Jass Saini
ID: 40536580
Yes copy to a new table
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40536586
Why?
...this would be creating redundant data....
0
 

Author Comment

by:Jass Saini
ID: 40536608
My boss changed the structure of my table but she wants me to keep the structure of my form (based off the orginial table)...
0
 

Author Comment

by:Jass Saini
ID: 40536610
I can send you my DB to see what I am talking about..Can I message it to you?
0
 
LVL 19

Expert Comment

by:Eric Sherman
ID: 40536621
Still not clear as to what it is you are trying to accomplish.  

Copy a record to a new table based on what event???  What fields you want to copy???  You are referring to fields where some are on a main form and some are on a subform.  You have to be more specific in describing your question.

ET
0
 

Author Comment

by:Jass Saini
ID: 40536675
what difference does it make what fields I am trying to copy.  I would just like to know is that appropriate to do or is that something that is limited by access???  When I do the duplicate record command button and I use this button on the subform..it will only copy the fields that are on the sub form...I am trying to figure out how to copy "ORG Name" field and FUND field which is on my main form too
0
 
LVL 30

Expert Comment

by:hnasr
ID: 40536685
"changed the structure of my table but ... keep the structure of my form "

Bear in mind, the appearance of the form is a user's liking, but form's operation is your job.

Use the new table structure, and base the form on a query of the new table adding the relevant alias names.
0
 
LVL 30

Expert Comment

by:hnasr
ID: 40536689
You may upload a cut down version of the database if more help is needed.
0
 

Author Comment

by:Jass Saini
ID: 40536705
hnasr..My boss made the table where the field data was..ie...communication, printing, salaries...into heading.  But she still wants that data showing up vertically...I guess I am too new and I don't see how that is possible.  She perform a crosstab query on my table and wanted that to be made into new table (less records storage).

So instead of being a field and everything was vertical..she changed them into headings.

I am having a problem visualizating how from the form which the user info goes into my orginal...how to copy that info (record into the new table)
0
 

Author Comment

by:Jass Saini
ID: 40536724
Here is my database...Final_Table is my orginal table ...Final_frm is my form (based off Final_Table) .  Final_table_Crosstab is my new table.  Thank you for your help.  It took me about six months to get to this point and then the table was changed on me
Database13.accdb
0
 
LVL 30

Expert Comment

by:hnasr
ID: 40536900
@JAss Saini

Looked at the two tables.
Here is a few points to raise with your boss.

The original table is needed for data entry, and it should follow what is called a normalized table.
Crosstab is a type of query which summarizes data from a table. It is sort of reporting action.
The original table enters itemized data.
The crosstab totals data per group of categories.

The query is seen by access as a table and as such you may not have the same name for both a table and a query in the same database.

You may have x table, x report, x module, and x table but no x query.

Show her the result of the crosstab query whenever you modify the original table.

It looks like a table, viewed, used as a source in a report.

You may use it in a form for inquiry, but not for data entry, or you will break the purpose of using a computer. (adding values in your head, and entering the total in a crosstab)

Other thing to remember, that no calculated totals to be stored in a table. Always use queries to display totals.

One needs to prepare the work in a way to be accepted for automation. Automating a manual process as it is may end up with unmanageable database.

Last point, boss is interested in the what part of the job (displaying the results), programmer worries about how to process the data to show the result.

Wish you good luck!
0
 

Author Comment

by:Jass Saini
ID: 40536921
Hello,

Thank you...That's what I have been telling...but her boss has this vision and she to do what she can to please him.  Which is fine...but there are some thing that a new access person can not do...And you an expert have confirmed this.

In the crosstab table, she wants to be able to copy the record with the updated changes and I am not there as a programmer yet.

"You may use it in a form for inquiry, but not for data entry, or you will break the purpose of using a computer. (adding values in your head, and entering the total in a crosstab)"
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question