Recent content by Reshmi mohankumar

  1. Reshmi mohankumar

    Solved Unable to Insert/Update DB

    With this i can copy of non existance table, but non existance fields of existing table was unable to copy. Sub UpdateTableStructure() Dim sourceDB As DAO.Database Dim destDB As DAO.Database Dim tblDef As DAO.TableDef ' Set the source and destination database paths and...
  2. Reshmi mohankumar

    Solved Unable to Insert/Update DB

    It says invalid password..Thats why i removed password and tried.
  3. Reshmi mohankumar

    Solved Unable to Insert/Update DB

    Hi, I wish to update my present working securedDB with structure updated secured DB by using below code. But there is no response/ error when excutes. Even tried by removing password to DB at source. If password exists then error 3031 appearing at OpenDatabase. Any helpful suggestions will be...
  4. Reshmi mohankumar

    Solved VBA Execute

    The best option. Thanks to MVP, Leigh Purvis (LPurvis) and #theDBguy
  5. Reshmi mohankumar

    Solved VBA Execute

    VBA Execute, cannot getting data and throwing runtime error 3061 with too few parameters required. Here i am executing an SQL insert statement, getting values from another mainQuery which representation of various join queries(of 6 child queries). where as mainQuery showing the data in...
  6. Reshmi mohankumar

    Extract numbers from text

    it helped me today. thank you
  7. 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...
  8. 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...
  9. Reshmi mohankumar

    Can we build SSMS Form?

    yes , like SSMS
  10. 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...
  11. Reshmi mohankumar

    Solved Nz(string,ifnull(my string))

    finally im good. thank you bro
  12. 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
  13. Reshmi mohankumar

    Solved Nz(string,ifnull(my string))

    I dont know how to use them....Is simple inline code??
  14. 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.
  15. 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...
Top Bottom