Search results

New Idea... I need to add in one column all the DateIncome and DateExpences.... Is it possible from the two tables???

I did some test and show that : qtrIncome has : YEAR 2008, 2009, 2010, 2011 qtrExpences has :YEAR_____, 2009, 2010,_____ Same values only two years... But i think i can make a query first with Values which are the same in both crosstabs... Example Months... 1,2,3,4,5,6,7,8,9,10,11,12 From...

I will create two cross tab queries... qtrIncome and qtrExpences... Then i will create a query between this two... I will make a relationship between YEAR.. Is it going to work??

Found 12months display Month: DatePart("m";[DateIncome]) In (1;2;3;4;5;6;7;8;9;10;11;12) Thxs i remove Val() I am so happy!!! The Tricky part now... Is it possible to add from a second table like the tblIncome, the tblExpences??? This two tables are not link together... tblExpences...

Found how to replace empty field to null... Code: Price: Val(Nz(Sum([Income]);0)) Now i need to show all 12months and now only the once that has data...

Thxs... my query: Month: Format([DateIncome];"mm") GroupBy RowHeading Year: Format([DateIncome];"yyyy") GroupBy ColumnHeading Price: sum([Income]) expression Value It is working fine... But if it shows only the months that there is data... Not all months... from 01, 02 ... 12 And is it...

Thank you very much for the reply.. Is it possible to explain more in details or show it.

Hi, I have a table : tblIncome - IncomeID : key, autonumber - DateIncome : date, format dd/mm/yyyy - Income : number I want to create a query that will look like this the result: Month1, Month2, ..., Month12, Year 1200 ***, 1500 ***, ..., 1350 *****, 2009 1400 ***, 1250 ***, ..., 1700 *****...

Found it... Pass openArg to new form stLinkCriteria = Me.TriminaID In Open Filter Private Sub Form_Open(Cancel As Integer) frmSubTrimina.Form.Filter = "[TriminaID]=" & Me.OpenArgs frmSubTrimina.Form.FilterOn = True End Sub

I change the code and insert recordset... Code: Option Compare Database Private Sub Trimina_DblClick(Cancel As Integer) Dim stLinkCriteria As String stLinkCriteria = "Forms!frmSubTriminaMain!frmSubTrimina.Form.TriminaID=" & Me.TriminaID If Me.YesNo = 0 Then AddLinesDAO Me.YesNo = "1"...

Here is my Test DB... In this one everything works fine... Open the Form(tblTrimina) and you will see TriminaID, YesNo, Trimina... Once you doubleClick Trimina it will check : If YesNo is False and it will open Form(tblSunolo), add 10 new rows where TriminaID is the same from the first Form...

Thank you very much for your reply. I don't know how to do it with recordset. I manage to it with i and next i and it works perfect. Simple and easy. My problem is that i can't link to subform... CustomersID

Hi, I have a form(frmMain) with no controls. All empty. Inside the form, i have a sub form(frmSub). I am trying to open from another form(frmCustomers) the frmMain... Easy part... The hard one is to open with a WhereCondition for the frmSub according to the previous form. I want to doubleclik...

i have a couple of images in my form. i want to move mouse over and a ballon to show me a message. something like when you debug code and it show details. thxs

is it possible to place a code on start up form to check which language (keyboard) is the default? And to change it to the one i want. thxs

hi i want to make an appointment form and to look like this.

i have a db with many forms. i want to set focus or better always on top the last open form example: the forms are open like this mainform 2form 3form 4form i want to set focus or always on top 4form if 4form close the next form is 3form if 3form...

hi i want to make a module which it will run when my db start and it will disable some keys . I want to disble them as long my db is open. i read some post and found code: Select Case KeyCode Case vbKeyF1 KeyCode = "" Case vbKeyF2 KeyCode = ""...

help with this one!!!

DoCmd.OpenForm "customers", , , "[customers_date_visit] >= #" & Format(StartDate, "mm / dd / yyyy") & "#" & "And" & "[customers_date_visit] < #" & Format(EndDate , "mm / dd / yyyy") & "#" Ok!!!