Search results

Hi Sir..... I have a form called FrmMain which get loaded after Login by the User --- (from FrmLogin, Using USEID and the Password) The FrmMain displays the details of the User on Login like name, ID and Address (Through unbound control boxes) I have access the Values of the variable from the...

Hi Sir I have have a table BOOK and the Loan Table as LOAN, In the issue form while selecting the BookID (Primary Key) In the issue book form, I want the Combobox to display only those books which are avail;able in the Shelves. i.e Books that are issued and not returned.

Is there any way to align (justified equally) the text in the text box like we do do in Ms word ?

Thank you sir ... Always for your prompt Reply I got it .... Closed Button was set to Default...

hi

thanks

Thanks you sir,,,,, Its working One More Help Required I am accessing the Title of the Book through the combo Box, name COMT through a query, but it displyas all the books of same name even they have diferent BOOK ID, I have applied Distinct clause but does not work.... Is there any way to list...

it does not work

Thanks you sir,,,,, Its working One More Help Required I am accessing the Title of the Book through the combo Box, name COMT through a query, but it displyas all the books of same name even they have diferent BOOK ID, I have applied Distinct clause but does not work.... Is there any way to list...

Thanks you sir,,,,, Its working One More Help Required I am accessing the Title of the Book through the combo Box, name COMT through a query, but it displyas all the books of same name even they have diferent BOOK ID, I have applied Distinct clause but does not work.... Is there any way to list...

hi i am using the Codes below bot result is Zero Actually I want the user to get the number of Books available in the Library with the same title when select a particular book from the ComboBox "COMT" Val = DCount("[Title]", "[BOOK]", "[Title] = " & "'" & Forms!FrmBook!COMT & "'")

THnaks for yr concern

Yah... Probably dut to that Noe I have Changed to DAO its working fine..... Thanks Actualy I dont know much difference about both.... but now i think DAO is better Thanks any way

Hi.... I have the Code in the After update event in the but getting error:--- Codes are :- Code Tags Added by UG Please use Code Tags when posting VBA Code Please read this for further information:-...

T Thank you so much;;;;; its working fine I am really happy to be the member of This gruop Thanks DBG

datatype mismatch error is coming

Txtissued.Value= DCount ("[LOAN_ID]", "[LOAN]", [Member_FK] = "Forms!FrmLoan!Member_FK" & " AND (Date_Returned) is Null") can any one explain

Hi I am using the codes below in the criteria:- data mismatch error coming (Member_fk) field is string and in on eit is numbr stLinkCriteria = "[MEMBER_FK] = " & NewID & " AND [Date_Returned] IS NULL" T = DCount("[LOAN_ID]", "[LOAN]", stLinkCriteria)

THANKS ITS WRKING FINE CAN IT BE USED WITH DCOUNT ALSO DCount("*", "LOAN", "isnull(Date_Returned)") & "AND '[MEMBER_FK]=FORMS![FRMLOAN]!MEMBER_FK]" '")

Hi friends the following codes works fine to find the record (duplicate) but I want to display the message if the Date of Returned is Null (Filed= date_returned) How to do that , I tried with the code (stLinkCriteria = "[BOOK_FK] = " & NewID and isnull (Date_returned) in a different way but...