Search results

  1. 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.
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. S

    Northwind Table Field Rename Error

    Hi, i am incorporating inventory tracking in Northwind 2010 Template using a sample provided on this forum. Northwind 2010 stores Quantity Purchased in [PurchaseOrderDetails Table in field name Quantity] And Stores Quantity Sold in [OrderDetails Table in field name Quantity] Same field name...
  8. S

    send sms through Ms access vba

    just wanted a simple sms sending feature on a Access form using VBA using attached USB GSM Dondgle. googled out and found something relevent but NONE seem to work. http://www.andreavb.com/forum/viewtopic_5824.html http://www.java-samples.com/showtutorial.php?tutorialid=1131 it would be...
  9. S

    Convert Access web database template into a desktop database

    is there any way of converting Access 2010 web database template into a desktop database. i tried Northwind 2010 web database template and after converting into accdb the form and reports cannot be edited in design view( there is no design view option). such forms and reports cannot be exported...
  10. S

    Display Subform Record sum on main form

    Hi all, I have applied different methods to show subform sum on main form. but it gives me an error. either i am doing something wrong or my access version 2003 is creating problem. i have attached the database. Many thanks for all any help,
  11. S

    query ignores form record if related subform has no record

    hi everyone. currently i am facing a problem and would appreciate some assistance. the situation is that i have a main form , a sub form and a print button at bottom. the print button print the related record based on query with a filter. the problem arises when the sub form does not have...
Top Bottom