Recent content by Anna Anna

Hi again! I still don’t know why but all originally locked fields were unlocked and disabled buttons were enabled (only on main form). Fix was simple and quick though. Everything is working perfectly now. Thanks again for your suggestions. Anna

Hi! Thank you for your respond. Yes!!! I regret my short-cut now but it doesn't help much. I have to fix it now anyway. I will go there today to check all the settings (as you sugested) and see. Will let you know. Anna

Hi! I recently designed a database application but security offered by Access seemed to me a bit to complicated so I tried to be “smarter”. I start to regret it slowly. In properties of a main form I locked and disenabled most of fields and command buttons. I also created three buttons opening...

Hi Mile-O-Phile!!!!! I just tried it. It works just PERFECT. Thank you so much. Anna

Thanks for your quick respond. It looks good, but unfortunately I will be able to try this late tonight or tommorow. I can't wait. Thanks again and I will let you know how it works. Anna

Hi! I created ‘Sales Form’. At this moment I have Combo Box to choose ‘Product Name’ and another Combo Box to choose ‘Price’. These two Combo Boxes have two columns each showing ‘product name’ and ‘price’. To enter ‘product name’ I click first one and choose from column with ‘products name’ and...

Thanks so much! The fix was so easy. It works perfectly now. Thank you again. Now I can go to sleep in peace. Anna

Hi! Something strange is happening to my report and I am giving up. It prints extra blank page between two pages. I am using page count so on first page at page footer it says: page 1 of 2 then I am getting that extra blank page and on third page after printing usual data, at the page footer it...

Hi again! I think I figured something out but I need your opinion if it makes any sens: I created a new query based on the one that you have senn in my example but I didn't include ' End Date' field. Then I used 'count' for 'ID' field and I got right number. I am wondering if I am "celebrating"...

End Date // Full Time // ID 15/01/03// Yes// 11 16/01/03// Yes// 8 17/02/03// Yes// 3 19/02/03// Yes// 4 Hi! This is example of the result of my query. How do I calculate the number of people working Full Time? I need this number for further...

Thanks bjackson!!! I will try it in a moment. Anna

Hi! This is my query: I want to get number of graduates still operating a business of those who graduated: - less than a year ago - two years ago (entire two years from now) - three years ago (entire three years from now) etc. Would you help me to write 'criteria' in a 'Date' field to get these...

Hi jjturner! Thanks! I have already got it. I got advise to change command button deffult property to 'yes' and that works perfectly. thanks again. Anna

Jim and Rob, thank you!!!!! It works perfect. Anna

Hi! Any idea how to execute click event procedure on command button by hiting 'Enter' on a keybord instead to click on that button? Thanks for your help. Anna