Recent content by MrStar

Hi MajP Actually I haven't the code you suggested because it is written to Access databases, and I don't think it will do for Excel VBA references. The way the Access code is doing the reference is though what I was searching for but for Excel. Have you tried this in Excel ?

Thanks for the tip, but it dosn't solve my problem

Hi I have about 80 Excel workbooks which all uses the same Excel addin with shared vba code. So each of the workbooks has a reference to this x.xlam library. The workbooks are used by employes during the day, and therefore I can't change anything in those or in the code library. I need to have...

Normally there is no meaning i storing spaces, but in this case I'm coding agains a mainframe system, where spaces also has a special meaning. Therefore I need to store spaces. I can store spaces as "¤" or some other special character, and then convert it to spaceds before uploading to...

But in my application I need to store sometimes 5 spaces or 10 spaces. I want the user to key in the spaces thru a form.

I have a table with several memo fields. All defined with required = No and AllowZeroLength = Yes I can add 10 spaces to a memo field thru VBA, but if I then try to change the same field thru a form by adding one more space, I end up with a field containing Null. Can anybody tell me how I can...

I have tried to link the db2 tables directly in Access. The result was that Access started to download tabels into local tables. This is huge tables ( I stopped linking with 89 mb for the first of 25 tables). But perhaps I have done it wrong. I'm not so familier with linking through ODBC.

I'm sending a sql to IBM host DB2 from MS Access through ODBC. If I made an error in this SQL, I only got an error message 3146 from ODBC telling that ODBC call has failed. Is it possible to get the correct sqlcode from Host DB2 ? I have tried to use API call GetLastError, but it allways...

Thanks, I will try this forum instead.

I have tried the errors collection, but it dosn't give me anything.

This is part opf the code I use for sending my query to Host DB2. Set QueCV = dbs.CreateQueryDef("") With QueCV .Connect = "ODBC;DATABASE=" & f_DB2System & ";UID=" & _ f_UserId & ";PWD=" & _ f_Psword & ";DSN=" & f_DB2System .SQL = strSql .ODBCTimeout = 0...

Yes it is DB2 It is not any particular sql. I mean in genereal - how to retrieve sqlcode. If I have a date in wrong format I would like to get -181

I'm sending a sql to IBM host from MS Access through ODBC. If I made an error in this SQL, I only got at message telling that ODBC call has failed. (error number 3146) Is it possible to retrieve the sqlcode from Host ? I have tried to use API call GetLastError, but it allways gives me a zero...

Im trying to write some VBA code in Excel. It shall use an existing connection to host through IBM Personal Communication. I can get access to host, and I can send commands to host session. but when I close Excel, the program pcsvc.exe starts using 100% cpu. I cant figure out what the problem...

I will do that. Thanks