Search results

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).]

I want to make this statement as a module to be used by severals txtbox..Can sombody please help me , do I have to change certain words in this statement..to make it work.. If IsNull (Me.FieldName) Then Me.FieldName.visible = False Else Me.FieldName.visible = True End If

The field still visible....actually the format is "percent"....anyway I had cancelled it to try this statement...it did not work...help me some more plz.....

Thanks Rich, but where should I put this statement....I've tried it in "On No Data" and "On Error", the field still visible..For your information, actually the field is a result of 0 divided by 0. Hope to hear from you soon......Thanks in advance..

How to make a field automatically invisible if no data (#Num) for that field.

I've read about using Calendar Control (Active X) in a form in an article. I've tried it but failed. Can anybody help me....I want the user to click a field in a form, and then the calender pop-up, the user then choose the year/month and date to fill up the field....Help me plz...I'm using...