Search results

  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

    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...
  3. 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?
  4. H

    Update query syntax error (maybe ?)

    Private Sub cmdUpdate_Click() Update BR - DETAILS Set [BR-DETAILS].CostCentre = Me.txtCostCentre.Value End Sub I am getting an error that says sub or function not defined . It highlights the word Update. I wonder what I am doing wrong. Moses
  5. H

    Delete selected item from list box

    I am trying to write a piece of code that works on button click and deletes a selected row from the Table . Not sure how I can reference the entire row. ID is the primary key in the table . Any ideas ?
  6. H

    Combo Box value / Text

    Hi , I have a combo box with 2 columns . One has designation and one for salary level . When I try to insert the designation into database it just puts the index value ..ie 1 ,2 ,3, 4,,,, of the item into the database not the designation. Jr Analyst 50k Sr Analyst 60k Manager 100k Sr. Manager...
  7. H

    List Box column sequence in incorrect order

    When I assign the row source property via code or within properties box for a List Box...the order of the columns is not what I went it to be .Any ideas how to achieve the exact sequence of columns need . please help. Thanks Moses
  8. H

    "Hello World";

    New here . been using ms access for a while . one problem is driving me nuts though.
Top Bottom