Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by smayshar

  1. smayshar

    Design table and query structure

    I was requested to build a form for the assingment of monthly work shifts. Both the workers and shifts are flexible per month. I need the form column header to be the worker, the row header to be the shifts and the values in the "table" to be a text filled by the user. I built a table that is...
  2. smayshar

    vba in power point

    Im familiar with VBA in ACCESS. I would like to write a code for POWERPOINT presentation event on_open and on_close. I managed to open the VBA window in powerpoint but I dont know how to reference this code to the events. Thanks
  3. smayshar

    open a report from continues form

    I have several continues forms and one general toolbar for all these forms that contain ms filter , a-z sorting ... each one of the forms have a print button that opens a report. how can i open the report with the same sorting that the user chose on the form ? the filter works fine with the...
  4. smayshar

    unbound checkbox on continuous Form

    Thanks mate, That was my question , how to handle unbound checkbox, because I want to change only the front application.
  5. smayshar

    unbound checkbox on continuous Form

    Hello, On a continuous Form, I put an unbound checkbox, and in the form footer I have a buttom that should print all the ticked records. How can I tick an individualy box, with out having them all ticked ? thanks
  6. smayshar

    short time addition

    any sugestions how to summerise short time ?
  7. smayshar

    short time addition

    thanks for the fast reply PHV I tried to put the sql statement in a query but was not accepted by the jet syntax error MichaelRed what if it is unknown amount af values ?
  8. smayshar

    short time addition

    I have a table with a short time fild that indicate how many hh and nn some thing was on what will be the sql to add a long list of this values ? like: 01:50 10:20 02:30 ----- 14:40 thaks
  9. smayshar

    priority on one criteria

    I had to use( where T.ID=I.ID) only one id needed thenks again
  10. smayshar

    priority on one criteria

    thenks alot worked perfect
  11. smayshar

    priority on one criteria

    Hello friends, I have a table with fields: clientID, enterDate ... What will be my sql first find a clientID's record then the latest date from those records thenk
  12. smayshar

    create a keyboard hook

    How do I create a keyboard hook that would reject the prnt scrn key??? thenks
  13. smayshar

    control keys on the keyboard

    I have a powerpoint presentation,wich I would like to lock, Is there an option to prevent the print screen key to oparate ??
  14. smayshar

    error in loading DLL

    Hello all While trying to create new access database (using accessXP) this error appear "error in loading DLL" ???
  15. smayshar

    records nevidation on sub form

    Thenks Frink, In this case the main form is just for background and nice title the 2 subforms are individual with no logic connction There are some options for the user to choose from and by this I would like to open the subforms record (make any sence ?)

Part and Inventory Search

Back
Top