Search results

  1. C

    How to display the result of a substraction of two box

    Hi All, I am trying to display the result of the difference between two boxes in a new unbound text box. Basically, I have a box called "Initial Downtime" --> display the system downtime Than another box called "uptime"--> display the time the system cam back up. I would like a third to...
  2. C

    ODBC connection

    ODBC Connecition Thank you guys for responding. Can you give me more details about the following: "Using DBEngine.RegisterDatabase". I have never heard of it. Thank you.
  3. C

    ODBC connection

    Hi Everybody! I am creating an Access database that will be used by multiple users. This database will be on the network and will be the front end of an oracle database connected to it via ODBC. Do I have to set up the ODBC to oracle only on the machine that hold the database on the network...
  4. C

    MS Access/ Oracle connections.

    Hello Guy, We use an Oracle base software called Trapeze and Microsoft Access sometime used as a front end to access the Trapeze oracle tables. Due to the possible dangers of allowing the users Access, Is there a way to block the users from changing the oracle tables and only be able in MS...
  5. C

    Users And Group Permissions

    You will have to use Access security with a custom workgroup and user permissions. I HAVE NEVER DONE THIS BEFORE. CAN YOU GIVE ME MORE DETAILS ABOUT IT? is the best way to protect the data but allow them to create and save custom queries an reports. But the user should never have access to the...
  6. C

    Users And Group Permissions

    We use an Oracle base software called Trapeze and Microsoft Access sometime used as a front hand to access the Trapeze oracle tables. Since a user has to be created in Oracle, with update, delete, read, write, append rights, for Trapeze to work correctly Is there a way for me (, even though the...
  7. C

    ODBC connection to Oracle.

    ODBC Connecition to Oracle via MS Access Thank you so much for your help. I think restriction to the Windows XP level would be the best way to go. I mean only allowing admin to setup an ODBC connection and no regular users. Thank again.
  8. C

    ODBC connection to Oracle.

    ODBC Connecition to Oracle via MS Access Yes, Trapeze uses its own internal userid to connect to the Oracle DB. Actually, each user has access from his/her workstation through a GUI interface. I am trying to set up some reports through MS Access, from each workstation. My concern is to...
  9. C

    ODBC connection to Oracle.

    Hello Guy, We use an Oracle base software called Trapeze and Microsoft Access sometime used as a front hand to access the Trapeze oracle tables. Due to the possible dangers of allowing the users Access, Is there a way to block the users access to Administrative Tools, to create ODBC...
  10. C

    Calculated Field

    Thank you so much. It worked. Took me sometime to get it clean (my spelling, etc) but it worked. I really appreciate your patience and your understanding. God bless.
  11. C

    Calculated Field

    Thanks again for replying. Attached is a word document with the exact names of the controls as they appear in the form design view. Thank you.
  12. C

    Calculated Field

    Thank you so much for replying so quickly. I appreciate your inputs, but if you don't mind, i need some more details. I am a newbie to VBA. You will need to use the AfterUpdate event of each of the controls on Question? What do I put in the afterupdate event of each control? All the...
  13. C

    Calculated Field

    Hello Guys, I am trying to do the following in a form. 1) (Travel hours + work hours) * dollarperhr to get the "Total" bill to a customer. 2) The results will be put in a field "TotalDollars" that is a part of a table. Please help. I tried to put an event (on change) on the...
  14. C

    Calculated Field

    Hello Guys, I am trying to do the following in a form. 1) (Travel hours + work hours) * dollarperhr to get the "Total" bill to a customer. 2) The results will be put in a field "TotalDollars" that is a part of a table. Please help. I tried to put an event (on change) on the...
Back
Top Bottom