Search results for query: *

5

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

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...

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

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

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...

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...

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.

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

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

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...

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

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

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

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

Hi hoja! See and change the values of the advanced properties from 'tools' on the main menubar. use the help there if needed. Good luck CUOK

Thank you very much friends, I guess i'll came back to you! CUOK

Hi Friends! CONVERTING MS ACCESS 2000 TO SQL SERVER, from WHERE TO BEGIN? I used in my program the dao 3.6 system. thank in advance CUOK

Hi all. this works fine: (put it after DoCmd.GoToRecord , , acNewRec or active it other way.) Dim ctl As Control For Each ctl In Screen.ActiveForm If TypeOf ctl Is TextBox And ctl.Tag = "Somthing" Then ctl.SetFocus SendKeys "^" & Chr(34), True Next ctl this will bring the...

Thank u again billpower! ok i coukd not sleep till i checked it, here what i did: On MouseUp event of the Control "txtDetail" (the memo): txtgetmed = Me!txtDetail.SelText where txtgetmed is the ctlTextToSearch in my code it works fine! thank u and have a star for your help and let...