Recent content by bibek24

  1. B

    How to use if(IFF) condition in a query

    Thanks Brian, it worked.
  2. B

    How to use if(IFF) condition in a query

    I have a query which will sum up some fields of a table based on specified date range provided by the user. My query is as follows: Select sum(field1),sum(field2) from table1 where (date1 between fromdate and todate) or (date2 between fromdate and todate). Since I have used or Keyword, if...
  3. B

    How to restrict users to open a mdb file in design mode?

    MDE file is only restricting the forms and reports.But the tables and queries can be still opened in Design mode. Is there any set up to restrict the tables and queries as well?
  4. B

    How to restrict users to open a mdb file in design mode?

    Hi Dennisk, I was aware of creating MDE file and also tried for it but it failed to create such,may be due to large size or more no. of components. Could you please provide me some high level details for the other 3 points you have mentioned?
  5. B

    How to restrict users to open a mdb file in design mode?

    Hi, We have an access application which is accessed through Citrix. After providing user id and password, if a user clicks 'OK' button of the login screen with holding 'SHIFT' key, the application opens in Design mode which is not secured. Just wanted to know is there any way to overcome...
  6. B

    passing values from one form to another form

    Hi dk, My requirements are very specific as I have explained.I cannot experiment on other things. Could you please help me as per my requirements. Thanks, Bibek
  7. B

    passing values from one form to another form

    Hi all, I have a main form frmCase which has a comment area section containing a form fsubCaseDetails which is a continious one. There is a button "Add Comments" in frmCase which on clicking should open a form frmZoom.This form has Save and Cancel button. On clicking the save button the text...
Back
Top Bottom