Recent content by sigma788

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

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.

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

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.

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

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

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

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

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

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

just a temporary filter like the above customer name filter .

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

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

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

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