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...
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...
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
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...
Usually when I click on the button icon from the tool box, the wizard will appear. But last week when I click on the same button in the toolbox, the wizard did not appear, so did other icons....What's went wrong?
My Identifiction number field have 12 numbers. It is entered in one row by the users. I want to seperate the number to 6 - 2 - 4. For eg. 680572081553. I want to change it to 680572-08-81553 in report.
I have 100 students just finish their examination. I use MsAcces to record the marks. My problem is how to give position according to their Grade Point Average. I know by sorting it I can get it. But when I sort it by name, I lost the number. I want the position numbers to stay on in a field no...