Search results

Not sure what I'm doing wrong, but when I use a simple Sum([fields]) on my report it runs #Error. I have included the database and a screen shot of the issue.

Need a little help. I have a form named BankTransactions that has a field named ComboYear. ComboYear stores the year the user enters (such as 2025). I am trying to build a query that strings together the date range "1/1" and then adds in the year from ComboYear from the form BankTransactions...

Given a table field that has the value "R914", how might I go about generating the next numerical value "R915" in either vba code or a query? Thanks for the help in advance.

I am using the “DoCmd.RunCommand acCmdAppMinimize” code on a form button to minimize msaccess down to the taskbar, which works great. However, when there are two or more forms open, with one of them having the focus, when the user reopens msaccess from the taskbar, it does not always return...

Need a little help from the experts. I’m trying to find a good way to highlight the entire row (on a form) when the user clicks on the record. Currently I am using conditional formatting on each of the fields/controls on the form. The expression is: [ID]=[txtSelectedRecord] which turns each of...

Trying to find a good solution that will force my frontend to quit (exit without warning) if the frontend has been idle for 60 minutes. The tables are stored in a separate backend database and linked to the frontend. Any suggestions or sample databases are much appreciated.

Trying to figure out why I keep getting an error “Record Too Large” when trying to enter data into one of the empty fields in the table "CemeteryPlots". I have rebuilt the table, compressed the table, and looked for any special characters in the existing fields. Any help would be much...