Recent content by kyo

i think you have to check the relationship. if you upload your database, others could help you. (now it's time to log out.^^)

first you define master table..which is the correct data secondly, create the update query pls find attached.

hi, i have changed your original code a little bit. Sub query_loop() Dim mydb As DAO.Database Dim rs As DAO.Recordset Dim i As Integer Set mydb = CurrentDb Set rs = CurrentDb.OpenRecordset("Select * From tbl_Meetings;", dbOpenDynaset) With rs .MoveFirst Do Until rs.EOF Dim rs1 As...

hi, you can use query as below: ID having More than 1 Value: SELECT ID, COUNT(*) FROM table_name GROUP BY ID HAVING COUNT(*) > 1 update values for 1 ID: update table_name set id=TheValueYouWant where id=1

hi, please change having clause to where clause

hi, i think you have a type casting problem.. please declare the variable data type and check the value. regards,

hi, please find attached.

hi, please find attached

hi, i think iif will work. did you try like this? IIf([field name],0,"")

hi, please change two as follow: 1) changing data type of category field of IncomeRcvd table from number to text 2) deleting the row source's relationship(CatType-IncomeRcvd) of Category control of IncomeRcvdForm

hi, i think your database has logical problems..and i can't believe it had worked before. please review the attachement i have changed the relationship and events. - relationship: data type should be same and it is properly related to the function(log module) parameter. - events: a record...

hi, how about this? Private Sub GLcode_BeforeUpdate(Cancel As Integer) If IsNull(DLookup("Glcode", "tblAccounts", "GLcode=" & Forms!frmTransaction!GLcode)) Then MsgBox "Please enter correct GL account number!" Cancel = True End If End Sub...