Recent content by Ceriumde58

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

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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.

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...

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...