Search results

  1. K

    Cascading Combobox in Same Datasheet View/Subform

    Is there anyway that we can do cascading combobox in the same datasheet view of subform? Basically I'd like to filter "Account Name" based on "Plan#" selected in the same record of subform.
  2. K

    Get total for Datasheet Subform ---Running on Published Web Access

    I'm working on a web form (published to sharepoint) Is there anyway that I can calculate totals on Datasheet subform? On regular form, I know that we can put textbox in form footer to accomplish this. However, there's no such footer in current form.
  3. K

    Disabling SharePoint Access Setting Option for Certain user

    I just published an access database to sharepoint. However, after I set some user as contributor, those users can see structure of my database, and export tables to excel directly. Is there anyway that we can remove the access to "Setting"?
  4. K

    IIf statement in Criteria to show all

    I'm working on a published sharepoint web access database, writing a criteria expression in data source of a combo box. The field I'm setting criteria is called SharePointAuthor. I wrote this critea: IIf(CurrentWebUser(1)="John Doe","*",CurrentWebUser(1)) Trying to show all records when...
  5. K

    Display Sharepoint User Name in Textbox

    My access tables are stored in sharepoint. (as lists) And currently I'm using desktop version access 2010 as User Interface. I coded the database the way that everytime user open it, it prompt the user to input sharepoint login and password. Problem: How could I display logged in sharepoint...
  6. K

    Display Inventory level when working with order detail subform??

    hi experts, great to have such a nice place as mrexcel. i'm working on a subform of a order form. the main form, order form, obviously consists order info such as customer, date, etc. the subform consists product name, price, qty and stuff. is there anyway that i can also include...
Back
Top Bottom