Search results for query: *

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

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! 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 friends! I'm using this routine to search text typed into 'txtgetmed' TextBox and maybe appear in 'txtDetail' TextBox. its works fine for first search. What i need is an idea how to continue the search in 'txtDetail' from this 'found'. here the code: Private Sub GoSearch_Click() Dim...

Hi friends! DatePart("yyyy",[A].[DateCheck])=DatePart("yyyy",Date()) I know that this is the criteria to get 2003 which is this year, but how i can get the past year 2002? down this post is the whole query i want to use to get the records if present in at least one time in...

Hi all! i would appricate for any help! I have 4 fields in table: F1, F2 F3 and TotalF each of them can valued by: "S" or "T" if 2 or 3 of them got "S" then TotalF=2 otherwise TotalF=1. how can i do it? thanks in advance CUOK

Hi friends, I'll appreciate any help and thanks in advance!! My problem is to retrieve the latest value from a column. I have a table with thos fields: ID (text) DateCheck (dd/mm/yy format) TestA (integer) TestB (integer) TestC (integer) …… The user must enter the DateCheck but must not...

Hi friends! I need to use a query (bellow and bolded) as subQuery but i dont know how! i'm using a query named 'DbMax' and this shell be one of its columns. 'DbMax' has one table with same PK (id) named Tbl_Patients. EXAMPLE of another column in DbMax that works fine: LastBmiSds: (select...

Hi friends! How can I get the Active SubForm Name when it is NOT IN focus , LETS SAY I NEED THE OPOSITE OF "Parent" COMMAND ! thank to any help CUOK

Hi friends! how can i get the date of next Momday from any day in this week ? I need to get next Monday (by function, sql...) in TextBox every time i opens the form which contains in another TextBox the day of today (date() - short date). if today date is 08/18/03 (it is Monday) i need to get...

Hi friends! I have a table with many records, ID is “Duplicates ok” So I have many records for each ID. What I’ tried to do -with no success- was to make a query that Searches the max value of a specific field, for each ID, than Gives one record for each ID TableORG ID fld1 fld2 fldMAX...

Hi All! Please help to change the bold row (down) that opens a table to open a query instead of a table Dim db As Database Dim rs As DAO.Recordset Set db = CurrentDb() Set rs = db.OpenRecordset("tblName") With rs .MoveFirst Do Until rs.EOF If ((Me.DateIn >...

Hi I will thank for any help with this: I have three comboBoxes with same values (from same table) Do you know any way or idea to not show a value already choose in one of the other ComboBoxes? Thanks in advance CUOK

Hi All! HERE MY CODE THAN MY PROBLEM: Private Sub List32_Click() Dim frm As Form, ctl, ct As Control Dim varItm As Variant, intI As Integer, ListD As Integer Dim fldzmany As String Set frm = Me Set ctl = frm!List32 For Each varItm In...

Hi All! I have to collect different fields that laying on NON identically structured tables ( BUT All tables have THE SAME "ID" and "DtaeCheck" as PK ) and make of them one table (I already made of those fields). What I'm doing now –in aim to fill this table- is...

I have to collect 109 different fields (laying on NONidentically structured tables) from about 28 tables - to one table (already I made of those fields). What I'm doing now –in aim to fill this table- is by putting a code behind each one of those 109 fields on "AfterUpdat" event to...

Hi friends! I have this query that works fine. ======== Query =================================== SQL = "SELECT ComplicationsRespiratory.Id, ComplicationsRespiratory.HistoryActiveRespProb, ComplicationsRespiratory.DateCheck FROM ComplicationsRespiratory WHERE...

Hi fiends! I have this query that works fine. ======== Query =================================== SQL = "SELECT ComplicationsRespiratory.Id, ComplicationsRespiratory.HistoryActiveRespProb, ComplicationsRespiratory.DateCheck FROM ComplicationsRespiratory WHERE...

Thanks in advance for any help: Delete vbNewLine(s) from MemoField and keep the MemoField format – how? The MemoField looks like this: INDIA vbNewLine vbNewLine USA AFGANISTAN ISRAEL vbNewLine BELGIUM Of course instead of “vbNewLine” there is empty row. What I need is: INDIA USA...

We decided to put this Q. in this forum too (beside “Modules forum”) because the unclear subject we put there and we hope it’s not making problems. Maybe this mission is not possible but it is a bit frustrating us so we must ask first: My wife and me are working on 2 computers with same...