Recent content by Karja

Yes, I got your point. I thought it would be nice to work with his code and just let him know. The reason why the data is in an array is dat many calculations are made with it which were already written in VBA. Now I am working on storing the data. This the story. No higher goals of what soever...

Thanks for your answer and effort. Your suggestion works fine but is not any faster. I've done some rewriting as the function you're supplying might come in handy. Here the altered code which makes it more costumizable. Kind regards, Karja Public Sub insertArrayIntoTable(myArray() As Variant...

Goodmorning, I've got a 2d-array with about 1000 rows and 5 columns, now I want to write this into the database. Now I just have a loop through the Array and write each line seperately to the database. for x=1 to ubound(array) rs.adddnew rs![Field1] = array(x,1) rs![Field2] = array(x,2)...

What about a DISTINCT? SELECT DISTINCT Name, Id, Code FROM yourTable

dhookom, yes now I've tried your initial suggestion. First I was not completely sure what you meant. It WORKS! Thank you all!

All thanks for your answer. When I sort on the subquery or iif([TypeSubCode] Like '161*', 0, 1) I get a syntax error. PHV, what do you mean by "In fact you may sort on the ordinal position of the column". I am afraid I do not understand it. Regards, Karja

Goodmorning, I've got a query where some fields are the result of a subquery. The query that causes me trouble is: SQLs = "SELECT SecurityCode, Holding, iif([TypeSubCode] Like '161*', 0, 1) As TypeOption, " & _ "(SELECT Value FROM G_MarketData_BB WHERE G_MarketData_GP.Bloomberg =...

Thanks for your answer, but I guess this not exactly what I am looking for. I solved the problem by making a query with subqueries for the field I need from the 2nd table. Cheers!

Goodmorning. I've have a question about building a query. Basically I have two simple tables: tbl_Securities ID Name tbl_BloombergInfo ID ID_Security (foreignKey) TypeOfData Value The first table consist of all kinds of securitycodes (stocks, bonds, options, cash) etc. etc. The second table...

Thanks for the link. I have discovered that it has to do with the Citrix environment we are using over here. If Access crashes or something like that (infinite loop) or you open accidentially the access application for the second time while the other is open, then you get the above mention...

Hello. I finally managed to finish the job. Below the working code, just to properly close this thread. Thanks for the help! 'Gekoppelde restricties SQLa = "SELECT M_Restrictions.ID, M_Restrictions.Code, M_Restrictions.Description, M_Restrictions.NumberOfVariables " & _ "FROM...

Thanks again. Not a bad idea but I should add that as it is a many-to-many relationship. I do not want to let the listbox populated with doubles or triples etc. Therefore I must include a DISTINCT G_Restrictions.Id. I will try Wednesday to re-write the queries as I think I must start with...

Thanks for your answer HarleyQuinn. You centainly got a point there. Now the query works (which it did not before) but it returns exactly the same values as SQLa (which I did not alter). I've not got a clue why this is happening? Do you? 'Niet-gekoppelde restricties subSQL = "SELECT...

Hello there, I am building an Access application to store information of Investments Funds and their Restrictions. There is more than one Fund and more than one Restriction. Each Fund can have multiple restrictions and each restriction can be attached to more than one Fund. So I created the...

Goodmorning! I was working on my database & VBA and saved my work. After that I was not able to enter the .mdb file again. The system prompts me: N:\.....\Administration.mdb The parameter is incorrect I just cannot open my Database. We are working in a Citrix environment. Access2003 / Windows...