Recent content by ALAN

How to ring the bell using access according to the school's time tables from morning till dawn (2 sessions).

I have found that if 2 persons edit a same form for a same class of my school at the same time, only the last form will be saved. Can I prevent other user from editing a form of a class if the form of the same class is being edited by other user. The form is connected to a query. Help me...

How to create a set of radio button to sort Field1 or field2 in a form.?

I got error message, can u give other suggestions please.

I use Crosstab query in a report, how to automatically change the blank spaces in the report to zero?

How to create a button to open a blank form?

I got my pivot table...but the problem is..it appears in list...how to make it appears individually and syncronised with the main form? (StudentID) Somebody plz help me solve this problem..... [This message has been edited by ALAN (edited 06-13-2001).]

Thanks Kevin.I've successfully build the crosstab query and I got like this: StudentID A B C 411.....2..3.. But I got 2 problems: 1. How to change the null value to zero. So that it appears like this: StudentID A B C 411.....2..3..0 2. When I take the crosstab queries as a...

I got a query to count grades for my students like below: StudentID CountofGrades 114 2A 114 1B 114 3C 116 1A 116 3B 116 2C …… …. …… ….. My problem is how to change the appearance of this query in a form or a report so that it appears in rows as below: 114 2A1B3C 115...

How to change this message with the message of my own "You tried to assign a Null Value to a variable that is not a variant data type."

What about if I have 3 fields (eg: Myfield2, myfield3 and myfield4)...and I want to use this module for all these 3 fields....Where to put the name of these fields?

Thanks Pat...It Works....Thanks again...

IIf(Nz(YourField1,0) = 0, me.invisible, YourField2/YourField1) What's wrong with this statement? Help me plz...

Its really work.....Thanks Rich, Kevin and Pat...I'm sorry if I had caused difficulties ...I'm too eager to solve my problem...I am glad I had solved it ....thanks to all of you...

The display is #Num!....I'm waiting....Thanks in advance... [This message has been edited by ALAN (edited 05-26-2001).]