Recent content by Aryzona

I have a report where BWTID is grouped. I have the summary total in the footer for EMPDH (employee hours). I am trying to create a summary list of each bwtid and the total hours for that btwid. I tried this and it worked beautifully for the first one: =IIf([bwtid]=2,[Text26],0) but...

Ok .. no each project has a unique set of fields. some fields are similar .. such as location and date but other than that there are different fields... I have gotten the sub reports to work ... I had to create a form, to do the date range for all records - otherwise i found myself typing...

Each project is unique. These are work trackers. So each type of work is tracked, they all have similarities but none of them are the same field wise. They are individual tables. Subreports - I will keep working with them as they are the most plausible for my skill set.... I tried...

I have a table of employees. Each employee has records for work done in 3 different projects. I want to create a report that sorts on Employee name, then lists all the entries for project 1 , then all the entries for project 2, then all the entries for project 3. Each project is a separate...

Woot Thank you ... this last one did the trick! I did realize that the DB was storing the list id rather than the PA PE description, so when i swapped a 1 for PA and a 2 for PE it worked like a charm! =Sum([papedp]*-([papep]=2)) Thank you!!!!!

I have a similar problem. I have a field [papep] that consists of a "type" PA .. or PE then I have a field [papedp] that has a numeric value for documents processed. I need to do a total of documents processed that are PA and a separate total for documents processed that are PE. I have...

I used your suggestions, and followed the example Pat sent me as a model to get all my ducks in a row :D

I agree with doing it correctly the first time is way better than fixing mistakes! I did think this out. I did implement it to the best of my ability. I am BARELY knowledgeable of VBA - complete Novice - and while i know theoretically what i should be able to do, i have no idea how to...

Thank you. I will study this. I do have the current and before update code in the form event on the FTsubform. I do not have any code in the Host Form, just the macro on the button. This is not a USPS application. The app is being paid only in the essence that I am getting a paycheck...

I have implemented your example and it is not writing either start or stop to the table. The start time is represented in the table in a line "new" but none of the other data is written and a new id# is not assigned. I have compared your example to mine and the only difference i see is...

Agreed ... the timer is the easiest to do, but i will have 40 plus people simultaneously working this .. running the timer seems like it would create too much overhead, to do a simple task that i should be able to accomplish without overhead. On the flip side ... i did learn something new by...

I think i see .. FTe is stamped as time now when the form initially opens then re-stamped before update (which occurs at form close) to get the final entry? so I would not need to set the time start =time(now) because the dirty aspect updates it ? and then the before update - updates the...

This particular tracking system is modeled after the current tracking system - which is an excel spreadsheet each worker fills out - I am trying to streamline the process by taking out the component of entering the data off the spreadsheet into the data base by yet again another worker AND to...

Not sure i understand exactly what you are asking (form modules) but i will try to reply :D I have a main form that carries forward the pertinent info from the first record of the day - Emp Id, date. Then the detail records subform, where the individual interations occur, and then the...

I did .. i tried both before and after and i am getting the exact same behavior