Recent content by katekaew

Ar~~ I found a little mistake, It works fine now. Thanks you guys!

It's so strange!!! I try to delete the first record when I click "No" the record doesn't dissappear but when I try to delete the second record and click "No" the record does dissappear. SJ, I also tried yours but the result is the same.

My DatasheetView is on frmSubStrCSA Private Sub Combo_AfterUpdate() Forms!frmStrWeakCSA!frmSubStrCSA.Requery End Sub I tried: on frmSubStrCSA Private Sub Form_AfterUpdate() Me.Refresh End Sub Private Sub Form_Current() Me.Refresh End Sub I also tried: Private Sub Form_Current()...

I'm using Access 2002. I also tried Forms!frmMain!frmSubForm.Requery. It still doesn't work.

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 don't use format(). I calculate and make the table then change the datatype of my fields from text to double and use format as percentage instead. Now, I can use conditional formatting on the menu bar.

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

Page means Form. I tried to make an example to explain what I'm trying to do. Please see the attached.

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

Thanks! I'm not confusing. I just want to know if there is a way to do it. Now, I've changed the design by opening the MS-Word on Button_Click(). Let them do what they want.

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

It works well now. Thank you so much.

I forgot to say that each user can see and manage only their file. I tried the following code: Private Sub cmdReview_Click() Call Get_User() 'To check if the particular user has a permission to review this file 'Open doc Dim objWD As Word.Application On Error GoTo Files_Click_Err Set objWD =...

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?