Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, Database, DataCenter, Desktops, Development, Exchange 2003, Exchange 2007, Hardware, iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing, Marketing Technology, Microsoft Excel, Microsoft Exchange, Microsoft Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Tech support, Virtualization, Visual Basic, VoIP, VPN, Windows 7, Windows Server, Windows Server 2003, Windows Server 2008, Windows XP ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
Hi, I have a Win2000 Server that we are using for our production QC System. I need to run 3 excel files with macros (Excel 2000) on the server for a monthly report. My problem is that each of these Excel files are already 30MB. When opening the third Excel file, the system prompts that it is out of...
Hi all, looking for a script or batch file that I can call from schedule tasks that will delete some older Symantec log files that keep filling up my C: drive. Any suggestion or pointers would be appreciated. Thanks in advance! Paul
How can I connect my application server to Oracle database 10g. The application server have a form that can be accessible through browser (client). Please tell me the configuration that I have to do.
I'm creating a lookup field and would like to list only those items relevant to the record actively using the lookup. So my DB has two tables one using the lookup which as a child ID field that I'd like to match with the parent ID field of another table.
Is there a way to set up task manager to require admin authentication instead of disabling it altogether?
Hi peeps, Short and sweet question. I have a server 2008 r2 domain with Windows 7 clients. Is there a power shell script to change all logons to 1024 x 768 resolutions via a GPO start up script? Any help appreciated. Thanks!
I am getting the error:"Windows cannot connect to the printer. Operation failed with error 0x00000002" Both the PC's are in one domain. This problem is only with one PC in domain but for the same PC, expect printing sharing the folder is OK.
How to return the control to the program in self expanding subfile while pressing page up?
A user sends an important e-mail that doesn't show up in the recipient's Outlook inbox until several hours later. Is this a common problem? Is there any way to verify the time sent, or to find out what caused the delay? I'm being asked to investigate and have no idea where to begin. (The recipient...
Can Windows 2008 R2 installed as guest OS on virtual PC 2007?
I need to display multiple messages at bottom of screen.Is there an alternate way of displaying multiple error messages rather than using message subfile...if so can you give me a simple example
I have one display file and subfile. I used load all subfile to load my records in subfile, in that i have one selection filed. My question is if i give "1" in that selection field without pressing "enter" it has to be move values from subfile screen to display file?
I have several reports which extract data via Oracle Forms into MS Excel. But Excel cuts off the input at row 999. The Oracle Form uses the DDE.EXECUTE(ConvID) command. Does anybody know if Excel has a limitation of the number of rows it will import via Oracle Forms?
did the above steps but its not working… Example:: —————————————– FLD1 FLD2 FLD3 AAA AAAA AAAAA AAA AAAA AAAAA AAA AAAA AAAAA rrn = 3 —————————————– BB ______ _________ I need to filter the records having the value BB, but there are no...
My management has asked me to disable the ability of users to access command line from an application by limiting capabilities *YES. I need to write a CL that will allow me to place RUNQRY into the application menu and need help creating the CL program. Can anyone assist?
How to create 'n' number of userprofile from CL Program?
Windows XP SP3. I worked on a project recently where we had to install pre-imaged machines and do the final tweaking for the End User. What I noticed was, instead of the vulnerable C: drive carrying this critical section of personal data, it had been redirected over to a safe zone of drive...
Hello, I have these queries on a job schedule now and I want to export them to Excel using CL. PGM RUNQRY MYENTRIES1 RUNQRY MYENTRIES2 COPYTOIMPF FROMFILE(MYLIB/MYFILE1) (MYLIB/FILE2) ENDPGM Where do I send these two files to? And can I run both queries this way?
Hi, Is there a way in macro wherein if a certain cell has value, the other cells will be automatically populated? Example: In cell E6 I put the date, cell A6, B6,C6 and D6 will automatically copy the values in A4, B4, C4 and D4. Same goes when I enter the date on cell E7. Thank you so much in...
I am using MS Excel 2003. I have a spreadsheet with the exactly the same formula in every cell of a given column (This is possible by using the row() and the indirect() functions). The spreadsheet is using 6000 rows. Currently, I have copied the formula into each cell. This increases the...