Search results

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...

DisplayAll means in my setup that all records for given customer regardless the status of the records.

Because for different needs i am to use the same form.

I am not sure if i understand it correctly: put the code in the OnLoad event of the frmMain? I think i have done it in the beginning. I have put my code there, or do i miss something?

I have read in a forum that subform loads before parent form. Is it correct?