I have a form (form #1), which contains a field named txtGrowDaysCalc.
And in that form I have a subform named subfrmReady. When Form #1 opens and if the field txtGrowDaysCalchas no data in it then I want a message box to appear before the user can enter data in the subform.
Here is my onopen event of the subform which isn't working.
If IsNull(Forms!frmPlanted.txtGrowDaysCalc) Then
MsgBox "You must select a Grow Days checkbox."
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder.
But why not let Windows retr…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…