Solved

Access One Time Field Entry

Posted on 2009-07-07
7
161 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
  • 6
7 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

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

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)

Question has a verified solution.

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

Suggested Solutions

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

932 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

11 Experts available now in Live!

Get 1:1 Help Now