Search results

i made them like this Left(Transfer;InStr(Transfer;"/")-1) Mid(Transfer;InStr(Transfer;"/")+1;IIf(InStr(Transfer;" ")>0;InStr(Transfer;" ")-InStr(Transfer;"/")-1;Len(Transfer))) IIf(InStr(Transfer;" ")>0;Mid(Transfer;InStr(Transfer;" ")+1;InStrRev(Transfer;"/")-InStr(Transfer;" ")-1);Null)...

i made modification of example kitayama send and it works. response from Cj_London came after that and i looked at it (always can learn something).

Hi, I am trying to make query that will filter range of records. how this is not with maximum and minimum i tried with between same like with date from to but that way i get only first and last not the records between record with docnumber 347 like in this example can...

thank you and there are always maximum four parts can be two or four parts. I tried yours too but two, three and four don't work

I never used split function before but i think it don't work in query right?

Hi, I have field [Transfer] (text field) like this for example 349/2016 79/2019 i want to get four parts like 349, 2016, 79 and 2019. i got first and can get the last too but how to get 2016 and 79. one more thing if field is only 349/2016 i need only 349 and 2016 so what i will get for part...

i took another approach. add go to new record and now is solved. thanks for all suggestions.

yes i have menu for differnet actions. i open form from a menu. i put code after opening form on load event is that what is wrong?

maybe i don't know to speak with terms. when i speak of a control i mean about combo boxes. yes combo boxes are used for searching but i use form first for entering data later when needed for searching. so it seems more convenient to me to open to filed ready for entering data. and i tried with...

i can work without changing anything, but i want to work with less clicking. maybe i wasnt clear enough i dont want to set focus on control but to field. cursor is by default on control no need to change that if i dont put it on field. and i need focus only on load (opening the form). why is...

that dont fix the problem. because it is split form combo boxes are in the form header and fields are in the detail. so with tab order are ordered combo boxes or fields depend where you are. in Continuous form default cursor position is in the first field.

Hi, I have split form. On opening default cursor position is on the first combo box in form header. Can default cursor position be in the first field instead. thanks

the way i tried before did not accept it and i tried many times. this time with order by n and deleting the ";" accept it. i glad it is solved. if i could find mistake i wouldn't post here. i learned this time and i wont make this mistake twice.

ok i made it. deleted ";" and works now. thanks

it is made that way and works independently but not in union query.

it is checked. this union query was made by combining two select queries. both have same sorting and work with them. in union can be only one order by and not as the last line. select query above union is the first one and second select query is below union.

tried and didn't work if my syntax was right: ORDER BY 2,3,4,5

do not accept that. report mistake.

can not be the last line. this query is made from two select queries. first before union and second after that.

SELECT Delovodnik.DelovodnikID, Left([Ознака],4) AS Proba1, DatePart("yyyy",[Датум]) AS ГодинаПребарување1, Delovodnik.ОрганизационаЕдиница, Delovodnik.ОсновенБрој, Delovodnik.Подброеви, Delovodnik.Пренос, Delovodnik.Предмет, Delovodnik.ДатумНаПриемот...