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...
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!
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...
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) +...
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...
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
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...