Search results for query: *

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...

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'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...

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...

Does anybody know how I can pass a password containing " to FTP. Password like abcd"123. I got an error what ever I do I have the following ftp commands open www.website.dk user username abcd"123 dir .. ..

I need to search my VBA code for several different functions such as curdir(), instr() and so on. Does anybody know a way to to do it through some VBA code ? I could of course use the normal search dialog, but it can only take one word in a search. I guess I will have a table with all the...

I'm going to use the same footer layout on several reports. The fields in the footer is global variables which I move to fields on the report in the footers OnFormat event. I have tried to make a report with my my layout in the footer section, and then add this form as a subform on an other...

I would like to update DataManager from a Cobol program on an IBM Mainframe environment. I have no idea how to do it, but I know it is possible. Does anybody have an example of how it works (jcl as well) ?

I have an Access database with some queries in. I Word I have made a document that use mailmerge with a query in access. This works, but I can't find out how to only merge with one record using the .findRecord on DataSource. I have coded this: With ActiveDocument.MailMerge If...

I have a form with a subform. The main form include only one input field, and the subform all the datafields. The data in the subform is based on a query with a 'like' statement. The content of the 'like' is the word entered on the main form. My problem is that I want to make another 'like'...

I often use the display statement to show a fields name and value on SYSOUT, if one of my programs have to report an error/information message to the programmer. If it's a copybook with many fields it's a lot of statements like DISPLAY 'FIELD-XX = ' FIELD-XX DISPLAY 'FIELD-YY = ' FIELD-YY In...

Hi I have written the following script to activate the dialog for the display settings: Dim shl Set shl = CreateObject("Shell.Application") shl.ControlPanelItem cstr("desk.cpl") set shl = nothing Does anybody know how I can change the resolution to 800*600 ? I'm quiet new...

Is it possible to change the screen resolution to 800*600 using VBscript. My laptop is running 1400*1050 but every time my son will play some of his games, I have to change te resolution to 800*600. It would be easier if he just have to click on an icon on the desktop. Any suggestions ?

Can anybody tell me how I can update the fields in "BuiltInDocumentProperties" in a Word document? I would like to put a name in the Author field and som comments and some keywords. I can read the information, but I can't figure out how to update the fields. Regards

Does anybody know how I can read through all the members a PDS, and retreive then membername and some information from each member ? An example with JCL would be nice. I have coded Cobol for about 20 years, but newer managed to figure out how to do the above. I have always found an other...

Can anybody tell me how I can make an option group on a form to contain from 1 to n radio buttons based on input from a table. In some cases I need two buttons, in other cases 8 buttons and so on. I will first know, when I read data from the table the form is based on.

I have an application which is split i two. A coding part and a datapart. I have done this because I then can maintain the code without disturbing the users. The users are placed at different places and they access the datapart througt a dial-up line which is very slow. Therefore I want to make...

Hi Does anybody know how I from VBA can active an signatur in a mail i Outlook ? From my VBA code I create a new mail with some information, and then I want to use the feature in Outlook which can include a standard message at the end of the mail. But I can't figure out how to do it.

Does anybody know how I get the full path to the Currentdb. If I use currentdb.name I get the old DOS format which can't hold more than 8 cahracters per directory. If it ios longer is has a ~ in the name.