Search results

  1. mykil

    Data Type mismatch in criteria expression

    Hi Everyone. I have a Database for Logging students every time they want to use the Computer Laboratory that works perfectly fine. I have a StudentForm where I input all the students data and a LoginForm where I add them whenever they used the Computer Laboratory that is by entering their...
  2. mykil

    Calculating Grades in VBA

    :banghead::banghead::banghead: I'm creating a form which stores a grade of a student for specific subjects. What I wanted to do now is to have a textbox which will calculate the average grade of the student using VBA. For Example, The fields to be filled in are: MATH1, ENGLISH1, SCIENCE1, and...
  3. mykil

    Printing Report between two dates

    Hello everyone!!! Do you have any code for viewing Report between two dates. So when you open the report it will ask for the starting date and ending date. Any help will be much appreciated!!! Thank you in advance!!!
  4. mykil

    copy time to textbox

    Hi everyone. Do you know how to copy the time automatically to text box to become time as data (rich text) when entering data to a form. Thanks a lot!!! :confused:
  5. mykil

    Warn user When the Data Being Entered 3 times

    Hi everyone. can you help me make this up. I am making a simple database for the computer laboratory in school (my place of work). Actually it is a Automated Logbook System. Here's the Problem. I want to make a form that will prompt me whenever I enter the data(ID number) of the user(student) 3...
  6. mykil

    putting delete command button in a form that has subform

    Hi all!!! Does anybody knows what is the code for a delete command button in a form that has subform which are related to each other? Thanks in advance!!!
  7. mykil

    Continuous Data without blank space

    Hi Everyone... I have created a report for Student and I want that the data in the detail section (subreport) will continuously be filled up the page without a blank if the pages of the report is more than One(1)...See attachments.. The photo1 is the first page of the report and the photo2 is...
  8. mykil

    Quick Question

    Hi to all!! I'm confuse with this. Where is the data being stored at the BACK END or FRONT END?:D
  9. mykil

    Forms and Subforms

    Hi folks!!! Can you help me with this, I want to have a Form for students that has a subform for their respective subject per School Year and Semester...I know how to add a subform in a form but I don't know how relate them...I know, these should have been done through making a relationship with...
  10. mykil

    Show only pop up forms and not the access window

    Would you help me with this!!!When the user opens the access database I want that only the main form will pop up and not the access window.. is it possible to hide the access window but not the forms? Thanks in advance!!!
  11. mykil

    Case Select

    Hi to all!!! is it possible to make Select Case Condition in VBA which have IIF statement or Condition rather:D?
  12. mykil

    Conditional Formating

    I want to have a Combobox that will automatically filled the "value list" fro a certain "textbox". If a user will choose " First Year" which in the value list of ComboBoxA it must produce the "Value List" (may be called "Case Value" I'm not sure with correct term used) for TextBoxB so that; if...
  13. mykil

    Fixed Format In The Report's Detail

    Is it possible to have a fixed format in a report? If Yes, Could You help me by giving the procedures on how to do this or may be code...The report should have 2 columns with the data entry like most of you have probably done by just formatting the column width and height of the report. Now, My...
  14. mykil

    Total Sum for a Field named Units

    Hi Folks.. I have a report for students. I'm trying to sum up the field named Units so that I would know how many units was earned by the student.. By the way i have 2 columns in my report:confused:
  15. mykil

    Locking the design view of a form

    Is their a way to lock the design view of the FORM? This is to avoid the Future users accidentally open or change the design...Thus anybody knows how to do it? If so, Please Help Your Help will be much appreciated:(
  16. mykil

    Having a Total sum of Grades

    Hi Folks, I'm working now with a simple database for students and i have a little bit problem for you to ask and I know that someone here in forum knows it... In my form I have fields of student's Subject with Corresponding Units. My Question is, Is it possible to sum up Automatically the Units...
  17. mykil

    Greetings from Philippines

    Greetings from Philippines:D
  18. mykil

    Entry Data to combobox that will supply the corresponding Data to a textbox or field

    Hi Folks, I'm Still new in making access database and I need your help. Is it possible to have a combobox that has a corresponding data to a textbox or field. what i mean is that when you enter data in the combobox it will show its corresponding data in a textbox or field. For example: if I...
  19. mykil

    Total for grades/Can't Solve the Sum using Expression Builder

    Hi folks,I'm still new in making access database. Now, I am task to make report for the school I'm working at. My Problem is, How to add multiple data in a report which has a decimal point and show its total using expression builder..:( Any help will be much appreciated Mykil
  20. mykil

    Columns in a report

    Hi , I'm still new in making access database, could you help me in this matter; i am making a report for students and i want to make two(2) columns in my report; is it possible? if it is, can you gave me the codes or direction on how to do it,..,I'm working with it for almost 1 week and still no...
Back
Top Bottom