Search results

  1. A

    Bell Ring Using Access

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

    Prevent 2 person edit the same form...

    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...
  3. A

    Radio button to sort data

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

    Changing blank spaces to zero

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

    Button to open a blank form

    How to create a button to open a blank form?
  6. A

    Column in queries to row in report

    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...
  7. A

    Edit access's message

    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."
  8. A

    How to make this a module

    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
  9. A

    INVISIBLE IF NO DATA

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

    Help - Calender Control

    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...
  11. A

    WIZARD DID NOT APPEAR

    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?
  12. A

    SEPERATING NUMBERS

    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.
  13. A

    GIVING POSITION IN EXAM

    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...
Back
Top Bottom