Recent content by Anis

Can any one help me on my request

Thank you Pat Hartman, hereby I am attaching my database for your reference. hope this will help to get more advise from you

Thank You Ranman i Had tried but end with below error "microsoft access set 0 fields to null due to a type conversion failure"

Good Day to All, I am very new Access. Sorry my English was not good. I Have two Parent table with child table, for Quotation and Invoicing, as shown below. Once our quote is approved we need to convert the quote for certain line items as invoice. For this I need to select some line items in...

But before starting the second record set I had assigned cntr1 as 0. Even I Try the same with diffrent cntr2 also. But it shows the same result. Thank you.

Thank you, but it was working fine for condition room=1. when it goes to second while room=2 it just skip cntr1=0 and execute only cntr1=1

Hello Friends, here I am trying to have multiple record set or same table, since I want to check all the record in the table with some conditions. It is basically for meeting room booking management. I want to check the status of room availability, booked or overbooked in screen. Booked is my...

Yes this is in standard module.

i am using belwo code and save it as " ConvertCurrencyToEnglish " " Function ConvertCurrencyToEnglish(ByVal MyNumber) Dim Temp Dim Pounds, Pence Dim DecimalPlace, count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion " Place(5) = " Trillion " '...

Hi, i am sorry, i new to access can you elaborate what is procedure and where is it. so i can try to change the name.

Hi, I am using the same code in module when i call the function in form i am getting error in my text box. #Name?