Recent content by kelvin2088

Omg! Great! Thank u so much!!:d

What i did wasn't working....

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.

How do I solve this problem??

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.

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

Oh My God It worked!!! I just got rid off the space between the code that you provided and i worked i think!! thank you so much!!:D

It'll be used in access published sharepoint site. "Like" is not recognized by query editor and it won't allow me to save to query.

that's so weird... it's not working in the criteria textbox that i showed in attached picture. is it because i'm putting it in a control of a webform??

Thanks! I tried, however, it shows invalid syntax. I'm coding this in a web form, and "Like" is not in the function library.

Here's my query:

There's no other code, just fairly simple query. The expression is the only code in there.

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

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

I tried and it worked when I only opened the subform.(not together with main form) When I open the main form, the inventory part of the colum shows "#Error" and keep on flashing. And sometimes it works by showing correct number.....what's going on? I'm using Acc2003