Recent content by wkosr46

Thanks. I received three suggestions and plan to try them all out. Under a little bit of time pressure I went with this one because it seemed to be the simplest. It worked after I added () after Date. "DateSerial(Year(Date(),1,1)" I had to be away all day and was so pleasantly surprised to...

I'm trying to set up a budgeting worksheet looking at both Trailing 12 data and Current Year to Date Info. I want it to work for any year in which the routine is activated from an access form which supplies the Current Year to Date as chosen by user. I'm working in Access 2013. The code...

Thank you. I did not realize that I needed to use quotes when I was entering a field name in brackets. That solved the problem, using DMAX() to set the default value of the text box. Greatly appreciated.

I am using two tables linked to a form to keep track of repeated accounting operations which must be done each month. After finishing a particular month (usually about 5 or 6 days into the following month, I add the required control records for the active month designated as "yyyy-mm". I want...

I'm a semi-experienced user. In the past, I did database work with a versions of Basic. QuickBasic and Basis. For the last 15 years, Ive only done quick and dirty stuff in Access, sometimes using VBA with DoCmd.RunSql to get stuff done without a lot of time invested.