Recent content by chriss_ko

Thank you very much it has worked. :)

Please i need help, I have my database, and the is two columns one has last renewal date and the other has expiry date, i want to make another column that will either display Active or Deactive user by looking at the expiry date column. on that column i want when the column (expiry _date) is...

Thank you a lot it has worked, I appreciate.

i mean it should not be greater than Product_Qty i.e Sales_Qty to be less than Product_Qty

Help me with this plzz... I have a query called "Stock" containing field like (Item, Description, product_qty) another is a table called "Sales" with fields like (Sales_ID, Item, Sales_description, sales_Qty, date_Of_Sale) Item field on sales is a foreign key. Now what i want is how can i make...

I have a form that i use to enter record to a table but the problem is i want when you first open the form to display area to enter new record without you clicking the button to add new record. help plzz..

I saved my database as ACCDE file which is executable now the problem i am facing is i can't edit my database since i can not view it into design view How can i change it to its normal file format plzz. ????

It has worked, Thank you a lot pr2-eugin i truly appreciate for your support, ASANTE SANA (Swahili)

I have a table called employee with several records, how can i make a form that when you enter a name it displays you the whole details of that employee which are in the table of employee? The details should be displayed in the same form using text boxes or cbo. is it possible? Help me out.

I am making a database of stock control that has three tables; Sales, Product and purchases. everything is going well but may you help me with this..... May you support me on how can i make a sales form that has fields like sales_ID, Item, qty, Price_@ and total. note Total is a calculated...

Thank you very much, it has worked. Asante Sana (Swahili).

Sorry, What is that? is it a program? how do i get it? if i remove this two line it work but it does not remove the password nor closing the form. also it does not close the application after the user enters wrong password more than 3 times. help me how to correct these codes. " DoCmd.Close...

It brings me this error, "Compile error Method or data member not found" then it high lights ."closeform"

Thanks a lot, it has worked perfectly. But i want it to clear the password after it has login/ open the required form because the password still remains there and if another user clicks login he can enter through you account. therefore i want it to clear the password in the text box just after...

Thanks very much, it has worked correctly, thanks again. Asante sana (Swahili) Is it possible to display a msg when a user didn't write the user name to display a msg saying ENTER USER NAME and when he forgets to write password to say write password and when its wrong password to say...