Search results

I did. In case of forms there is the .movesize that works great for me. I am looking for something like that. Report pops-up to show information and i would like to resize/adjust that window. So i guess it is not the report itself that i would like to adjust, but the window where it is shown

Hi, I am looking for some on help on this. I have a report to be opened as pop-up in viewreport view. Because of filtering normally only one line showed up. However the window is much bigger and there is a big white empty place i want to avoid. Heights of details section is adjusted to fit...

Thank you all for the kind help!

Actually two strUpdate statement is different. The second one has one more criterium in where statement

Interestingly that part work well. Probably the confusion is caused that i kept the name strUpdate through the code with different sql statement.

So maybe i need to apologies...As I designed the form, the unbound fields format have not been set to general number... May that be the reason for not comparing the values? It seems now that it works i.e. makes the comparison and runs the code correctly. I will keep on testing. I will report...

ElseIf Me.txtInvoiceTotal > Me.txtReceived Then 'partially payment received This is the part that does not work. Simply this comparison is not performed if only one the fields is changed. Concerning warning i have arleady checked on every step using msgbox s. I have done a small DB to present...

During the onLoad event the unbound fields are getting their values and are populated by the correct value. The problem emerges when i change only one of them and not both of them at the same time. That is when code does not run correctly and the comparison fails.

Private Sub cmbCreateInvoice_Click() 'to turn of warning for running sql statement DoCmd.SetWarnings False 'to post the book: update tbDiagServMat and insert tbLedger, tbInvoice_Status 'update tbDiagServMat 'InvoiceDate = TempVars!pass_InvoiceDate InvoiceDate = Me.txtInvoiceDate...

Sorry. I have a form that lists services to customers with prices. When i do accounting i am "sending the customer name and the total price of services to another form. In this form there are two unbound form: one with the total price, the other unbound field is the money received. The default...

It seems that the following happens: if the 2 txtbox value is not changed after onLoad, the comparison function works well. If i change only 1 txtbox then the comparison fails. If i change both txtbox then comparison works agian.

Hi, I am trying to solve the following and asking for help I have a form frm1 with 2 unbound field txt1 and txt2. I want to compare the values of these fields in an if/end if condition. The first field txt1 gets its value from an other form via TempVars! on onLoad event. However it does not...

Thank you so much, now i understand it. So it means since multiple forms are open in dialog mode, it confuses the system so unless it is explicitly "re-commanded", it is not setting the focus to where i think it should.

No. Right before

Before opening i have a close form command for frm1

Hi, I am struggling with following which more a theoretical question, since some workaround i have found, but still would like to understand the "error". I have frm1 with pop-up=yes with a cmd button to open frm2 that has pop-up=yes. Frm2 has a subform with fields. After opening frm2 the focus...

thank you for all the help

sorry for not being completely clear: it was only for testing purposes to provide a short but valid sql statement

it was/is the same table/query with the same number of columns, but different parameters.

it seems to me that the recommended solution was not different with what i tried to use namely to put the code in the onload event of parent form. However the solution i have found was to declare the record source string as tempVars "one form earlier" when the different setup can be selected...