Recent content by Ahmed73

ok. It means Dlookup will not work on text field..right?

I have a FORM where I enter new quote number. The new quote number is text field and enters manual input. I need the form to display the “Quote Number” FIELD of the LAST RECORD in an Unbound field on the same form. The table name is “Customer RFQ Detail”. Please help.

Oh, you misunderstood my message. I am thankful for your quick and early resolution of my problem. Regards.

Hi Gentleman, You might be correct, but @arnelgp is a good and professional person, I respect him. Well, amazingly, you resolved the problem. Thankyou so much. ;):)

Hi @arnelgp can you resolve this, as you previously help me out.

Error prompt while running append query

Great Sir! I didn't notice that you have resolved the issue. I just saw your message. Thank you so much.

Hi Pat, FYI, it is my project and I am user of this db. so nobody paid for it. Well this forum is very useful and I appreciated you people to volunteer and help others. I hope once I got such knowledge I will also volunteer myself in this forum. I would like to thanks @arnelgp who resolved my...

1. noted. 2. Yes you are right but I am not good in designing and coding, so made the work around to get the desired results irrespective it is professional or not. For the time being, i'll apprecaite, if you could make some changes in attached db to get the converted value in report. Thanks.

Now I attached herewith db. In supplier PO form, I am entering the conversion but it is not saving in table. I highlighted the fields in supplier PO form and in report as "YELLOW".

Yes, I converted the amount on supplier order form but that textbox I want to populate on this report. When I used =[Forms]![SUPPLIER PO]![SupPOValGBP] on report textbox it giving error #Name

Thanks. It means you used one currency table for both Sales and Purchase, whereas, I was using two different records. Please also mention how to get a textbox data in this report from a Form. This is because you see the Sales and Purchase currencies are different so simple subtracting purchase...

currency from currency table joining with Customer RFQ is appearing but another currency "PO Currency" from Supplier RFQ is not appearing on report.

I got the result as shown in the report but it was work around and not professionally. What I want: 1. based on table, report query could be improved 2. currency name shown in report on sales side but on purchase side it is showing currency ID and not currency name. 3. how I can show a textbox...