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
Solved

Access One Time Field Entry

Posted on 2009-07-07
7
163 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

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

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

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

'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 …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

838 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