Search results for query: *

I am running an ODBC query from MS Excel agains AS400. Select B3GLAC, B2TRDT, B1VND#, B2DESC, B1VNAM, B3TITM+B3TFGT+B3TTAX-B3TDSC as Test, B1PON#, B1INV#, B3REF#, B3GLPX FROM YADPOS2.b3billl1 INNER JOIN YADPOS2.b2billl3 on B3REF# = B2REF# and B3SEQ#=B2SEQ# INNER JOIN YADPOS2.b1billl0 on B2REF#...

I have 2 buttons and a check box on my worksheet. When I print they "automagically" move to the left and are piled on each other. I have taken off move and resize but they still do it. Any ideas how to stop the behavior. Thanks Mj

We are haveing a custom java program written. Our developer wants to use DB2 express personal edition as the database. We are much more familure with MS Access tables or our second choice would be MSDE. Does anybody have thoughts on the pros and cons of either format. Can Java talk to an...

I am distributing some VBA programs in Excel. I'm having problems with the digital certificate as far as ease of use. Is buying a Code Signing certificate the easiest way to use VBA code without just lowering the security settings. I have tried selfcert and makecert and they still prompt alot...

In the January 2001 Windows IT Pro by Sue Mosher. She gives some code to Deleting Recurring Appointments and how to purge only items that occurred before a specific date in MS Outlook. 'Attribute VB_Name = "basPurgeCalendarFolder" ' place in an Outlook 2000 VBA module ' call this function from...

Anyone have an example of printing to a reciept printer in the AS400 environment. Printer is Ithaca 1500 if that makes a difference. Thanks

**** Cross-post from VBA Visual Basic for Applications. I thought it might be relavant here also. **** Thanks I am trying to build a multi table join sql statement using Excel VBA thru client access for an AS400 DB2 database. I do single tables all the time. I would love to move on to...

I am trying to build a multi table join sql statement using Excel VBA thru client access for an AS400 DB2 database. I do single tables all the time. I would love to move on to multi table queries. Here is what I have so far. Any ideas or examples would be helpful sqlstr = "SELECT T1.PSSVCTYP...

I need to be able to copy a cell to a range of cells. I was able to accomplish it by Selection.Copy colIndex = ActiveCell.Column rwIndex = ActiveCell.Row For rwIndex = 6 To 20 With Worksheets("Sheet1").Cells(rwIndex, colIndex) Cell(rwIndex, colIndex).Select...

We use dozens of web based java apps by different companies. Some 1.2, 1.3, 1.4 based. Almost all of them conflict with the currently installed version. Even the newer versions won't work with the older ones and vise versa. We are trying to find a answer but not much sucess. Current thinking is...

I am working on an excel spreadsheet running a VBA program. Twice now I have had it freeze up while running then debugging errors. Closing the spreadsheet and even rebooting the computer will not bring it back. I have had to open a new spreadsheet and copy the code to a new one just to get it...

I need to Assign a variable a value from cell. Example cell A1 has 100 in it . dim test as Integer test= a1.value I have looked everywhere, may have just missed it. Thanks in advance

I have 2 tables. Table1 contains software types and versions, example Office 97 Office 2000 Table2 contains a software inventory. One of the columns is a drop down list box that contains unique software types from table 1. I want anouther column that is a drop down list box that...

I am having a problem with Internet Explorer. To switch between wireless and wired networks I have to run Network Setup Wizard every time. I am also runnning Norton Internet Security Pro. Any thoughts or suggestions would be helpful. Thanks in advance.

While creating a query with the query tool in Microsoft SQL Server 2k enterprise manager. It always replaces my criteria ='RE' with =N'RE'. It also changes it in the full query statement. SELECT *, STATUS AS Expr1 FROM Customer WHERE (STATUS = N'RE') It apears to run normally...

I have a user using OWA to send email. The body of email to external addresses appears to be blank/have been deleted. Email to internal addresses appear fine. We are not having problems with regular Outlook clients. Our mail filter adds a little privacy tag to the end of the email and it does...

I was wondering if anyone had any basic ado examples of progammically opening a local Access table in the current database and moving thru it. Thanks in advance. MJ

My error log is filling up with info like: 2003-10-16 12:48:13.40 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted. 2003-10-16 12:48:13.56 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted. 2003-10-16 12:48:13.62 logon Login succeeded for user 'MYDOMAIN\Me'...

We have Oracle running on an HP RS9000 running HP UX. I was wondering if some one could tell me how to get to the Oracle command line and execute a basic sql command. I can't find a tutorial that tells me how to get started. If you know of a good tutorial that would be helpful as well. Thanks...

SQL server 2000. I have a log file that has grown to 55 MB. I tried to get into it but it sits there and counts up memory 300 bytes at a time. I was hoping to find what caused it to grow. I had to end the enterprise manager because it was taking up 100 percent of the process. Any thought about...