Can not filter

[shiro]

After perform ULS,I can't filter the record in my form.
Usually I can right clicked the text box and entering the target
in the "filter for" field.But now it doesn't make a sense if I right
click the text box..

But if I open the database by pressing Shift + Enter key,the records
can be filtered normally,How to solve this problem ?.

Thank's in advance.

 

[Joan Wild]

Check the properties in Tools, Startup. Allow shortcut menus may be unchecked. Using the shiftkey will bypass the startup options.

 

[shiro]

Thank's Joan,
It works fine.But one more question in different topic.
I have a excel pivot table where it datas come from
my access db table.But it seems,the ULS cut data read
permission for the pivot table.Do you have an idea to solve this.

I'm trying to create an application were the data displayed
in excel.I create a link on my form to the excel pivot table
,the file is opened fine,but unable to refresh data.
What should I do know?


Check the properties in Tools, Startup. Allow shortcut menus may be
unchecked. Using the shiftkey will bypass the startup options.

 

[Joan Wild]

There should be some way to specify the workgroup file to use in the connection from Excel, which would prompt the user for a username/password. I'll check further.

 

[Joan Wild]

OK, I tested this and you can specify the workgroup file to use when you setup the data source in Excel. Another alternative is to just keep the pivot table/form in Access, or push the data from Access to Excel and then open it in Excel.

 

[Samuel Patterson]

:

There should be a new speacial chip built for the motherboard, that is able
to stabalize more intelligent attributes, specify the work group files, In
increase the sufficientcy of our exel.....

 

[shiro]

Yup !!! Got it.
It mean we define our mdb and workgroup file as a new data source.
It works good Joan,
Thank's a lot.


OK, I tested this and you can specify the workgroup file to use when you
setup the data source in Excel. Another alternative is to just keep the
pivot table/form in Access, or push the data from Access to Excel and then
open it in Excel.