Search results

  1. 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.
  2. 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...
  3. 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...
  4. 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?
  5. 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>
  6. 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...
  7. E

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

    I cannot delete a record in Access 2007 but I can in 2003 or 2010. This screenshot shows how the Delete Record is grayed out. This is a vanilla 2007 installation. Any ideas why this is happening even if I am the only one opening the database?
  8. E

    Mixed environment 2003, 2007 & 2010 - calendar fails

    This system has two forms that accept data for reports. There is a calendar on the form. The calendar works for Access 2003 and 2007 (after I changed calSetDate = Date to calSetDate = Now in the form opening logic; = Date failed in 2007 but not 2003). However the calendar does not work in...
  9. E

    On Lost Focus error

    I am working on a system I did not develop in Access 2010. A form (that was called by another form) generates an error when moving from any field that contains an On Lost Focus event. The Access error message is: The expression On Lost Focus you entered as the event property setting produced...
  10. E

    Returning to Access after many years away.

    Software developer here. Focused on Oracle and MySQL for a number of years but I am currently working on some small fixes to an Access system.
  11. E

    LostFocus Error

    Deleted... See next post
Back
Top Bottom