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!

Search results for query: *

  • Users: smayshar
  • Content: Threads
  • Order by date
  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

    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
  5. 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
  6. 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
  7. smayshar

    create a keyboard hook

    How do I create a keyboard hook that would reject the prnt scrn key??? thenks
  8. 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 ??
  9. smayshar

    error in loading DLL

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

    records nevidation on sub form

    Hi, I have unbound main form with 2 bound sub forms. On the load of the main form I want to specificy the subforms record by the open args of the main form (I saw similar threads, I manage to get to the subform but it seems to be close for nevigation between the records) thenks
  11. smayshar

    Append query to duplicate 1 record

    I have a table with a field which is primery key (no duplicate), data type = number. I use this field as the records ID , insted of AutoNumber. My question is : Can I run Append Query to add one record ? how do increase the number of this field by one ?
  12. smayshar

    add month to date

    hello, I want to add 26 month to a given date how do I receive the correct date result thanks
  13. smayshar

    bring to front the report

    My reports have ToolBar, when I open a report from a modal form it hides behind the form. I tried to make the report popup, then it came to front but lost the tollBar. How can I bring it to front without losing the ToolBar ?
  14. smayshar

    changing font size,color,bold

    hi, I have a text box bound to a memo field, and a bottum that opens a report bound to the same table Is there an option, like in MS word, to let the user choose the font propertis: size, color, bold ... that will be on the report ???
  15. smayshar

    how to print background in word doc

    hello , I am trying to print a word doc with a picure as a background but its print it without the picure how can I print it like I see it in the screen ??? sela
  16. smayshar

    how do i pass date to a query criteria ?

    I have a field in a form that the user can enter a date I would like to pass this date to a criteria of a report so I will see only these dates records I have somthing similar that I use between[forms]![fName]![fieldName]and [forms]![fName]![fieldName] when I'm trying to make a criteria of exact...
  17. smayshar

    report background

    Hello I have a report wich using the reportHeader,PageHeader detail(contain subreport),page footer, reportfooter I would like to make backround from jpg file to cover the whole page (behind all the segments )???
  18. smayshar

    how to open a file

    hello, I have a Continuous Form that has a string fild which the user put in pathes(locations) of files that he wants to open on click what will be the code to open the file ?
  19. smayshar

    I am working with a few users, each

    I am working with a few users, each has his own FE mde linked to one BE . how can I open a notice (form) in one user after another user entered some relevant data thanks for any help
  20. smayshar

    filter and sorting

    I have a continuous form with a toolbar for sorting and/or filtering the records, and a command button than open a report i would like that the report will carry the same sorting and filter like the user choose in the form i treid : DoCmd.OpenReport "rName", acViewPreview, , Me.Filter...

Part and Inventory Search

Back
Top