Search results

Hy, can anyone point me how to build web service based on existing wsdl schema?

Hi, I manage to solve it with using : "Select distinctrow" instead of just "Select" Thanks :))

Hi, It's not working, gives me an error: " You tried to execute query that does not include the specified expresion 'account' as part of an aggregate function"

Hi, I have table consisting next rows: account1 value1 date1 account2 value1 date1 account3 value 1 date 1 account1 value2 date2 account2 value2 date2 account3 value 2 date 2 account1 value3 date3 account2 value3 date3 account3 value 3 date 3 How to get average values for each account (...

Thanks, but still receive error: Run-time error '3075': Syntax error in date in query expression '#07.12.2011'.

Hy, I have a table having one date field formatted as short date "15.12.2011", and on a form text box formatted as short date format. When I click on text box calendar appears and I choose proper date, but when I want to update date in table via query it returns error. My query looks like...

Hi, stupid me, it is working :)) i was missed one bracket in query, I just saw it :) Thanks once again

Hi, the sql is same as in example above: Update bilansuspjeha set OPENING_BALANCE = "-" & left([OPENING_BALANCE],len([OPENING_BALANCE])-1) where right([OPENING_BALANCE],1)="-"

Hi, Thanks :) but when I try it gives me error "wrong number of arguments.."

Hi, I have table with imported negative sign on right side, like 23234,45- How to switch minus to left, to have -23234,45?

Thanks :)) I have to adopted it, but it's great. Thanks once more

Hi, here is db example. I have two tables bilansuspjeha and kategorija. Into kategorija I insert data from bilansuspjeha with parts of the "nazivpuni" from bilansuspjeha. Query insert into kategorija is adapted based on your suggestion

Thanks :)) tried but it same thing-same error, I also already try it before, but result is same :)

Hi, here is query which I run from VBA: INSERT INTO kategorija ( idbu, konto, naziv, katBilansaUspjeha, Industrycode, CA_Referent, katBilansaStanja, sektor ) SELECT id, konto, nazivpuni, mid(nazivpuni,8,5), mid(nazivpuni,37,4), mid(nazivpuni,14,4), mid(nazivpuni,22,5),(Split([nazivpuni], ".")(7)...

Hi , thanks for support. I've tried with query and result was :) "Invalid use of '.' '!',or ()...etc" I have found your function "getpart "but not sure how to use it ?

Hi, I have a column (char type) consisting data like: PL.EUR.51001.2003.RS.21059.RS.1605.T.1500 What I want is to based on value above to make insert into new column, but only data starting from 7th dot . I have tried with mid function but the problem is that length of characters in column is...

Hi, thanks very much :), but it is same. I would probably solve it to another way. The thing is that in column2 and column3 exist numeric data shown as string. Bad thing as for some records exist values with dots and brackets (don't ask why :), So I will probably remove them, convert field type...

Hi, I have table where have columns with integer and character types of value: column1 (int), column2(char),column3(char)...etc On related form I have those 3 combo boxes and subform showing result based on values from combo boxes, and subform record source is like: select...

Thanks :)))))))) You saved me :))) It'sworking and it is excelent! Thanks once again

Hi, first thanks for your support. From two codes you gave me first one is working but it takes hours to update table. Second one is extremely fast comparing to first,but not doing concatenation with condition settings like in code, if I change the sign < >, or desc It does do update but in...