Recent content by vojinb

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 ?