Search results

there are different users....for each user i will be storing these information on monthly basis i have one main form from where user will select the month. this will trigger a new form , where based on the selected month, number of rows will be shown (28/29/30/31).. each row is basically...

Hello i have a sub form, to which i am assigning (control source) a datasheet form, - i want to some columns to be of different back color, i am trying to put some back color, it shows in design mode but doesnot appear in datasheet any help !!

your questions are good... tableA has a ID's which falls under a dept. since tableB (Scrap details) has lot of other data..so i have kept it separate form TableA solutions is SELECT TableA.Dept, Round(Sum(IIf([temp_TableB].[Type]='general',1,0))/Count(*)*100,2) AS General Rate] FROM TableA...

i m using query SELECT TableA.Dept, Round(Sum(IIf([TableB].[Type]='general',1,0))/Count(*)*100,2) AS General Rate] FROM TableA LEFT JOIN TableB ON TableA.ID = TableB.ID WHERE ((TableA.Dept) Like 'D1' Or (TableA.Dept) Like 'D2' Or (TableA.Dept) Like 'D3') AND ((TableB.Date) Between...

i have two table A , table B table A has ID(primary key), dept, .... table B has ID(Primary Key), type, date.... let say i have dept as D1, D2, D3 in 10, 20 , 30 numbers in table A ie count(D1) is 10.... table B might have a certain record corresponding to ID in table A let say it has 1...

i have a form which displays 2 charts, i am able to export them to word document but i donot know how to paste them one after the other. currently they get printed one over the other. here is the code : Private Sub cmd_Print_Click() Dim MyChartObj As Object Dim MyLineObj As Object Set...

i have continuous form having a source as table A. when i click a displayed field value from the table A in this form, a pop form is opened (by passing the Primary key) which displays all the details of that record from the same table A. Now i have a one more button on this popup form , which...

i will not use self join but will use where condition....

got it thanks

yes i know how to make query.. but my doubt is...i dont want to enter wrong data in this table i want to check this information at form level i.e before inserting in the table. through vba

problems : i dont know how to do it i have a table where i am storing all the reservations by a material ie. material_name dept_name from date to date eg: MAT1------DeptA ------ 12/06/2015 to 15/06/2015 but i dont want any user to book a reservation in any department between these dates for...

i have 5 departments DeptA,DeptB,DeptC,DeptC,DeptD,DeptE i have one material MAT1 now i have a form where i am setting some task, FROM date to TO date for the MAT1 in DeptA. after some days other user can also set FROM date to TO date for the MAT1 in DeptB. similarly other for other...

code works OK - if i pre assign a form to the subform sourceobject but is not when changing form allocated to subform dynamically through vba.

did that..no success.... conclusion works fine : when we set the SourceObject in the subform in design mode no success : when activated using button/click but something strange is happening like when form is maximized and i click button to do resize : nothing happens but when my form window...

ie what i am looking for..where to put the code....THEN

exactly...but where should i put the code i tried open , load, current of formname

i have a click event in mainform from where i assign subform Forms![MainForm]![SubFm].SourceObject = "formname" and in formname form_open event i am again calling resizing code i noticed !!! when i pre-assign formname in design mode to the subform and open the main form then everything comes...

yes it does, by the way the i tried something my subform was not assigned any sourceobject initially so i think it was not resizing it, so i assigned a dummy form to the subform at start and now it is getting re sized to the resolution. but on chaning the subform sourceobject it is not...

i have a mainform which has a subform. i am changing my subform dynamically using Me.objSubform.SourceObject = subformname i am using a resizing code suggested by ken getz in the form_open event of mainform on changing screen resolution everything in mainform changes nicely, but subform...

thanks for the quick reply...CJ