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...
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?
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?
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...
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
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...