Search results

  1. C

    Auto-populating fields using different table

    I have been able to get the desired functionality using an Update Query in the afterupdate event. Thank you for the assistance.
  2. C

    Auto-populating fields using different table

    The database is designed so that there is very little redundant data, but I realize it sounds like I am storing the same info twice (which I may be). I will try to explain the differences between the two tables so that their purpose is more clear. The database is being used by construction...
  3. C

    Auto-populating fields using different table

    I really only need to save the information into one table, the daily. I'm looking for an auto-populate option to save time and reduce human error (i.e. The person filling out the report wont put in a value lower than the overall progress on a given activity) Will creating a query that joins...
  4. C

    Auto-populating fields using different table

    Hello Everyone, I have been working on a form that field employees have been completing on a daily basis. As part of this form, employees must record their progress in different activities in the activity schedule for their Project. The vital information for the Activity Schedule is stored on...
  5. C

    Updated Multiple Tables with Data entered on a Form

    Ok so its getting close to working except for two things, using the example statement you pasted before, I built the query below: UPDATE tblActivitySchedule SET [%Complete] = ![Forms]![sbfrmDailyActivitySchedule]![ActivityDailyCompletion%] WHERE...
  6. C

    Updated Multiple Tables with Data entered on a Form

    The Daily Activity Schedule is a continuous subform, and when it is filled in on the form it will actually add a new row to the "Daily Activity" table. In addition to that, I would like to update the Completion% field on the "Master Activity Schedule" table. Initially I had tried to use an...
  7. C

    Updated Multiple Tables with Data entered on a Form

    I have a Form which my end users fill out on a daily basis, we use it to track the progress of various activities on their given project. As part of the daily form, end users must put a daily completion percentage for the given activity. I would like update an additional table with some of that...
  8. C

    Automatically generate content on Continuous Forms

    Then that's what I will do, thanks for all your help
  9. C

    Automatically generate content on Continuous Forms

    Not quite, The button appears to add all of the items from the Activity Schedule table. I would only like to show items in the activity schedule that are scheduled on the "Daily Form Date" So in this example, if the "daily form date" is set to 11/20/2012, only SAMP8888 and SAMP9999 should...
  10. C

    Automatically generate content on Continuous Forms

    I'm not sure if that solution will work for what I'm trying to do because the "Activity Schedule" and the "Daily Activity Schedule" are designed to hold different types of info. Basically the "Daily Activity Schedule" currently only uses the "Activity Number" from the "Activity Schedule" table...
  11. C

    Automatically generate content on Continuous Forms

    I am working on a Form that will be used by Construction personnel to enter Daily information about work done on their jobsite. The personnel are required to report the status of various Activities that they performed that day based on a schedule. All of the activities have been save in a...
  12. C

    Updating Multiple tables

    I have included a screenshot of my relationship chart. I figure I should take a moment to describe what my employer would like to accomplish as having a column dedicated to the last daily report date on my contracts may not be the best way to accomplish what I'd like to do. Currently the field...
  13. C

    Updating Multiple tables

    Oh geez this has gotten alot of attention. Evidently I have much to learn, time to get cracking. Thank you all for your responses, I will sift through them and try to figure out a solution to my dilemma.
  14. C

    Updating Multiple tables

    Is it possible to have a Field on a form bound to two different tables? I have a form that end users will be filling out on a daily basis. After a user inputs a date for the daily form I would like it to update the DailyFormTable as well as update a LastDailySubmitted field on another table...
  15. C

    Replacing Paper forms with Access

    The forms are supposed to be completed by the foremen onsite. As part of their daily responsibilities the foremen must record each employees daily time card which they are able to do through a program called NetExtender which gives them access to the corporate network. Which is where this DB...
  16. C

    Replacing Paper forms with Access

    Hello all, My employer(an electrical subcontractor) has been having trouble getting detailed reports from their field crew. They have given me the task of finding some kind of solution for this problem that would allow the field employees to submit their daily reports digitally. I have very...
  17. C

    New to the program

    Hello all, I happy to be a new part of this community. My experience with databases is quite limited currently and I would like to expand my abilities. I have been given some tasks that I feel Access would be the best possible solution for so I am here to try to find answers and understand...
Back
Top Bottom