Search results

I use datasheetview, when I want to delete the record I just select the row and press delete button and click "yes". However, when I click "no" (means I don't want to delete) the record is disappeared. I create refresh button to Requery and Refresh the form but the record still not comes up. I...

I use this to calculate my percentage. PerCent: IIf(IsNull(Sum([TotalEachOption]/[TotalCount])),"0.0%",Format((Sum([TotalEachOption]/[TotalCount])),"0.0%;-0.0%;0%")) I get the result but it's a text data type. I try to use Conditioanl Formatting if > 70% is green and < 30% is red but it's mixed...

I have to allocate the students' timetable. I already have a Table containing Student_id, Subject_code and Building_no. This table has all the possibility of Building_no for each student. For example, Student_id Subject_code Building_no 101 A 5 101...

How to pass the values from the first page to the second page? The first page contains the lists of Area_Code. After selecting the area_code and the button being clicked the second page automatically call the Query1 (where the area_code's Criteria is Forms!MainForm!SubForm!txtAreaCode) and get...

I want to make a table (1 row, 3 columns) on Form like we create the table in Microsoft Word. When I type the data in the first row more than one line. The other rows will then automatically expand. All the data will be saved in the same table. I try to combine 3 textboxs but do not know how to...

I have a list box contained the subjects, a button to click when a particular subject has been selected. On_click(), this button will call Microsoft-Word which will open a particular MS-Word file. Each user can see and manage only their file. How to write the VBA code to manipulate this task?

I have 7 tabs on my frmQuestions. They all the same layouts (see attached). Each tab has its Save_Button (e.g. CmdSave1, CmdSave2, ... ,CmdSave7). I do not want to write the same procedure on each CmdSave1_Click(), CmdSave2_Click() ..., CmdSave7_Click(). Are there any alternative ways to do this...

Memo - draw line on report I have 4 memo-fields - strengths,evidence,weaknesses and action. On my report I want to draw a line to seperate them: strenghts &evidence are on the top (left and right) and weaknesses& action are on the buttom (left and right). I found some examples to draw a line...

I created a button on a form ("Form1") in Access2000 using VBA. Normally, when I want to run the Queries I have to press this button. Now, I want to make it automatic and no need to press the button and run daily on the NT server. The step is: 1. Create macro("Macro1") use OpenForm, point to...