Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jun 02, 2012 11:34 AM by hans_v
May 31, 2012 01:39 PM|LINK
I have a query, that when run does not allow users to update the records while in datasheet view. I understand there are rules for when this is allowed but I cannot figure out how to change my query to accomplish this.
If someone can take a look and spot how I can change the query to allow edits in datasheet view that would be great!
WHERE DateReceived>=forms!PPDRepIndividualInvoices.Date1 And DateReceived<=forms!PPDRepIndividualInvoices.Date2 And DateSentToAP IS NULL And Switch(forms!PPDRepIndividualInvoices.PPDRepID="ALL","",True,[PPDRepID]=forms!PPDRepIndividualInvoices.PPDRepID<>False);
Jun 01, 2012 06:45 AM|LINK
These forums are intended for ASP.NET (web) related questions only!
Jun 02, 2012 01:36 AM|LINK
This is a place for you to talk about Access problems……So are you asking something related to Access or Excel database？please tell me and I'll connect to Moderator to move your thread where it suits……
Jun 02, 2012 10:02 AM|LINK
Decker Dong - MSFT
This is a place for you to talk about Access problems……
Yes, when related to ASP.NET:
"Discuss using Access as a data store
for ASP.NET, and the AccessDataSource control."
From the query that is shown, you can easily tell that this is not in any way related to ASP.NET!
Jun 02, 2012 11:12 AM|LINK
I don't know why you are always challenging me—— I just let client ask proper questions and if he wants to say anything else, I'd alert moderator to move it where it suits.
Jun 02, 2012 11:34 AM|LINK
Decker Dong - MSFT
I'd alert moderator to move it where it suits.
And I already explained that his question doesn't belong to any if the forums on this website, simply because it's not web related.
You feel I'm challenging you, but I don't. INn this thread, it's you who's challenging me. I just say that this question should be asked elsewhere not in this or any other forum on this website, whiich is intended for ASP.NET related questions only....