?
Solved

Access One Time Field Entry

Posted on 2009-07-07
7
Medium Priority
?
167 Views
Last Modified: 2013-11-28
In the attached db, please open form "Start Up" Select "Elaine C" as the Analyst and "3" as Billing_ID. Then click on the button "Open Audit Entry."

The first tab in "Audit Entry" has the field [Audit_Start]. Please offer how I may enter the [Audit_Start] once, but then it is populated for all corresponding 10 rows for that Analyst and Billing_ID combination?

Thanks.
Start-Up-Form.mdb
0
Comment
Question by:tahirih
[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
  • 6
7 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 24798669
Can you tell us what you've tried to do with this so far? Do you have an code examples of the things you've tried?
0
 

Author Comment

by:tahirih
ID: 24798706
What I have deon thus far is to create a query that aggregates all the fields, create a new table, then insert this as a subform. But there must be an easier manner...just do not know how to do so. In the table resulting from the query - I had the field [Audit Start].

The downfall with this method is that I have to update the query independent of the Source table to ensure that all information is captured.

Thanks.
0
 

Author Comment

by:tahirih
ID: 24798890
I also use the DoCmd.OpenQuery once the Audit_Start is entered to update the Subform table, but this does not fill in the specific fields needed.

And yes, I am still getting caught up to speed with VBA, but unfortunately I am not learning fast enough to get my project finished. I know there are ways of doing this without the VBA, but I am trying to gain as much speed as I can with VBA...

Thanks.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:tahirih
ID: 24799020
I can manage this by creating a Subform based on a Query that aggregates the values. Please let me know if you do not have the time to assist.

Generally, I piece together code from solutions, and work with this, but in this case, have not found any close to what I am looking for.

Thanks.
0
 

Author Comment

by:tahirih
ID: 24799381
Please offer your suggestions on how to close this question.

This database is above my skills, and as much effort as I have been putting into this trying to get caught up to speed, it is just not enough. I initially thought I could manage, but I really am biting off more than I chew. I can build databases, and have just a basic knowledge of SQL and VBA, but not extensive by any means.

I have consulted with colleagues, and we are all now aware of how far my skills can contribute, and I will proceed with this database at the level that I can. Time to fold my cards.

Please confirm how we can close this question. Also, I truly thank you for all your assistance to this point - you have no idea how wonderful you have been.
0
 

Author Comment

by:tahirih
ID: 24804387
I am going to go ahead and close this and award you points. I have been biting off more than I can chew, thinking that I can gain speed quickly, but not at this speed.

I have let my colleagues know my limitations, and they are supportive.

Thanks.
0
 

Author Closing Comment

by:tahirih
ID: 31600800
Thanks.
0

Featured Post

More Than Just A Video Library

Train for your certification. Learn the latest DevOps tools. Grow your skillset to do better work.

At Linux Academy, we release new training modules every week so you'll always be up to date on the latest tech.

Question has a verified solution.

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

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…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

770 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