Search results

  1. S

    Prevent Multiple instance of Access 2010 Runtime

    thanks Simon. is the code compatible with 2010 or am i doing something wrong. i am not able to make the code work. Regards.
  2. S

    Prevent Multiple instance of Access 2010 Runtime

    Thanks GinaWhipp for detailed reply. My runtime database will be used by a single user only. is it possible in that case to limit running multiple instance of ms access by single user Regards.
  3. S

    Prevent Multiple instance of Access 2010 Runtime

    In my case database is not splitted. so is it possible without splitting.
  4. S

    Prevent Multiple instance of Access 2010 Runtime

    hi all, is it possible to prevent 1- running multiple instance of MSACCESS.exe in runtime 2- running multiple instance of same database in runtime. After searching,the posts i have found seems not to work on access 2010 runtime.
  5. S

    Restrict column records based on creteria

    thanks Gina i came up with the same idea. customer id will be assigned in separate tbl to user when new customer will be added through form. Admin will be allowed by default and others user policy in separate field which admin can later change. The new sample also deals with similar idea...
  6. S

    Restrict column records based on creteria

    Gina, the linked example is good for user login security. But multiple criteria problem still remains which starts after user has logged in. In my case after user successful login (which can be using TempVar OR the above login form example), the drop down combo box in orders forms needs to be...
  7. S

    Restrict column records based on creteria

    Hi, this seem to be simple for single criteria but i am not able to do it multiple. i want to restrict user to customer list they r able to see in form combo box drop down list. users are in employee TBL employee group criteria is in tbl_Groups which contains value Admin,Read Only, manager etc...
  8. S

    Convert Named Data Macro into VBA

    Hi, all as a newbie i have to use MS access templates and modifying them accordingly. Northwind Desktop Product inventory web template is good for beginners, which i converted to local database and started to work on it. This template uses Named Data Macro which r in addition to Table...
  9. S

    Filter Subform based on textbox

    Thanks billmeye again. This will definitely do. Sure Incompatible data types are problem while filtering data. Regards.
  10. S

    Filter Subform based on textbox

    tried to use numbers using the filter instead of customer name but it was NOT quite stable. I was not aware of the the option in the picture and will be a quick alternative. But i will really appreciate an temporary order total filter with greater than like the above customer name filter.(if...
  11. S

    Filter Subform based on textbox

    just a temporary filter like the above customer name filter .
  12. S

    Filter Subform based on textbox

    I was wondering if it is possible to filter customer with order total greater than x amount (currency) in active orders forum.
  13. S

    Filter Subform based on textbox

    Thanks billmeye. Sorry for the delay. Modified your sample according to my requirements and have a working sample. Cheers:) here is modified sample.
  14. S

    Filter Subform based on textbox

    Hello everyone, I have researched but couldn't find any working filter criteria for subform criteria. i have used the code, searching the web but still no luck. I have attached the picture and sample northwind database (accdb). i just want to filter customers in Orders navigation using text...
  15. S

    Running Sum For Selected Records

    I finally got it working. Here is the sample database if anyone has similar requirements. Thanks MStef.
  16. S

    Running Sum For Selected Records

    Thanks MStef. However when applied in actual project the RuningSum goes on increasing. I used the forms different form event to make wAmount = 0 but when i click on different textbox the form gets refreshed which in turn increases the running sum. I have attached the picture.
  17. S

    Running Sum For Selected Records

    Hi, I would really appreciate some help regarding my problem. It is modified version MS Access Template Personal Account Ledger found on web. I modified further to suit my needs but now i am stuck on calculating Running sum in queries. Database is in Access 2003 format (MDB). I have attached...
  18. S

    Data Macro error ofter splitting database in Access 2010

    Yes, i agree. Also, removing Data Macros in Ms Access 2010 Templates means designing from scratch.
  19. S

    Data Macro error ofter splitting database in Access 2010

    Through Windows Terminal Server in Windows Server Editions OR Remote Desktop Connection, i was able to use the database but encountered new errors such as auto number error with two or more user (in my case).
  20. S

    Data Macro error ofter splitting database in Access 2010

    I used Nortwind 2010 template and modified to suite my requirement with the help of users on this forum. (thanks) Now, i am planning to use the database as multiuser by splitting database but due to data macro most of the forms do not work after splitting. There are 60+ data macro in northwind...
Top Bottom