Recent content by jermaine clarke

re: currency to numbers thnx to all. I have successfully converted currency to text.

i'm not very familiar with functions. can someone plz provide me with the steps as to how to make the function actually work. does it apply to reports?

please bear in mind too that I want to do the conversion in a report

its no use unless i'm not using it correctly. please gi me an example.

Hi all! I would just like to know if someone could help me figure out how I could translate numbers to text for a report that i would use for my cheques and payment receipts. thnx

I finally got it to work by setting the property of the value in the textbox. I would like some further help though with the run-time error 2237. I would like to use my own error message in place of the standard message which states that an item is not in the list. Please help me. Regards, Jermaine

Zinemon, You could try filtering the subform by editing your query. If you used a query to arrive at your subform, go back to the query and do the following: You must have the same control in the subform as in the main form (combobox) for it to work. In the query design view of your subform...

sub ItemID_AfterUpdate() 'combo box in main form Dim rst As DAO.Recordset Dim strSearchName As String Dim ItemID As String Set rst=me.Recordset ItemID=me.ItemID.Text strSearchName=Cstr(me![Invoice_Subform].Form![ProductID]) 'control in subform rst.FindFirst "ItemID=" & strSearchName If...

I've tried the recordset approach but it has not worked. Let me try a simpler approach to the question: I would like to use a combo box in my main form to add records in my subform.

pbaldy, I would not want my users to be tampering with any of the data that has to be set by an admin user. All I want the users to focus on is punching in digits that make up a code and then put in a qty. That's all. I have gotten some codes that has allowed automatic updates to my subform for...

pbaldy, u sound just about right. In terms of the quantity and other properties of the product, I could probably use a another form as I have with cashing out, which works very well.

maybe I'm going about it the wrong way but I have been studying other databases and I see where there is only one area where values are typed (correct or not) and then that value is logged in another area (assuming it's a subform) based on a user prompt. Basically, I do not want a user to be...

When I say "look up the values", I mean that I want the text box to find records stored in the combo box and then keep adding these records in the combo box as records in the table (subform).

Yes. The combo box works perfectly but my goal is to not use the combo box because I would not want users to focus on the table rather, the unbound text box

use unbound text box to update values of combo box in subform & add values as records I would like to use an unbound textbox in a main form to look up values in a combo box located in the subform and keep adding these values as records in the subform. Jermaine