Improve company productivity with a Business Account.Sign Up

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

Updating

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
Jass Saini
Asked:
Jass Saini
  • 7
  • 4
  • 2
  • +1
1 Solution
 
hnasrCommented:
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
 
Eric ShermanAccountant/DeveloperCommented:
...How can I just copy that one record that was updated??

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

ET
0
 
Jeffrey CoachmanMIS LiasonCommented:
^ what etsherman asked...

..in addition, it is still unclear as to why you need to "Copy" this data/record...
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
Jass SainiAuthor Commented:
Yes copy to a new table
0
 
Jeffrey CoachmanMIS LiasonCommented:
Why?
...this would be creating redundant data....
0
 
Jass SainiAuthor Commented:
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
 
Jass SainiAuthor Commented:
I can send you my DB to see what I am talking about..Can I message it to you?
0
 
Eric ShermanAccountant/DeveloperCommented:
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
 
Jass SainiAuthor Commented:
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
 
hnasrCommented:
"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
 
hnasrCommented:
You may upload a cut down version of the database if more help is needed.
0
 
Jass SainiAuthor Commented:
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
 
Jass SainiAuthor Commented:
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
 
hnasrCommented:
@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
 
Jass SainiAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 7
  • 4
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now