thanks for the rep.
but i already have the log in form.
what i wanted to change is the default bypass key.
can you please give me codes to change the bypass key or changing the set up to access the bypasskey.
thanks
ive tried few codes on net but im not lucky to make it work ive searched in this forum but still not lucky.
what i wanted to do is to change the bypass key to different key or give me an option to input password before the bypass key to work
or any suggestion that will make my access secure ...
this solves my problem
= Sum([thefieldname])
it is now appreaing in my form
thanks for the repz.
but i have a new problem. i use this same procedure in report
but it doesnt shows up in report view
im getting
error: #error
it wasnt showing up.
this is the icon i was talking about i use to total the row filed
in the design view query it is there but in form i dont know how will the running
total sum shows up
thanks for repz,really appreciate the help
i have a query that has a total sum , my problem is when i create form all the fields in the query is visible in the form but my total sum doesnt show up, but when i view it in query it works properly.
i dont really know what the symbol really is called i just called it total sum
, the E icon...
sorry for asking this foolish question.
can i calculate 3 fields
ex. total: [rate]*[dys] (working)
ex2. total: [rate]*[dys]-[late] (not working when one of the field(late) doesnt have value)what i want to happen is even if the late field doesnt have value i want it to still...