Recent content by edkocol

  1. E

    Select Row in sub form - set value in another sub form

    Yes I probably did not explain it well enough. Sorry. SubFormA is a collection of rows that essentially falls into two categories. If one of the two categories of rows is selected I want and unbound check box to not only appear but to be initialized to false (unchecked). The other category of...
  2. E

    Select Row in sub form - set value in another sub form

    I want to guarantee that a check box in subFormB is set to False when ever any row is selected/navigated to in subFormA. I'm at a loss on how to do that. Any help would be greatly appreciated.
  3. E

    or or or Question

    Also is there a similar function like Oracle's "in" list function i.e. "If Me!ClientID in (147, 151 ....)"
  4. E

    or or or Question

    If Me!ClientID = 147 Or 151 Or 187 Or 189 Or 190 Or 191 Or 193 Or 197 Or 198 Or 199 Then .... do something End If Is this the corrrect way to limit the "do something" action to take place for the desired 10 clients? What is happening is clients other than the 10 in the list are performing...
  5. E

    passing null value causes error

    DOH!!!! Thanks for pointing out the obvious.
  6. E

    passing null value causes error

    x = Update_Exposure(Me!RecordID, Me!ClientID, Me!Exposure) Why does the above statement halt with an error: "Invalid Use of NUll" when the value of Me!Exposure is in fact null because the memo field Exposure has been blanked out by the user on the form? Function Update_Exposure(precordID As...
  7. E

    Any tools to track code changes

    Yes, I imagine so. I was hoping to hear someone has developed a bit more sophisticated tool. I'd even pay $50 for said tool.
  8. E

    Any tools to track code changes

    Is there a tool to compare two databases to find all coding (not data) differences showing the program unit (form, report, query etc.) by name?
  9. E

    Call Forms.<formname>.tst1 - what the heck?

    I have inherited an access database and so I'm not an expert on it's functionality just yet. What does this mean: Call Forms.<formname>.tst1 A bit confused I am for sure about the ".tst1" <edit> aha!!! there is a function called tst1 in the form called <forname>
  10. E

    I'm stumped with this query

    Re: I'm stumped with this query - Solved Solved. The lookup specs for column A_ScriptPODetail.ScriptPOID is displaying the value of A_ScriptPO.PurchaseOrderNumber not A_ScriptPO.ScriptPOID. I now understand the relationship of these two table. BTW, I "inherited" this system and I am learning...
  11. E

    I'm stumped with this query

    I wonder if this has a bearing? A_ScriptPODetail.ScriptPOID is defined in the table design as a lookup based on another table's primary key (A_ScriptPO.ScriptPOID = autonumber).
  12. E

    I'm stumped with this query

    Already did that. I was told: Data misimatch type in criteria expression
  13. E

    I'm stumped with this query

    Sorry, I should have said it is a Number.
  14. E

    I'm stumped with this query

    I'm stumped with this query - solved - see post #9 [EDIT:] SOLVED see post #9 This query: SELECT B_Inventory.Barcode, B_Inventory.QtyOnHand, B_Inventory.QtyInPO, A_ScriptPODetail.Quantity, A_ScriptPODetail.ScriptPOID FROM B_Inventory INNER...
  15. E

    Unable to delete record in 2007. 2003 & 2010 OK.

    sxschech, Not to my knowledge. As I said this is a standard install of Access 2007 with no options changed. If it was read-only why would the New Record be accessible?
See more
Back
Top Bottom