Recent content by E-D

Well. I found a way to bypass the problem by using the tag property. Anyway I solved the problem.. thanks

Yes you both are right. I'll do it. Thanks

I meant to say that I have many Combo Boxes in my prog based on the same strategy: 3 columns when the width of the first two are 0 and thus only the third column is seen. When I sort those Combos, it is sorted according to the first columns and not the one seen. Ex: SuppliersID...

I came to realize that I have too many fields I want to sort. Making a query for each one of them will be a complicated work. Can you think of a more effective solution?

David R - I took your advice. I've used the dmax function and it's doing a great job thanks

Thanks you both. that will do.

I see. But Don't you think I can Undo A new record? If such an option doesn't exist I'll try the dmax() function out .. thanks for replying

I haven't thought about it..thanks

How can I change the form's backcolor to yellow by code? thanks

hi. I have a combobox, SuppliersID. the combo shows 3 columns. The width of the first two is 0, so I can see the third column only. I want to sort the combo according to the third column - the one I see once the Combobox is being openned. Is that possible ?

In one of my reports I have changed the side margins into 10 mm however everytime I restart the prog, the margins return to their default definitions How do I save my definitions? thanks

Private Sub CmdCancelReport_Click() Dim a As Integer Dim b As Integer 'CUSTOMERS_ORDERSstatus.SetFocus If CUSTOMERS_ORDERSstatus.text = "" Then a = MsgBox("Are you sure?", vbYesNo) If a = vbYes Then CmdCancelHeshbonit.Caption = "yes" CUSTOMERS_ORDERSstatus.Text =...

hi guys. I really need your help: I have a form for Suppliers Orders. Every record has it's SuppliersOrdersID which must be a running number. My q is: When I open a new record and I want to cancel it for some reason, which code line should I use. I'm asking because When I use Me.Undo it erases...

Problem is solved. thanks

the sub form is seen in the report's design mode but not when I preview it. aren't the form + subform that I saved as a report should be already linked once they become a report? (they were linked in the form)