Recent content by Reshmi mohankumar

  1. Reshmi mohankumar

    Extract numbers from text

    it helped me today. thank you
  2. Reshmi mohankumar

    Web Forms with SQL Azure back-end and Access front-end

    As like you , me also using PHP sites(im also learing) for client/customers queries. directly they can check their order status online without second sync to any other location from actual DB. Data posting in to MS access which is in intranet and a local hosted system has PHP server with ODBC...
  3. Reshmi mohankumar

    Can we build SSMS Form?

    im not getting what to do , how can we use a notepad style on form??SSMS has like that style to write queries. I wishing that same style on our access form. which will help to modify back end data easily so. Is it possible to place a notepad file on form and making controls to excute the...
  4. Reshmi mohankumar

    Can we build SSMS Form?

    yes , like SSMS
  5. Reshmi mohankumar

    Can we build SSMS Form?

    Hi Guys, Happy new year to all. Today i got an idea to Create,update or delete or insert , alter data from FE(compiled). That we can create a unbound form and making a unbound longtext box and a subform which will show what we run the code in textbox. To run a query a go command also on form...
  6. Reshmi mohankumar

    Solved Nz(string,ifnull(my string))

    finally im good. thank you bro
  7. Reshmi mohankumar

    Solved Nz(string,ifnull(my string))

    it worked...And i learnt good point i need to have strong skills ....You took me cafe to refresh...Thank you sir
  8. Reshmi mohankumar

    Solved Nz(string,ifnull(my string))

    I dont know how to use them....Is simple inline code??
  9. Reshmi mohankumar

    Solved Nz(string,ifnull(my string))

    i hope i used currentproject.path used in value if null place so. my db had only path string if which are having paths they can visible , but which are not having path i got error like above.
  10. Reshmi mohankumar

    Solved Nz(string,ifnull(my string))

    Me.simg.Picture = Nz(CurrentProject.Path & StudentPhoto, CurrentProject.Path & "\StudentImages\INDEX.JPG") Me.fimg.Picture = Nz(CurrentProject.Path & FatherPhoto, CurrentProject.Path & "\StudentImages\INDEX.JPG") But this code is under forms onCurrent event if there is a no string i got error...
  11. Reshmi mohankumar

    Solved Error '3421' , Conversion data type

    thank you bro. The DBGuy has done it.
  12. Reshmi mohankumar

    Solved Error '3421' , Conversion data type

    i finally got , but bit change in your where clause i put in to Eval('[FORMS]![Frm_SMS]![CBOCLS]') thank you so much.
  13. Reshmi mohankumar

    Solved Error '3421' , Conversion data type

    i got error 3061, 'too few parameters- Expected 1 placed at same position
  14. Reshmi mohankumar

    Solved Error '3421' , Conversion data type

    SELECT Tbl_Student.Contact1 AS smsnumber, Tbl_class.Class, Tbl_Student.Active FROM Tbl_class INNER JOIN (Tbl_active_class INNER JOIN Tbl_Student ON Tbl_active_class.StudentID = Tbl_Student.StudentID) ON Tbl_class.ClassID = Tbl_active_class.Classid WHERE...
  15. Reshmi mohankumar

    Solved Error '3421' , Conversion data type

    i checked but same thing happening
Top Bottom