Search results

  1. M

    Printer printing only one copy and blinks instead of printing let's say 10 copies.

    I am trying to print copies from my Ms access application. After printing one copy, the printer stops. What could be the problem. Is it page settings on application? How can I fix it? Thanks.
  2. M

    Show Taskbar

    Hello everyone. I am humbly requesting on how to show Taskbar when the form is opened. Please kindly look at the attached database and please look at the form frmMainBG1. I want it when opened, taskbar should be seen such that when a form is minimized, should be seen in taskbar. Thanks in advance.
  3. M

    Solved Archive old records

    Hi everyone. I am making students database. Is there a way to archive records of students who have left school e g a school has grade 1 to grade 6. When a child finishes grade 6, the records are to be archived. Should not be active in existing learners. Thanks in advance.
  4. M

    Query to promote students

    Hi all. I am requesting for assistance on a query to promote students on January every year. Kindly look at the attached database. Thanks in advance.
  5. M

    Solved If single then Null otherwise keep selecting value

    Hi everyone. I have two related tables:- 1. tblGrades. 2. tblStreams. The two tables must have values. By default tblStreams should have "SINGLE" implying single stream. My question is HOW WILL I MAKE IT IN REPORT "SINGLE" not to be seen. In the same tblStreams other values are NORTH SOUTH...
  6. M

    Solved VPA to change from 64 bit to 32 bit

    Hi everyone. I created a database using 64 bit. When I use in 32 bit, it can't work. Is there a VBA code to change from 64 bit to 32 bit. If so, I am really begging you to assist me. Thanks in advance. God bless you all.
  7. M

    Solved Print selected invoice

    Hello everyone. I have a slight problem. The following code does not fire to print selected records in invoice. It is supposed to filter the selected records and the studentID Private Sub Command48_Click() Dim sFilter As String On Error Resume NextDoCmd.CLOSE acReport, "INVOICE" sFilter =...
  8. M

    Solved DLOOKUP gives a date value instead of a numerical value

    Hello everyone how do I use dlookup in a report to refer to a numerical field in a query. When I used the following it gives me the date value 31 December 1899 =DlookUp("classrank","qryRanking","STUDENTID=" & [StudentID]) Kindly assist me. It gives me a date 31 December 1899
  9. M

    Solved DYNAMIC SEARCH FROM A FORM TO DISPLAY RECORDS IN SUBFORMS

    Hello everyone. I am humbly requesting on how to create dynamic search from a form to populate records in subforms. The records should be shown as you type or when you click search. I have the following subforms from different tables. 1. Tblstudents 2. Tblyears 3. Tblgrades 4. Tblterms 5...
  10. M

    Solved Yearss

    Actually I am defeated. I am looking for a query to show students and classes and streams. I created sub forms like this. Look at relationships. Main form- tblstudents. Subform1- frmgradeyears. Subform 2- frmgradestream. Now my question is When I create a query it puts a student in all...
  11. M

    Solved School database

    I am very new to access. I am trying to make a school database. In my school some students let's say 15 take subject A and another 25 take subject B and another 30 take subject C. I am trying to use YES/NO. For student 1 click yes for taking subject A and C. Student 2 click yes if taking...
Top Bottom