I am a every 6-8 month Access novice. I have a database that I share with a handful of others that I'd like to be more "user freindly".
There is a tab control that has four tabs. When a user moves to a different record, I'd like for the tabs to show the Check Box picture with the tab name...
I want to have Access generate a number that includes: a) an Acquisition Number, provided by the parent form; and b) a sequence of numbers for Conditions – 01, 02…, 11, 12, etc.. The number, to reside in a subform, will look like “9147.01” where 9147 is the Acquisition Number and .01 is the...
:confused: DMax is returning an "#Error" as I try to use it to find the largest "Acqusition Number" in the table "ACQ FY08":
In the text box "Acquisition Number", on the data tab under Default Value I've entered --
=DMax("Acquistion Number","ACQ FY08")+1
I am also getting an Access error...