Recent content by emphyda

My part of globe is Nigeria in West Africa. I am developing a retail application for retail and small size businesses. In Nigeria, our currency is Naira and Kobo. We translate numbers currency to English using "and" in this manner, 100 reads one hundred. 123 reads one hundred and twenty three...

Thanks RuralGuy but I still have problems with numbers like 1 which reads "and one", 100 reads " and one hundred .

Thanks for the responses. The solution from J draw is closer to my expectation but the "And" must come for tens and units part of the number. Using your example, SpellNumber(3007902.99) will read Three Million Seven Thousand Nine Hundred and two dollars Ninety-Nine cents. I want for example...

Sorry folks for being away this while. I came across the code below in the internet and would want to use it in my application. I do have a little challenge with it. In my part of globe, we spell numbers, for example 1001 to read "One thousand and one" Here is the code Option Explicit...

What I meant by it did not work is that I still got the error message; To make changes to this field, first save the record. The SQL for the rowsource is SELECT Sales_Details.Drg_Id FROM Sales_Details WHERE Category=Forms!Frmdetail1!CboCategory ORDER BY Drg_Id; The code beforeUpdate is...

Hi Pat, I substituted your suggestion in the rowsource of the second combo box and removed all the codes except Me.CboDrug.Requery, It did not work. Could you please explain to me, what record does it want saved before accepting changes? Let me give you an insight of what I am doing. I am...

Hi all, I need someone to help. I have an input sub form from a query drawn from two tables. I also have two bound combo boxes; the first filters for the second. The AfterUpdate Event in the first combo box is Private Sub CboCategory_AfterUpdate() ' Update the row source of the cboDrug combo...

I am updating the available Qty. My datasheet sub form has many line of drugs purchased with just one invoice. Presently, I was able to put up a query that updates each line. What I want is if I have say 10 lines at a time, I want to update them once.

Hi all, I am trying to build a sales invoice for a pharmacy that contains a sub form in a datasheet view. The main form contains only the invoice number and date while the sub form contains the drug code, drug name, Qty., Available Qty. and Updated Qty. Presently, I can only code the update to...

The relationship between the tables are Customer(one) to Invoice(many), Invoice(one) to Line Item(many) and Drugs Details(one) to Invoice(many). I suppose I am right here. My project is in two; wholesales and retail sales. The wholesales will involve the customer table while the retail sales...

Hi all, I am a newbie, I would very much appreciate who can give me steps involved in creating a sales invoice for a pharmacy shop with four main tables, namely, the customer table, the invoice table, the line item table and the drug detail table. Thanks. Emphyda

Just want to know about Ms Access.