Search results

  1. S

    Sharing a database

    I want different users to be able to open my database at the same time. My database is on our network server. I thought that by splitting the db into a front end with forms and queries and a back end with tables would do the trick but it doesn't. I set my advanced properites under the tools menu...
  2. S

    Option Group control

    Does anyone know of a function or method that I could use to undo or de-select the user's selection if a certain condition is true using an option group control? I tried using the lock method but it only allows me to Lock the whole control and I don't want to do that. I only want to lock out one...
  3. S

    code that evaluates a control source

    I have a form with a txt box called length_stay whose control source is: =DateDiff("d",[DOA],[DOD])+1 where DOA and DOD refer to date fields on the form. this part works fine. now, if the number that is returned is <=3 then I want another field on this form called LBPATH to =7. I went to the...
  4. S

    Date Calculations

    I would like to subtract two date fields and use the difference for the value of another field in my table... Example: I have one table with 3 different fields: DOD, DOA, and LOS. I want to subtract DOA from DOD and use the difference to populate the LOS field... I have a form where the user...
Back
Top Bottom