Recent content by miki

hello all. how i can display row num in Report, or insert something like AutoNumber in Query, or any another way or solution be accepted in gladness. thanks.

To RV and JohnT Many thanks for your help

Select *, DateDiff ("yyyy", [Date_Employed] , Now()) as sum_years from my_TBL "yyyy" or "y" i not sure . [This message has been edited by miki (edited 02-26-2002).]

if i understand you well! SELECT DISTINCTROW Format$([My_TBL].[My_date], 'mmmm yyyy') AS [date By Month], Sum([My_TBL].[money]) AS [total numbers of customers paying] FROM My_TBL GROUP BY Year([My_TBL].[My_date])*12 + DatePart('m',[My_TBL].[My_date]) -1, Format$([My_TBL].[My_date], 'mmmm...

Hello. I sorry about my poor english ;( Thanks Liv Manto. but it's not work,i need more details or syntax sample. i need in one row this Fields: products.ID_product products.product_Name products.product_description orders.id_order orders.Date_order orders.quantity if not have order for...

Hello. I sorry about my poor english ;( I have 2 tables : TBL1: name = products Field1: ID_product Field2: product_Name Field3: product_description and so on TBL1: name = orders Field1: ID_product Field2: id_order Field3: Date_order Field3: quantity and so on The relationship between tables...

Thank you jwindon, but maybe there are different way. [This message has been edited by miki (edited 02-24-2002).]

Hello. I sorry about my poor english ;( I have a report when it's open the user can select which field order the report, my problem is the all field it's ID and not [A-Z] how i can order report by [A-Z]. (i use combo to see [A-Z]and not id by hide column) Thanks.

Hi All... How can I Add and Remove item from Combo box by code,When the RowSourceType ="Value List" ? thanks.

Hi All... How can I Add and Remove item from Combo box by code,When the RowSourceType ="Value List" ? thanks.

Dim strFilter As String strFilter = "[Surname] = '" & Me.srcSurname & "' AND [City] = '" & Me.srcCity & "'" DoCmd.ApplyFilter , strFilter

How i can select item in Combo Box by code? thanks!!!

How can I disable the PgUp and PgDown keys so the record will not change(next or previous) while pressing this keys, but not disable this keys entirely,to move the scrollbar will possible (in large and long form) thanks.

How I can avoid the record transition when I use PgUp and PgDown keys. (I have larg and long form and i need use PgUp and PgDown keys to move up and down but avoid the record transition to next or previous) thanks. [This message has been edited by miki (edited 11-04-2001).]

how i can close my code, but i want to use my project? thancks.