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 Wanet Telecoms Ltd 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 cuok

  1. cuok

    VBA Date/Time format setting

    RoyVidar , U R REALY REALY INSTRUCTOR!! YOUR POST WAS VERY VALUEABL TO ME, THANKS CUOK
  2. cuok

    display only the last record

    Hi steve101! i got you about the Dlast , you right! here is a quote from zxmax post: "Now when i print a report, i have only one field for the "bloodPressure" where i want to show only [b] the last record[\b], i don't want to show all the previous record, " maybe i didnt undrestood corectly...
  3. cuok

    My "create MDE file" in >Tools is freezed,why?

    HI! Before creating mde file you must compile you mdb. in "Debug" menu choose the first SubMenu: Compile ...(your mdb name will apear there) correct if needed all bugs then i hope you can go to next step: "Make Mde File..." good lock! CUOK
  4. cuok

    display only the last record

    Hi Steve101! u r geting the NotNull "BloodPressure" regardingless the date, what if the patient has no "BloodPressure" for the LAST RECORD as zxmax wrote in his thread? pls. correct me if i'm missing somthing. CUOK
  5. cuok

    display only the last record

    hi First i hope you are note using "Date" as name of date- field in your table. Seconed: 2 fields?? No IdPatient???? maybe i dont understand you. build a query: SELECT TOP 1 YourTbl.bloodPressure, YourTbl.DateCheck, FROM YourTbl ORDER BY YourTbl.DateCheck DESC; this will give you the date...
  6. cuok

    Text color change on Mouseover

    Hi DeanWilliams and all! I qoute: "Call this in On Mouse Move for any visible sections (Detail, FormHeader, FormFooter, Form)" how you CALL the sub, I TRIED IT AS I UNDERSTOOD YOU and the erroe i got is: "Argument not optional" Private Sub Label1486_MouseMove(Button As...
  7. cuok

    Output every null-field for each table-column ...

    thank you for the quick reply, quehey. i'll try it tommorow morning (it is now 00:30 here...) and let you know how it went. thx again, CUOK.
  8. cuok

    Output every null-field for each table-column ...

    HI FRIENDS! Can somebody help\guide me to find the way how to write a query which [b]outputs every null-field for each table-column for each table-row for selected date[\b] OR Is there a function for fields that equivalent to "for each control.." THAMKS IN ADVANCE CUOK
  9. cuok

    Pass a field name into recordset

    Good morning to you Tony ! its works great thank you very much!! CUOK
  10. cuok

    Pass a field name into recordset

    Hi friends. What wrong here: i m trying to pass a field name from table ("tipolim") into recordset, in aim to be able to use it with the format rcd!Field=ActiveControl.value assuming that the variable "ctl" in my strSql detremind correct and so all the query strSql here...
  11. cuok

    Error accessing file. Network connection lost.....

    Hi friends, is your MS ACCESS veresion updated to SP-3? TRY DO IT IF NOT. maybe somthing happens when u copied copying forms from 1 version to other CUOK
  12. cuok

    Is there a way to make the default toolbar invisible on startup?

    Hi mondoray' CommandBars("menu bar").Enabled = False CUOK
  13. cuok

    Error accessing file. Network connection lost.....

    Hi friends! i think here your solution(?): http://support.microsoft.com/default.aspx?scid=kb;en-us;304548&Product=acc CUOK
  14. cuok

    MenuBar

    Hi try this: to hide all the menu bar : CommandBars("menu bar").Enabled = False CUOK

Part and Inventory Search

Back
Top