Recent content by HelpMoses76

  1. H

    Multi users environment - forced log out / reminders to log out

    Is it possible to 1) Find out which users are currently in the database ( which is on a shared drive) 2) Display a message to everyone at 315 pm each day to exit the database 3) Log users out after a certain amount of inactivity ? I do not know if this is even possible in ms access vba Thanks.
  2. H

    Detecting a value was deleted from ms access text box before entering value in Table

    fixed.. If IsNull(txtDescription.Value) Or _ Len(Nz(txtDescription.Value, vbNullString)) = 0 Or _ Len(txtDescription.Value & vbNullString) = 0 Then 'IsNullOrEmpty = True MsgBox "Description is empty" Exit Sub Else IsNullOrEmpty = False MsgBox "Description is not empty" End If
  3. H

    Detecting a value was deleted from ms access text box before entering value in Table

    fixed.. If IsNull(txtDescription.Value) Or _ Len(Nz(txtDescription.Value, vbNullString)) = 0 Or _ Len(txtDescription.Value & vbNullString) = 0 Then 'IsNullOrEmpty = True MsgBox "Description is empty" Exit Sub Else IsNullOrEmpty = False MsgBox "Description is not empty" End If
  4. H

    Detecting a value was deleted from ms access text box before entering value in Table

    I really do not know that . Thats why i am asking.
  5. H

    Detecting a value was deleted from ms access text box before entering value in Table

    Yes and how would I detect it- use what code to detect it - when I hit save button ?
  6. H

    Detecting a value was deleted from ms access text box before entering value in Table

    This is just to ensure that nothing gets missed . I work with an interesting set of people.
  7. H

    Detecting a value was deleted from ms access text box before entering value in Table

    Hello everyone I was looking to validate that all the text boxes were populated on the ms access form. The code should be able to detect if the value was entered and then deleted too . Any ideas ? I have tried using "" , " " (space between quotes),Null etc. No luck so far. Thanks for your...
  8. H

    Can I write MS Excel Code inside MS Access module ?

    Hi Can I actually write MS Excel Code inside an MS Access module and have the operations done on an Excel File specified in MS Access code?
  9. H

    Update query syntax error (maybe ?)

    This is the string that fixed it . strSQL = "UPDATE [BR-DETAILS] SET CostCentre = '" & Me.txtCostCentre & "' , AssetName = '" & Me.txtAsset & "' WHERE ([BR-DETAILS].ID) = " & Me.List248.Column(21) & " "
  10. H

    Update query syntax error (maybe ?)

    Thank you DBguy.
  11. H

    Update query syntax error (maybe ?)

    ID field ..which is in List248.column(21)
  12. H

    Update query syntax error (maybe ?)

    This fixed it . Than you for your help Gasman and CJ London. strSQL = "UPDATE [BR-DETAILS] SET CostCentre = '" & Me.txtCostCentre & "' , AssetName = '" & Me.txtAsset & "' WHERE ([BR-DETAILS].ID) = " & Me.List248.Column(21) & " "
  13. H

    Update query syntax error (maybe ?)

    no luck even after removing the quotes ;-(
  14. H

    Update query syntax error (maybe ?)

    No luck ;-(
  15. H

    Update query syntax error (maybe ?)

    Can I modify this to update it based on an auto number field ? This is what I tried . strSQL = "UPDATE [BR-DETAILS] SET CostCentre = '" & Me.txtCostCentre & "' , AssetName = '" & Me.txtAsset & "' WHERE ID = ' " & Me.List248.Column(21) & " ' " CurrentDb.Execute strSQL, dbFailOnError Get a...
See more
Top Bottom