Search results

I need to do some tests after I close the form. If I can't do it this way I'll find another way :)

No, it's a button I put there. Look at pic 1 :(

This is what happen, as you can see in pic. 2 The form's border was set to none, and opening it in acDialog mode showed the border and an empty title bar, with no controls My question is how can load the form with no border and still prevent the code from continue running ?

It set to none, as you can see in the first picture I posted

I want it to look like this But if I open it in acDialog mode it will look like this

It is Still does not act as :(

Thank you all Once I know the Red and Blue are swapped I can live with that :)

I open a form from a function (It has to be a function to be run from an .OnDblClick event) I want the form to be opened and halt the remaining code from running. This form should have no borders. If I open the form in acWindowNormal the form will look as I expect but code will continue to run...

I know

Thanks This do the job :)

I'll try to explain the situation better I have a form with two SubForms The top one show a list of records and the bottom one show some data for the selected record on top. After editing data in the Bottom one I need to requery the top one to reflect some changes made. Now I need to go back...

I requery the form to show some changes made. I need to go back to the record I was in

Ouch :oops: How can I know where the VBA.Hex(lColor) is ?

Hello I need to find a specific record on another open form. I want to select the "RecordName", based on the "RecordID" How can I do that ? Thanks

Thanks I already have a working code. Problem was with the built in VBA.Hex(lColor) which reverse it :( As also approved by missinglinq All iis good now :)

As example The correct Color code for RGB(74, 169, 194) is 12757322 The correct Hex code is #4AA9C2 VBA.Hex(12757322) will result in C2A94A :oops:

is it possible that VBA.Hex(lColor) give a wrong color code ? Seems I have to take it like Last2 - Middle - First2 :rolleyes:

Thank you Case is already solved as suggested by theDBguy I like your suggestion,and might go for this direction :)

Thank you This did the job :love:[/code] This one worked Thanks :love:

Hi I'm using this code, but it will fail on Me Me.ProductPercent1.OnDblClick = "=fnCalcPercentFromQty_Click(Me, 'ProductPercent1')" This how the function looks like, so Me as Form should not be a problem Public Function fnCalcPercentFromQty_Click(frm As Form, strControlName As String) It...