Access web db in sharepoint 2010

[lluki]

I was able to publish db, but problems:

1. sort will not keep alpha order (table is in alpha order, but forms won't keep sort)
2. look up field "not all items are shown" - won't show whole list
3. where is a "find" or "search" within records??

any help greatly appreciated... Thanks!

 

[Banana]

1. Did you base your form on a query that has a order by clause?

2. How many items do you have in the lookup? Did you create a lookup field?

3. If you mean built-in one, it's a part of the Navigation bar shown on the bottom. You may need to enable Navgiation Button = Yes in order to use the filter field to right of the buttons. Otherwise, it's something you build yourself.

 

[lluki]

1. no, form is based on table
2. there are 874 records now, more to be added; yes, this was created from look up field wizard
3. "You may need to enable Navgiation Button = Yes in order to use the filter field to right of the buttons." where can I find this to enable?

Thanks so much for your help

 

[Banana]

1) I usually recommend that you base your forms on a query, not table. Query allow you to control the presentation of data more than if you based on table. Forms may have some properties that allow you to work with data but my experience is that queries are more reliable and simple to use.

2) It's possible that 874 may be too much. Is there a possibility of filtering the list down to a smaller sublist first?

3) When you open the form in layout view, it's on the Format tab on Property Sheet. If you don't see a Property Sheet, click "Properties" on the ribbon for Form Design tab.

 

[lluki]

1) Thank you!! I changed the source to a query, and this kept sort in alpha order

2) Very frustrating that this would be so limited - it seems a table will have many more records! The form I am using is a based on a query which uses a look up field in order to link two tables; it is used to limit the number of fields in the first table (sort of continues the topic with subtopics)... also so the reports generated from this query can pull from both.

3) I verified that the format tab states "yes." However, although the navigation button shows the search field when db is open on local machine, but the search box is replaced with a save icon in the row with the record box / arrows when it in online / web.

Sorry to be a pain~ i really appreciate the help!