Microsoft Excel – I need to find rows that match a user entered entries and sum results of column b
This is a classic case of using the power of EXCEL Pivot table. In Excel 2007 – just set up a Pivot table with Project under the “Row Label” & Sum of Hours under “Value”. Now use Conditional Formatting for values lower than 24. Here is an example: Project Well Hours Lewis 1 12 Lewis [...]
View Answer
| February 8, 2009 5:27 AM
Duplicate records, Excel functions, Excel macros, Functions, Microsoft Excel, SUM function
This is a classic case of using the power of EXCEL Pivot table. In Excel 2007 – just set up a Pivot table with Project under the “Row Label” & Sum of Hours under “Value”. Now use Conditional Formatting for values lower than 24. Here is an example: Project Well Hours Lewis 1 12 Lewis [...]
View Answer
| February 8, 2009 5:27 AM
Duplicate records, Excel functions, Excel macros, Functions, Microsoft Excel, SUM function
Creating a CSV file to FTP
<b>” When picked up it had lost its csv extension” </b> – does this mean that .csv not showing up? In this case, Open Explore >> Tools >> Folder Options >> View Then Un-select “Hide Extensions for known file types”. The file should be OK in either way – just the file extension will not [...]
View Answer
| February 8, 2009 4:53 AM
Comma Separated Values, CSV, CSV format, Excel 2007, FTP, Microsoft Excel 2007, Microsoft Office 2007
<b>” When picked up it had lost its csv extension” </b> – does this mean that .csv not showing up? In this case, Open Explore >> Tools >> Folder Options >> View Then Un-select “Hide Extensions for known file types”. The file should be OK in either way – just the file extension will not [...]
View Answer
| February 8, 2009 4:53 AM
Comma Separated Values, CSV, CSV format, Excel 2007, FTP, Microsoft Excel 2007, Microsoft Office 2007
How to retreive stored procedure from DB2/400
Do you have iSeries Navigator on your PC? You can use it to drill down to where the procedure is located on the i: After entering Navigator, from the Environment box on the left, select your system name, then Databases, [system name], then Schemas, then [library or schema name], and then Procedures. In the window [...]
View Answer
| February 4, 2009 5:12 PM
AS/400 DB2, AS/400 development, DB2 stored procedures, DB2/400
Do you have iSeries Navigator on your PC? You can use it to drill down to where the procedure is located on the i: After entering Navigator, from the Environment box on the left, select your system name, then Databases, [system name], then Schemas, then [library or schema name], and then Procedures. In the window [...]
View Answer
| February 4, 2009 5:12 PM
AS/400 DB2, AS/400 development, DB2 stored procedures, DB2/400
I am trying to get a signature into ACOM software on the AS/400
The procedure for loading images is fairly simple. I have been using Acom software and designing forms for many years. The ACOM software comes with an EZDESIGNER File transfer utility to more forms or images. Start up the software and select the “Put Image” tab and then enter you image file name in the “PC [...]
View Answer
| February 4, 2009 2:25 PM
ACOM Software, AS/400 printing, IFS
The procedure for loading images is fairly simple. I have been using Acom software and designing forms for many years. The ACOM software comes with an EZDESIGNER File transfer utility to more forms or images. Start up the software and select the “Put Image” tab and then enter you image file name in the “PC [...]
View Answer
| February 4, 2009 2:25 PM
ACOM Software, AS/400 printing, IFS
Infor Visual Manufacturing Auto Log off
Found a solution! I’m sharing it in case others might need it. Details: VizManager™ http://www.gobiztech.com/visual.htm. The program is around $500 for unlimited users. it installs on each client machine.
View Answer
| February 3, 2009 7:23 PM
ERP, Infor, Infor Visual Manufacturing
Found a solution! I’m sharing it in case others might need it. Details: VizManager™ http://www.gobiztech.com/visual.htm. The program is around $500 for unlimited users. it installs on each client machine.
View Answer
| February 3, 2009 7:23 PM
ERP, Infor, Infor Visual Manufacturing
Crystal Reports OBDC (Oracle)
Are you using the same database user when connecting from Crystal than when connecting from Access ? It could be a problem of missing privileges or synonyms.
View Answer
| February 2, 2009 7:22 PM
Crystal Reports, Database connectivity, ODBC, Open Database Connectivity, Oracle connectivity
Are you using the same database user when connecting from Crystal than when connecting from Access ? It could be a problem of missing privileges or synonyms.
View Answer
| February 2, 2009 7:22 PM
Crystal Reports, Database connectivity, ODBC, Open Database Connectivity, Oracle connectivity
AS/400 QADBIFLD error Duplicate Record Key?
You can do a RCLSTG SELECT(*DBXREF). What this does is a reclaim of the DB cross reference files only and runs faster than doing a RCLSTG SELECT(*ALL) which touches every library on the system. We had to do this once when the cross reference got hosed up. As always, the system needs to be in [...]
View Answer
| February 2, 2009 5:33 PM
AS/400 error messages, AS/400 errors, Database Cross-Reference 2, Duplicate records, IPL, QADBIFLD, QDBSRVXR2, V5R2
You can do a RCLSTG SELECT(*DBXREF). What this does is a reclaim of the DB cross reference files only and runs faster than doing a RCLSTG SELECT(*ALL) which touches every library on the system. We had to do this once when the cross reference got hosed up. As always, the system needs to be in [...]
View Answer
| February 2, 2009 5:33 PM
AS/400 error messages, AS/400 errors, Database Cross-Reference 2, Duplicate records, IPL, QADBIFLD, QDBSRVXR2, V5R2
Data Migration Testing
When you talk about Data migration. First you need to know the type of Data, like DB, CIFS non structured data, etc, what kind of file system you migrate, from what technology to what technology. Is the File systems (FS) are SAN, NAS, directe attached, Virtual Luns, After you need to know who is accesing [...]
View Answer
| February 2, 2009 4:25 PM
Data migration, Data quality, Data verification, Testing
When you talk about Data migration. First you need to know the type of Data, like DB, CIFS non structured data, etc, what kind of file system you migrate, from what technology to what technology. Is the File systems (FS) are SAN, NAS, directe attached, Virtual Luns, After you need to know who is accesing [...]
View Answer
| February 2, 2009 4:25 PM
Data migration, Data quality, Data verification, Testing
Duplicate IP addresses?
Computer should not be sharing an IP Address. Each machine will need its own IP address so that the computers now how to talk to each other. If one computer is on, and your router reboots then another computer is turned on then both machines could be issued the sameIP address. Because of this it [...]
View Answer
| February 2, 2009 3:35 PM
Duplicate IP addresses, IP address, privacy
Computer should not be sharing an IP Address. Each machine will need its own IP address so that the computers now how to talk to each other. If one computer is on, and your router reboots then another computer is turned on then both machines could be issued the sameIP address. Because of this it [...]
View Answer
| February 2, 2009 3:35 PM
Duplicate IP addresses, IP address, privacy
Adobe 9
To combine multiple PDF documents into one document: 1. Choose Create PDF > From Multiple Files from the File drop-down menu, or click the Create PDF button on the toolbar and choose From Multiple files. 2. In the Create PDF from Multiple Documents dialog box, do any of the following: • Click Browse (Windows) or [...]
View Answer
| January 29, 2009 2:31 PM
Adobe Acrobat, Adobe Acrobat 9 Pro
To combine multiple PDF documents into one document: 1. Choose Create PDF > From Multiple Files from the File drop-down menu, or click the Create PDF button on the toolbar and choose From Multiple files. 2. In the Create PDF from Multiple Documents dialog box, do any of the following: • Click Browse (Windows) or [...]
View Answer
| January 29, 2009 2:31 PM
Adobe Acrobat, Adobe Acrobat 9 Pro
Crystal Reports 8.5 and Windows Vista compatibility
Hi, just had a look into it on google and it doesnt look like it runs smoothly to say the least. As a contractor I have seen many companies having problems with Vista. I would advise very very strongly against moving to vista and ask you what extra functionality do you get for your money? [...]
View Answer
| January 29, 2009 12:08 PM
Crystal Reports, Crystal Reports 8.5, Vista compatibility, Windows Vista
Hi, just had a look into it on google and it doesnt look like it runs smoothly to say the least. As a contractor I have seen many companies having problems with Vista. I would advise very very strongly against moving to vista and ask you what extra functionality do you get for your money? [...]
View Answer
| January 29, 2009 12:08 PM
Crystal Reports, Crystal Reports 8.5, Vista compatibility, Windows Vista
Replication for additional domain controller
This article, entitled <a href=”http://www.petri.co.il/transferring_fsmo_roles.htm”>How can I transfer some or all of the FSMO Roles from one DC to another?</a> – may be of help. I pasted an excerpt below. Thanks. <b>Excerpt</b>: “<i>Windows 2000/2003 Active Directory domains utilize a Single Operation Master method called FSMO (Flexible Single Master Operation), as described in Understanding FSMO Roles [...]
View Answer
| January 28, 2009 2:02 PM
Active Directory replication, Domain Controller, Flexible Single Master Operations, FSMO Roles
This article, entitled <a href=”http://www.petri.co.il/transferring_fsmo_roles.htm”>How can I transfer some or all of the FSMO Roles from one DC to another?</a> – may be of help. I pasted an excerpt below. Thanks. <b>Excerpt</b>: “<i>Windows 2000/2003 Active Directory domains utilize a Single Operation Master method called FSMO (Flexible Single Master Operation), as described in Understanding FSMO Roles [...]
View Answer
| January 28, 2009 2:02 PM
Active Directory replication, Domain Controller, Flexible Single Master Operations, FSMO Roles
Converting Microsoft Works documents to Microsoft Word
Save the documents in Rich Text Format – RTF. This format will be able to be opened by MS Word. Actually, have you tried to open the Works documents using Word? They should be compatible. ******** Labnuke is right. <a href=”http://office.microsoft.com/en-us/word/HP011881161033.aspx”>Here is an article</a> to help you. ~ technochic
View Answer
| January 27, 2009 4:07 PM
Converting documents, Document formats, File formats, Microsoft Word, Microsoft Works
Save the documents in Rich Text Format – RTF. This format will be able to be opened by MS Word. Actually, have you tried to open the Works documents using Word? They should be compatible. ******** Labnuke is right. <a href=”http://office.microsoft.com/en-us/word/HP011881161033.aspx”>Here is an article</a> to help you. ~ technochic
View Answer
| January 27, 2009 4:07 PM
Converting documents, Document formats, File formats, Microsoft Word, Microsoft Works
Similar Microsoft/SAS/Wireless Issue that has my IT department stumped – HELP!
Update your hardware drivers. Check with the hardware manufacturer to see if they have anything shown on their technical support forums or knowledgebase. We had some users that had difficulties with VPN connection stability over wireless and once they upgraded their drivers, the problem went away.
View Answer
| January 26, 2009 7:39 PM
Microsoft Word 2007, SAS, Windows Performance Management, Windows XP, Wireless networking
Update your hardware drivers. Check with the hardware manufacturer to see if they have anything shown on their technical support forums or knowledgebase. We had some users that had difficulties with VPN connection stability over wireless and once they upgraded their drivers, the problem went away.
View Answer
| January 26, 2009 7:39 PM
Microsoft Word 2007, SAS, Windows Performance Management, Windows XP, Wireless networking
Data link layer monitoring
The Data Link Layer refers to “Layer 2″ in the OSI model. I assume when you say monitoring you mean a “Sniffer” to watch traffic at layer two. There are a number of them out there that are great and sometimes very useful, called wireshark it has both Windows and Linux distributions and really is [...]
View Answer
| June 11, 2013 3:30 PM
Data link protocols, Network monitoring, Networking
The Data Link Layer refers to “Layer 2″ in the OSI model. I assume when you say monitoring you mean a “Sniffer” to watch traffic at layer two. There are a number of them out there that are great and sometimes very useful, called wireshark it has both Windows and Linux distributions and really is [...]
View Answer
| June 11, 2013 3:30 PM
Data link protocols, Network monitoring, Networking
No records in detail causes the group data not to be shown
The link you are using must be an outer join to show all of the entries from one table and only the entries related to them from the other. This will show your Loan# even if there are no trades in the date range. the Message No Trades could be a conditional statement based on [...]
View Answer
| January 22, 2009 1:27 PM
Crystal Reports, Crystal Reports Conditional Formatting
The link you are using must be an outer join to show all of the entries from one table and only the entries related to them from the other. This will show your Loan# even if there are no trades in the date range. the Message No Trades could be a conditional statement based on [...]
View Answer
| January 22, 2009 1:27 PM
Crystal Reports, Crystal Reports Conditional Formatting
I need to up load an excel file to sql server db with vb
It could be any number of things. Without the exact error message there isn’t a whole of information anyone will be able to procide.
View Answer
| January 21, 2009 4:51 AM
Crystal Reports, Importing Excel to SQL, Microsoft Excel, SQL Server stored procedures, Visual Basic
It could be any number of things. Without the exact error message there isn’t a whole of information anyone will be able to procide.
View Answer
| January 21, 2009 4:51 AM
Crystal Reports, Importing Excel to SQL, Microsoft Excel, SQL Server stored procedures, Visual Basic
updating to autocad 2009
Are you asking if you will still be able to use AutoCAD2006 (as a program) or the files produced in AutoCAD 2006? Chances are installing AutoCAD 2009 will take everything that pointed to 2006 and turn it into a pointer to the new updated program, 2009. But, 2009 should be backwards compatible so you should [...]
View Answer
| January 18, 2009 5:50 PM
AutoCAD, AutoCAD 2009, Project management
Are you asking if you will still be able to use AutoCAD2006 (as a program) or the files produced in AutoCAD 2006? Chances are installing AutoCAD 2009 will take everything that pointed to 2006 and turn it into a pointer to the new updated program, 2009. But, 2009 should be backwards compatible so you should [...]
View Answer
| January 18, 2009 5:50 PM
AutoCAD, AutoCAD 2009, Project management
How to get the duplicate records using RPG/400
Easiest way is in SQL Select count(*), field1, field2, field3 from myfile group by field1, field2, field3 having count(*) > 1 This would find matches on these three fields. Programmatically you would open a cursor and fetch the results into a datastructure of count(*), field1, field2, field3 But if you must do it in RPG [...]
View Answer
| January 16, 2009 3:13 PM
Duplicate records, RPG, RPG/400
Easiest way is in SQL Select count(*), field1, field2, field3 from myfile group by field1, field2, field3 having count(*) > 1 This would find matches on these three fields. Programmatically you would open a cursor and fetch the results into a datastructure of count(*), field1, field2, field3 But if you must do it in RPG [...]
View Answer
| January 16, 2009 3:13 PM
Duplicate records, RPG, RPG/400
