Search results

  1. S

    Cumulative Sum in a Crosstab Query

    I'll get working on that. I have to "change" information due to high sensitivity. I'll have it up by tomorrow. Thank you!
  2. S

    Cumulative Sum in a Crosstab Query

    It's been a very long time since I've posted and I'm hoping for some SIMPLE answers. I am no master and I've NEVER dealt with cross tab queries or DSUM attributes. Here's there SQL: TRANSFORM Sum([QRYLSD Dock Landing Ships MRS Data Query2].[Sum Of CSMP_LEDGER_TOTAL_COST_AMT]) AS [SumOfSum...
  3. S

    Help with Checkboxes and Color Highlights

    Thank You, Thank You, Thank You! I appreciate the tips and the conditional formatting did exactly what I needed it to do! I've been a user of Access for a long time, but I have never built an access database before. It's been an interesting experience!
  4. S

    Help with Checkboxes and Color Highlights

    The naming was something Access was doing. I was using the name to be the same as the control source and when I went into VBA it converted it with all the dashes. Anyways, I renamed everything to be more fitting. I am still getting nothing. No errors and no updates. I've played with a few...
  5. S

    Help with Checkboxes and Color Highlights

    Sorry to take so long coming back. Um, I know pretty much nothing about VBA... but this is what I put in. Private Sub TD__Travel_Report_or_Travel_Expense_Reinbursement_Report__AfterUpdate() If Abs(Nz(TD__Travel_Report_or_Travel_Expense_Reinbursement_Report__, 0) +...
  6. S

    Help with Checkboxes and Color Highlights

    Hey thanks guys! I'm not at work today, but first thing Monday I will try this. Thank You!
  7. S

    Help with Checkboxes and Color Highlights

    To my understanding you can't change the background or foreground of a checkbox upon click so I need an alternative. In my form I have three check boxes, what I'd like to be able to do is if two or more boxes are checked that it will change the color of the name field to green. Is this...
  8. S

    Help with Macro Error

    I found a way to go around my problem for now, but if anyone would be so kind as to at least give me some ideas or links to look at that might have an answer to my problem that would be great. Google searching is not winning for me in this aspect. :) Thanks in advance
  9. S

    Help with Macro Error

    Help anyone??? If my post isn't understandable please let me know :)
  10. S

    Help with Macro Error

    I'm a long time user to Access but a new Builder and Coding. I've been tasked with building a database for my department for tracking our inventory. I originally took a sample template from MS Office and have customized it slowly to suite my own needs. However one stick little button is giving...
Top Bottom