Error message appears when multiple people Access Database

[TonyES]

The "standard" way of doing that is to use a separate table for the keywords, in which each inventory item/keyword combination is a record, and to use a subform for the keywords instead of a multi-select list box.
Follow the below instructions:
General recommendations:
- Turn off "Track Name AutoCorrect Info" in the General tab of Tools | Options... in each database you create.
- Set the Subdatasheet Name property of all tables to [None].
- Avoid creating duplicate indexes; Courses, for example, had two indexes on CourseID.

[TonyES]

Sometimes it's possible to delete the problem control by trying to delete it repeatedly, but there's no guarantee you will succeed. Rebuilding the form is probably easiest. You could copy all controls except the WordArt object, and all VBA code (if any) to a new form.

[Hippo86]

Thanks Tony for the advice, I did as you said by rebuilding the form.

[NewBridge]

Thank you Tony.

[Ginger]

I am trying to do my grades in Access 2000 and have hit a snag - I've figured out how to calculate the grades (with a linked Excel worksheet) using a 0-4 point scale, but want the grades to be displayed as a A-F value.

I did this in Excel with a formula (example):
=IF(COUNT(Y2)=0,"",IF(Y2>3.4,"A",IF(Y2>2.7,"B",IF(Y2>1.7,"C",IF(Y2>0.9,"D","F")))))
which took care of not counting blank (grade) assignments and making sure the final average only calculated graded items.

I am trying to accomplish the same thing in Access, focusing primarily on the IIf function. Maybe a macro? I'm trying to learn! I've tried several IIf variants, but the best one gave a circular reference error.

Basically, all I want is if the value is Null, the field in the report will be blank. If the value is 0, and "F" is displayed, if it is 1, a "D" is displayed, if it is a 2, a "C" is displayed, if it is 3, a "B" is displayed, and if it is 4, an "A" is displayed. The report is from a table with grades recorded as 0,1,2,3,4, or blank.

Any ideas?

[TonyES]

Try this,
=IIf([intGrade]=0,"F",IIf([intGrade]=1,"D",IIf([intGrade]=2,"C",IIf([intGrade]=3,"B",IIf([intGrade]=4,"A","")))))

[Imagineer]

I have MS access contact database and I was playing around with the Startup MenuBar Property and defult menu and now my tool bar ans menu is gone, only show File , Window Help , and startup is gone how do i undo this?

[DLong]

I would like to know if it is possible to refresh a MS Access report which was built from a table on SQL Server via ODBC automaticaly when I open it ?

[TonyES]

Hold down shift key while you open the db. then go to TOOLS > STARTUP ... to reset it.

[TonyES]

The record source behind a report should show up-to-date data when you open it. It is never refreshed unless you close/re-open the report. If the report is based on a temp table or a 'dummy' table which is loaded via some stored procedure, that's a different story and of course that proc. has to be rerun--but typically this would be part of the code behind your 'Open Report' button on whatever form you use.