Recent content by newbie1

yup i just make this quick change, silly me cos earlier i remove some validation but forgotten about the table validation. now its working again! thank you so much

Hi June7, Yup the export to excel works just that the data entry to table fails. I will remove those cancel=true. I will go through those required fields (is under the form properties for that field right)?

Hi missinglinq, Thanks for your help... I need all these comboboxes (except Category) to be bound as it will be data entry into the table... Except for category which is unbound as a selection to populate into the description field. I will try out the error handling portion.

Hi June7, Thanks for your help. so is this line that is the problem? It was working fine previously though... Private Sub cmdSaveRecord_Click() . . . On Error GoTo NewRecord_Err On Error Resume Next DoCmd.GoToRecord , "", acNewRec NewRecord_Exit: Exit Sub...

ok, uploaded db here.

Hi there, It has been a while since I did programming and touching MS Access. So recently I created a simple MS Access Form, everything is working well until I added unbound combo fields to the form and it stopped working. Since the addition of unbound combo fields, the insert fails to work. I...