I ended up using this code in the onload event to get around the problem of resizing in 2007
'Manually Move and Size Your Form
'1440 = 1 in.
'Order is left,top,wide,tall
DoCmd.MoveSize 1440, .5*1440, 8 * 1440, 5.75 * 1440
My Form example is
1 in from left, 1/2 in from top, 8 in wide, 5.75 in...
if you are updating an entire table to a calculated field you would use an update query
create new query
pick the table you are updating
change the query type to update query
drag the "Year + 7" field you want to update to the query columns
in the 'update to' field put your calculation you...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.