Recent content by dzelmej

I have one calendar control and two text boxes. I want to use calendar control to enter dates in these two fields. (date from, date to) how can I tell cal.ctrl with vba to enter date value in text box one, and then in text box 2. (I dont want to use popup calendar or two calendars in my form)...

Hi there! I have query that needs two dates to execute, so i made a form with one calendar control. my needs - 1. I need two selectors in one calendar control (is it possible?) in that case I dont need two calendar ctrl. for my between dates query. but if its not possible, i can live with that...

([id_reason]=11 And [forms]![form1]![check1]=-1)) OR ([id_reason]<>11 And ([forms]![form1]![check1]=0)) this is what I figured out, and it is simple and it works...

Im getting error message. In my case I want to apply filter to query (named form1_query), not to form. I have form1 with check1 and form1_query with field id_reason, so I think that query name should show up somewhere in code ??

Im not good with vba, I understund where I must enter that code, but how can I point that ApplyFilter to my query (form1_query)...

Hi, Im trying to build query that filters my recors by checkbox value in form. I have field id_reason with numeric values, my idea is that when checkbox1 = 1, id_reason is filtred by value 11, when checkbox1 = 0, id_reason <> 11. i tryed this formula as criteria in design grid...

I fixed it, the problem was that my linked table was showing corupt data, after update, random 2006 year records is gone.

im workin on it :) its hudge, so it takes time to extract some data, i have linked tables, it not so easy as it seams at the first moment :)

its getting frustrating. I cant solve this little problem with between dates, it just dont work, what am I doing wrong? :/

well, thats not working... it returns nothing and how can I convert those numbers back to dates? Off topic: why are u using coma insted of semicoln in your formula?

but day numbers in table is numbers, they never been dates. How can I format number in to "y"? :) I think that calendar must somehow give number value to query not formated date, but I dont know how to do it... Maybe Im wrong... [?]

Hi, and again I have a problem :) so, In Form I have two calendar controls, and two text boxses. Based on selected date, text boxes are showing day of the year (format(Date(),"y")). Query is based on table with records of days in year (numbers), so, when Im trying to sort Between two numbers...

screenshot with design mode is attached to my first post. (only diference is date format, now it is US) but there is nothing to see... as usual - Between value1 and value2

ok, I get it, but still, that doesnt solve the problem, it still returns random 2006 records. strange :( source table is linked from remote server, but that cant be the problem... so what else... "Between" doesnt work with dates? Or maybe i must use "#" some place? :confused:

my text box and dates in query are formated as Shortdate... and in prew. are shown corectly, so where can I find US date format, I cant change my local settings. is there any custom date format propreties that I dont know about? where can I change it?