I'm kinda new here, I've been getting into Access primarily for work, and have this database that I'm working to actually use as an export tool to automate some things in my department.
I work with Access 97. Anyway, I have a form popup when my "export" button is clicked (through a macro). It's modal and it contains custom "yes" and "no" buttons; "no" closes the form, and "yes" leads to another macro (to eventually export). I also have some control data on the form (I hope "control data" is the right terminology) which takes =COUNT([SSN]) and =SUM([Amount]) from a table called "Committed Data" and places it on the form. This works fine, but if there are no rows in the Committed Data table, the form popup is totally blank: no text, buttons, or labels. What could be the problem? I hope to have been thorough.
Or I could avoid this problem and check to see if there are actually any rows to begin with and if not, just give another message.
I work with Access 97. Anyway, I have a form popup when my "export" button is clicked (through a macro). It's modal and it contains custom "yes" and "no" buttons; "no" closes the form, and "yes" leads to another macro (to eventually export). I also have some control data on the form (I hope "control data" is the right terminology) which takes =COUNT([SSN]) and =SUM([Amount]) from a table called "Committed Data" and places it on the form. This works fine, but if there are no rows in the Committed Data table, the form popup is totally blank: no text, buttons, or labels. What could be the problem? I hope to have been thorough.
Or I could avoid this problem and check to see if there are actually any rows to begin with and if not, just give another message.
Last edited: