Solved

Access One Time Field Entry

Posted on 2009-07-07
7
166 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 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

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

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
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…
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 …

691 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