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.

Thanks for your input. This is the code I was looking for: "1/1/" & [Forms]![BankTransactions ]![ComboYear]. This returns all records with a date of 1/1/2025.

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...

thanks for the suggestion

thanks for the suggestion

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...

thank you, my friend - that did it

Thanks for the help, but in the db you edited for me all of the records highlight in yellow, not just the row that is selected.

I attached the database - it is in the zip file ScreenFlicker.zip in my original post

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...

Great idea - thanks again for the input

Thanks for the input. The issue is that some users leave the db open after hours which restricts me from being able to update the tables if needed at night when I do Maintenace and updates to the backend.

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...