Recent content by gheepok

i am new at Internet Information Services(iis). i have a .accdb file. That file have table,form, macro and almost everything. how can i put the database in iis localy?:confused: someone help.

i dont want to clear every field when click a button. can we write a vba code that can clear a field at main form and subform. do you have any sugguestion to clear a field at main form or subform with a button? thanks.

in user table the id is foreign key. the subform is user. can you give i a sample on the vba code. thanks.

this is the screen shot of the relation ship. vbaInet i only need the keyboard delete key action code on a button.

yes i have the relationships but still have no luck. i need a button that have have same action with delete key on a keyboard. the button can works on main form and subform.

i want to create a button that have delete key action. this Application.Screen.PreviousControl = "" works on main form but does not works on subform. please someone help.

thanks ghudson. Application.Screen.PreviousControl = "" works. this works on a main form only. but how to do this in a main form button that clear a field in a subform. please help.

yes. i have try that. the delete button wizard will delete every data in the current form. i want a button that can delete a seleted field only. please help.

i want to create a button that act as pressing the DEL key. Can someone want help i. thanks

Thanks boblarson. It works better now.

i have solve the problems. need to name the function in m_software to Function AuditTrailsoftware(Myform as Form) and DoCmd.OpenModule "m_software", AuditTrailsoftware(Form) in the Private Sub Form_BeforeUpdate(Cancel As Integer) for f_software Thanks pbaldy for the quick reply. here...

Thanks pbaldy i still have no luck. the main form works and can run the function AuditTrail2() but the sub form have error. i have attach the files. Help please. Thanks

Hello, I have a Function auditTrail(myform As Form) in a module name m_software and Private Sub Form_BeforeUpdate(Cancel As Integer) Dim saveAns As Integer saveAns = MsgBox("Do you want to save changes?", vbYesNo) If saveAns = vbYes Then DoCmd.Save acForm, "f_asset"...