Search results

Trying to build a field default value using data from a field in a different table. The deafult value contains multiple elements text ("ASFL"); then two-digit, fiscal year (12); then three digit julian date (123). I tried to use varying themes on the following to no avail: = Display Text...

Trying to build a field default value using data from a field in a different table. The deafult value contains multiple elements text ("ASFL"); then two-digit, fiscal year (12); then three digit julian date (123). I tried to use varying themes on the following to no avail: = Display Text...

I formatted my subform; yet, that formatting is missing when the subfrom appears on the main form. The subform appears in a list instead of the formatted version. Any ideas? Thanks in advance. Paul

Main Form is called frm_pickups tied to table Pickups Sub Form is called DODAAC_subform tied to table DODAAC DODAAC_subform is hidden until the user enters data in the control on the main form which doesn't exist in the table DODAAC. Private Sub DODAACCS_LostFocus() If IsNull(Me.City1) Then...

I have a main form called frm_Pickups tied to a table called Pickups and a subform called DODAAC subform tied to a table named DODAAC. On frm-Pickups, I have four fields named DODAAC1, DODAAC2, DODAAC3, and DODAAC4. What I would like is to have the DODAAC subform appear whenever the user...

Still trying to wrap my mind around the coding and was hoping you could help... The parent form (Main) is tied to a table named Main; Subform is tied to a table named DODAAC. On the parent form are 4 fields I want to use to make the subform appear any time the user enters data which isn't in...

2010 Access VBA newb on a network. I have a couple of fields that I want hidden until user checks the controlbox. Found a soultion that requires a userform. Trying to insert a userform in VBA; however, it's not available on the insert menu. Is it possible our network admin has blocked...