Search results

Thanks for your advice. I'll give that a try. I have another small problem I need advice on: I have a field "AnnualLeave", long, fixed 2 dec places. When I do a division on the value, it give the wrong answer eg. AnnualLeave = 15 Dividing by 12 (AnnualLeave / 12) give the answer 1.00, not 1.25...

Greetings friends, Not sure if this is a table, query or form issue. I'm working on a system for recording employee information, leave details, etc. I need to run a monthly update to increment each employees leave balance. The two tables now in question are; Employees - relevant fields are...

Hi I am trying to make the default for all new forms Ariel 12pt. (Access 2003) I've searched on Microsoft site, which refers to the normal template. Where do I find this and how do I change and save it? Thanks

Hi I have a numeric field (long integer) in a table. I've set the format to fixed. No matter what I set the decimal places to, auto, 0 or 2, when I enter a value of 0.71, it displays as 1.00 In my form, I've also set the field property to fixed, but it displays the value as 1. Any suggestions...

Greetings to all members of this forum, from me as a new member, allanjf. I have been programming, more as a hobby than a business, since 1978, in DOS and then Clipper. I've recently started serious development in Access (Access 2003, because that's what I have). Kind regards to you all