Recent content by broj1

@Remou the second suggestion is exectly what i am looking for Mainform OrderNo: 55 Costumer: SomeGuy -------------------------------------- bound Subform: car car1 car2 car3 motorbikes motor1 motor2 what kind of a "fancy conditional formatting"...

thanks for fast reply Remou! Yes, you are correct, but the subform itself shows you records only for induvidual group. I would like to how all groups and all products for each group in one subeform for one Order (linked by master and child): so, Mainform OrderNo: 55 Costumer: SomeGuy...

Hey; i got that, the reports are more flexible with this and that there is no function for sorting and grouping like there is one in reports. But is there a way around? To somehow simulate this in forms? Like, i have continious subform in which i would like to show products by category - like...

thx dhookom this comes to me a bit late ... but thanks for the effort, i will sure use it next time

well i did it manually ..... ufff it is so time wasting . if somebody finds the answer to this please let as know

thx for your replies ...you are great people! i've gone behind the back into a pocket. so i split into to sections weeks-with same weekNo and months and then sum each. well it did the job.

Help need it. I have a crosstab query. TRANSFORM Sum(Kontejner_sub.index_zahtevnosti_ctn) AS SumOfindex_zahtevnosti_ctn SELECT Kontejner_sub.index_zahtevnosti_ctn, Kontejner_sub.datum_zacetka, Projekt.prodajalec FROM (Kupec INNER JOIN Projekt ON Kupec.IdKupec = Projekt.IdKupec) INNER JOIN...

It is like this; i have a combo with value list 1-52 - represent the weekno. when user selects it in a textbox i need to return a month and a current year for this. couse i need to pull and sum the data (to check free capacty ) for choosen week and month. So far all looks ok. The problem is in...

thx for your reply. you have a point there. i didn't think about that. Function DateFromWeekNo(YearNo As Integer, weekno As Integer) Dim datDate As Date Dim temp As Date If IsMissing(YearNo) Then YearNo = Year(date) datDate = DateSerial(YearNo, 1, 1) + (weekno - 1) * 7 temp = datDate -...

I have numbers 1-52 in combobox when number selected i would like in other textbox to return month & (system)year I have tried lots of variation with datediff, dateadd, and on forums i can find just to return specific date with week day also...but i don't need that. any idea? thx

I would consider placing both a ProjectID and ContainerID field in the spare parts table. tblContainer would have a ProjectID. These "foreign" key fields could be blank. no it' can't be blank. have main form. On the main form i have 1. Listbox (Com_list) with all containers for that...

hi fellaz, i have been of for few days. Thanks for your replays. You are both right. I will try to work around this, but may need additional help later. I will let you know how it goes. thx

yes, sorry i wasn't clear! the code for dblcl event works, but my original idea is when new record is created, all fields are blank, couse all get values after txtbox1 is filled(with date picked from calendar) other let.us.say txtbox2 then should get defaullt value based on what is in txtbox1 --...

GingerR yes, this looks like a nice solution, but what about then when user inputs the date with the calendar ...whatever dates he inputs it has to be -2 days? What should i do then?

no, it doesn't allow me to put comma's, so i assume that semi-colons are fine (i don't get any error) it just don't display - nothing