Recent content by mubi_masti

  1. M

    Display Web form

    I have created a database and successfully published on website but an alert message appears on the site "You have not created default Web Display form" I check the problem, but there is no form visible in the list provided in "options->current database->web display form. I have create a...
  2. M

    Restrict Truncation

    I am concatenating different fields by using following text. two fields are text while one is memo field. The function is working well when i use "unique records" ON but by doing this output results truncated by access. if i remove unique records then query provide whole text but it produce...
  3. M

    Open form having reference control in subform

    Thanks for your reply I have followed the same but still form for particular record is not opening. please help
  4. M

    Open form having reference control in subform

    hello everybody, can anybody help me in following problem I have two forms, main & summary Main forms contains one subform with the name subform_activity having two fields, activity_ID and activity_Date Main form contains details of all activity while summary contain short version of all...
  5. M

    Prevent Duplication Records

    :(:(:(:(:(:(:(:(:(:( is there anybody who can help me out in this situation.
  6. M

    Prevent Duplication Records

    Thanks dear Hartman for your reply I have not uploaded my database on any SharePoint yet, currently i m running it in JET/ACE environment. I have linked both tables with numeric fields and there is no possibility that i get text. I have developed data macro in which i lookup record in a table...
  7. M

    Prevent Duplication Records

    I have developed a database which is competible for web. In this database, i have many tables but i m just sharing the common problem facing with other tables as well For example Table A (master tbl) and Table B (Details tbl) are linked with 1 to many relationship through lookup wizard...
  8. M

    relationship and macro

    I have a database in access 2010 format and want to publish on web but after checking the competitablity, there are errors about index and relationships. The issues related to index have been solved but i an not able to solve the issue of relationship. How relationship can be created...
  9. M

    Creating Function to refer control in Subform

    I am also trying the same through after update event of a control available in subform1. Private Sub Act_date_AfterUpdate() Me.Parent.Subform_MDB.Form!MDB.enabled = true Me.Parent.Subform_MDB.Form!MDB.locked = false Me.Parent.Subform_MDB.Form!MDB.Value = 0...
  10. M

    Creating Function to refer control in Subform

    I have a main form which contains two subforms;subform1 and subform1 and a button btn subform2 also contains a subsubform. i want to develop a function which will be called through a button btn available in main form through this function i want to pass values to first the controls of...
  11. M

    Trim function is not working

    thans a lot i have done this in excel and able to exclude non printing characters but i have no knowledge wchich can be used to know this kind of spaces, with the help of ASC i am able to what i want to do thanks a lot
  12. M

    Trim function is not working

    i m tranferring data in bulk form excel after transfering the name field of the table shows spaces and i am using trim function but not getting result, a have a lot of techniques but not able to get results can any one highlight and solve my problem
  13. M

    Transfer data Query

    Hello Can any one help me in developing a query I have three tables, tblA, tblB, tblC Tbl A has two fields, std and camp While tbl B also has same to field ( it is temporary table) tblC has one field camp tbl A and and tbl C are linked with 1 to many relationship I want to transfer data...
  14. M

    Count total records of a query

    thanks i have usd dcount function and it works fine in function previously i have used this in button event and got error that's why i have tried this function thanks for your reply
  15. M

    formatting crosstab query in a form

    because the formatting of query are not proper, i want to hide navigation buttons, text alignment are not proper, text formatting is different from rest of format of form
Top Bottom