Recent content by vsteinly

  1. V

    Suppress Groups in Reports

    I have a financial report that I have three levels of grouping for monthly expenses. Depending on how the transaction was created it can have some of the groups that contain no data. So here is are my groups Account - will always contain data Operating Unit - will not always contain...
  2. V

    vsteinly

    Here is a screen print of the input form in design mode. I'm going to get with my IT guys today to see how they would grab the username.
  3. V

    vsteinly

    I'm not getting anything to show up in the createdby field. I did notice two new fields that showed up on my form and wondered it there was something that I could with them. One is called System Name: and another called System Id Number:
  4. V

    vsteinly

    I see what you are talking about but for some crazy reason that field I updated. So what do you think I need to do for the username?
  5. V

    vsteinly

    I have created two tables in which I want to track who and what time data is entered and then again if the table is modified. I found this code which I added to BeforeUpdate: Private Sub Form_BeforeUpdate(Cancel As Integer) ModBy = Environ("username") ModDate = Now() End Sub Private...
  6. V

    Check boxes in reports

    Think I'm missing something?
  7. V

    Check boxes in reports

    That's looks perfect. This is just a quick fix for something that will be collected on a bigger scale once an upgrade is finished. Thanks, you have shown me something new!!!
  8. V

    Check boxes in reports

    Here is how I would want it to look.
  9. V

    Check boxes in reports

    That would be a column header "Method(s) of Customer Notification" in the report. I looking to have the fields below show in that column: Nixle Twitter Media Radio Personal Contact Phone These are setup as yes/no fields.
  10. V

    Check boxes in reports

    I might add I would like the column in the report to read "Method(s) of Customer Notification" and the data to shows as follows "Nixle, Twitter, News Media". So if more than method was used all will show. Thanks for looking at this for me.
  11. V

    Check boxes in reports

    I have a database that has a field for methods of sustomer notification. I created a form which shows the top methods within our community. Is there a way to have all of these show up as text within a report? Maybe there is a better way to set this up to begin with but I was on a short...
  12. V

    Monthly and Yearly Totals

    Yes, Yes!! That now works. Thanks. Small things sometimes get in the way of progress. Do you think I can create another query that could include employee and task. I going to try a union to see if I can get that to work. What do you think?
  13. V

    Monthly and Yearly Totals

    Look closer at the subtotals qry Pay Period linked to Current SumofHours = 1,164 SumofRate = 48,519.19 These are correct. qry Summary All AllHours = 11,635.63 AllRate = 348,648.88 These are correct. qry z Final AllHours = 116,35.63--Correct AllRate = 348,648.88--Correct CurrentHrs =...
  14. V

    Monthly and Yearly Totals

    Your queries are doing the same thing mine are. Individually they work it’s when they are combined into one query they go crazy. I have tried to change the joins and the fields that they are linked by. It just doesn’t want to work.
  15. V

    Monthly and Yearly Totals

    The pay period is a two week period. So there will be 26 in a year. I pickup the pay period in our payroll system so I don't need to worry about dates. The value has been set in the tblValues
See more
Back
Top Bottom