Solved

Updating

Posted on 2015-01-07
15
120 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
  • 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

815 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now