Search results

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)

your way is great, however when I saved the form as a report it only saved the main report and not the sub form attached to it ? any suggestions?

oh! that's great. I didn't think I could work on it. great I'll do that I hope I will manage to open the report with the current data... I'll try that, thanks a lot.

I want to print only the current report but when I save the form as a report the printout is colorful with all the Cmd Buttons. I wish the report to look like a report and not as a print screen shot of a form. If you think about it I basically want to use only the fields in the form. to your...

ouch! there must be an easier way.. it's a complicated report and my calculated fields are not based on any query. anyway thanks for the help

not good I don't want a printout of the report I only want my report to have all the fields used in the form. When I save as a form I get the form's design as well. please advice