Recent content by mmiraj

i use DSum to calculate subtotal Telephone service. By putting GuestID, it will be showed subtotal of telephone service everything works fine. the problem is when data is empty, it is showing error mesage " runtime error 3075 syntax error (missing operator query in query expression...

Hii Guys I have the Hotel program that is coded below. This program can call any data that i have entered(auto look-up) by using GuestID as a primary key/no duplicate. The problem is Since DateCheckOut must be filled when the guest check out, everytime i call each data by entering GuestID, I...

Thanks for the response, i can't use combo box for some reason GuestID is numeric Yes this field is required no, this is second field to be filled out

I use this expression to prevent duplication on my data (GuestID is unique).it was successfuly creating my own message. The problem is it comes up another message " The value in the field or records violates the validation rules for the records or field" Is that "Variant" affect to my GuestID...

Dim varLastName, FirstName As Variant varLastName = DLookup("LastName", "Registrasi_Tamu", "TamuID =[TamuID]") varFirstName = DLookup("FirstName", "Registrasi_Tamu", "TamuID =[TamuID] ") If (Not IsNull(varLastName)) Then Me!LastName = varLastName If (Not IsNull(varFirstName))...