Search results

Thank you. I will use that along with the timer. I for some reason cannot recreate the error. It might be after a few compact and repair, it just didn't happen again. Clicking on the button 30 times or so continuelessly didn't produce the error again.

Edited. I already created a timer on the form to auto reload and took the reload button away. But is still curious why the error occurred. Hi all. I hope someone can shed some light on an issue that i have. I have a main form that have a query sub form to show some recent checked in data...

ThAnk you

Thanks guys. I found the errors.. i was stuck on this for two days. For example. I have: Nz(Forms!MYVIEWS!COOKIES!AMOUNT, "") but it should be: Nz(Me.MYVIEWS!COOKIES.Form!AMOUNT, "") Also added: Dim amount As Variant And finally: On Error Resume Next On Error GoTo 0 Thank you for all the...

Thank you. I will try that.

Can you give me an example?

Sorry I forgot to mention, the amount is a form caculate field from a query.

Hi all. I'm getting an error when I run the following codes. I have two text field that changes colors on a form based on a subform. I think the problem is when the subform field is blank. I'm getting the error when I navigate on a single form to the next form that have a blank amount in...

Thank you for your inputs. I appreciate it.

I reread your post. You are correct. My original thought was to use the conditional formatting expression is without creating any new queries or forms. I've done this years ago but don't remember how. Thanks for your inputs.

Pat i did what you suggested. Join add the status field. Condition on the status field. Works. Thanks much.

I will try that

MY apologies that I'm not clear on my explanation. I've uploaded a screen shot. I'm trying to get FORM1's sumoft_amount to show green based on FORM2. In FORM1 the records 1 and 3 should be GREEN. I'm trying this expression in the conditional formatting but can't get it to work: I'm using the...

I didn't see that post. There are no relationship between the tables. In Form1, the sumamount field is a total of many fields, pull from a query. In form2, someone manually makes inputs in a different table saying, "hey I looked at this record, on this day, in the amount of say $15.00 and I...

I will post a screen shot when I get back to the work station. The intent that i am trying to accomplish is to make it easier to see that an invoice has been processed Or posted. For example, when an invoice have been posted to the journal on the form2 then on form1 the amount field will turn...

Hi all. I have two display forms (in datasheet view) on my dashboard. Form1 and Form2 based on queries, with different two separate tables. Form1 have an ID, DATE, and SUMAMOUNT Form2 have many fields: ID, LINKED, DATE, AMOUNT, STATUS, ...etc I'm trying to highlight the field in FORM1...

I actually solved this. Pulling from a query, my report won't take the assigning of value count to each detail record and grand total in the footer won't reference the value field. But instead, when i use an iif statement to assign a value to the unbound field then I assign a 1 if the field is...

Hi all. I have a report that have transactions in the detail sections. Such as date, amount and etc. I have a grand total count at end of the report. Some records does not have any transactions but shows a blank detail section with empty fields. I need the empty fields to show that no...

Thanks. I think i fixed it. In my 3rd query i added a left join on the id and linked ID. It works now. I think my mistake was the join type. Thanks for your inputs.

I removed the link from ID to linked ID because I couldn't get it to work. I need the id and the linked ID to match when I run my 3rd query because : Many control transaction reviews can be done on one gaming day total. For example, many people in different departments can review the daily...