Search results

When printing an invoice, the report shows all records instead of the 1 record from the invoice. How do I make sure that only 1 record will show in the report (the report is based on a query, BTW) Thanks.

When an invoice form is completed and saved. How do I clear all former data and start again from scratch?

Yes' that is another problem. Why isn't it being saved in the table? what's wrong?

Thanks for the quick response. It doesn't work. The whole command is on the report button: Private Sub PRINT2_Click() On Error GoTo Err_PRINT2_Click Dim msgResult As VbMsgBoxResult 'Boolean msgResult = MsgBox "are u sure u want to save?", vbYesNo, "Important!") If msgResult = vbNo Then...

I'm usind the damx+1 function for creating the invoice number in the invoice form but when I print it, the report gives me the former number (before the dmax+1). What am I doing wrong pls? Also, the report gives a different customer name that the 1 in the invoice. Why? Thanks.

Thanks guys for your help. I'm going to work something out here.

Thanks for the quick reply guys. I aldso agree with Max as the whole problem began when I tried to write 2 children for the same parents - I entered the same data again. Can I relate only mother table to children and relate all other relatives (+ father) to the mother table? Sorry for nagging...

Thanks for the reply. So is there any problem with table being so long? Here's the table I'm getting : CUSTOMER_CODE NAME FAMILY_NAME FATHER_NAME FATHER_CODE FATHER_PHONE MOTHER_NAME MOTHER_CODE MOTHER_PHONE NICK_NAME GENDER STATUS BIRTH_DATE ID_NUMBER OWING_MONEY ENTITLED_TO_BOOKS ADDRESS...

Thanks. How do I do that if I must keep details of the father, his work place, cell phone, birth date etc, same as for the other relative etc'. I cant keep it all in one table or can I? If I keep in the table father code and then relate it to father table, would that do?

I am a newbie and just found your forum - hope you can help me. I built a kindergarten software but seems to have a problem : I have children registered and I keep records of the parents, other relatives etc'. My question : what w'd be the relations between the tables since parents can have more...