Displaying amount field in query 400.
In query400, i created a report which will be downloaded to excel. If i download report, it is showing amount fields without decimal values. How to display amount fields with decimal fields using query400?
Answer Question
| February 27, 2012 12:22 PM
AS/400, Microsoft Excel, Query/400
In query400, i created a report which will be downloaded to excel. If i download report, it is showing amount fields without decimal values. How to display amount fields with decimal fields using query400?
Answer Question
| February 27, 2012 12:22 PM
AS/400, Microsoft Excel, Query/400
In-House Exchange Server with GoDaddy Domain
Hello, we have an Exchange 2007 server in house that was hosting our email. We have a web guy that setup our domain and site to be hosted through GoDaddy, and now we need to point the email back to our Exchange server. I’m assuming this is just a matter of changing the MX records [...]
Answer Question
| April 29, 2012 6:30 PM
Microsoft Exchange 2007, MX record
Hello, we have an Exchange 2007 server in house that was hosting our email. We have a web guy that setup our domain and site to be hosted through GoDaddy, and now we need to point the email back to our Exchange server. I’m assuming this is just a matter of changing the MX records [...]
Answer Question
| April 29, 2012 6:30 PM
Microsoft Exchange 2007, MX record
Send mail problem on Exchange 2010
Hi I’he problem sending mail. our company has 2 ISP. i have 2 mx record on host 1 smtp1.domain.com IP X.X.X.X. 2. smtp2.domain.com IP y.y.y.y X.X.X.X.- first ISP static IP y.y.y.y - second ISP static IP Exchange server 2010 smtp connector is mail.domain.com ISP1 and ISP 2 added PTR record ISP1 added ptr records x.x.x.x : mail.domain.com x.x.x.x [...]
Answer Question
| March 4, 2012 12:04 PM
Microsoft Exchange 2010, Microsoft Exchange errors
Hi I’he problem sending mail. our company has 2 ISP. i have 2 mx record on host 1 smtp1.domain.com IP X.X.X.X. 2. smtp2.domain.com IP y.y.y.y X.X.X.X.- first ISP static IP y.y.y.y - second ISP static IP Exchange server 2010 smtp connector is mail.domain.com ISP1 and ISP 2 added PTR record ISP1 added ptr records x.x.x.x : mail.domain.com x.x.x.x [...]
Answer Question
| March 4, 2012 12:04 PM
Microsoft Exchange 2010, Microsoft Exchange errors
Computer will not boot into Windows
I am running Windows XP. I was using the computer yesterday but when I switched on this morning, the opening window runs through to “Verifying DMI Pool Data….” and then freezes. The CD drive is not working. Does anyone know how I can, at least, boot into Windows?
Answer Question
| March 18, 2012 3:27 PM
Windows XP
I am running Windows XP. I was using the computer yesterday but when I switched on this morning, the opening window runs through to “Verifying DMI Pool Data….” and then freezes. The CD drive is not working. Does anyone know how I can, at least, boot into Windows?
Answer Question
| March 18, 2012 3:27 PM
Windows XP
access 2003 mdb file size increases automatically
please if you can tell me why size of an access 2003 file automatically increase whereas no data is entered or very less data. it increases upto more than 1 GB. once the same data is imported into another file it is of the size of about 20-30 mb. strange? i have used anti viruses [...]
Answer Question
| February 27, 2012 9:01 AM
MDB, Microsoft Access 2003
please if you can tell me why size of an access 2003 file automatically increase whereas no data is entered or very less data. it increases upto more than 1 GB. once the same data is imported into another file it is of the size of about 20-30 mb. strange? i have used anti viruses [...]
Answer Question
| February 27, 2012 9:01 AM
MDB, Microsoft Access 2003
Problem – Outlook 2010 calendar invites with attachments not working – google apps/gmail
Hi there, Has anyone found a solution to this problem? We have just changed to Outlook 2010 and also migrated to Google Apps for business and are having an issue with Outlook 2010 calendar invites with attachments. This is a problem that is happening when we send Calendar invites from Outlook 2010 with attachments – [...]
Answer Question
| May 7, 2013 3:19 PM
Google Apps, Microsoft Outlook 2010, Microsoft Outlook Calendar
Hi there, Has anyone found a solution to this problem? We have just changed to Outlook 2010 and also migrated to Google Apps for business and are having an issue with Outlook 2010 calendar invites with attachments. This is a problem that is happening when we send Calendar invites from Outlook 2010 with attachments – [...]
Answer Question
| May 7, 2013 3:19 PM
Google Apps, Microsoft Outlook 2010, Microsoft Outlook Calendar
max query expression
have a very basic table: dwg, dwg rev, rev date – what query expression do I write to show only highest rev?
Answer Question
| February 27, 2012 2:51 PM
Microsoft Access 2003, Microsoft Access queries
have a very basic table: dwg, dwg rev, rev date – what query expression do I write to show only highest rev?
Answer Question
| February 27, 2012 2:51 PM
Microsoft Access 2003, Microsoft Access queries
AS/400 LAN printer problem
Hi, Two OUTQs in two systems has been assigned to the same lan printer.ie both systems have a device and OUTQ created with the same IP address. but out of two, the one which is starting first is taking the control and the print from the other printer is going to PND status. Both Printers [...]
Answer Question
| February 27, 2012 11:43 AM
AS400Printing, LAN Printers
Hi, Two OUTQs in two systems has been assigned to the same lan printer.ie both systems have a device and OUTQ created with the same IP address. but out of two, the one which is starting first is taking the control and the print from the other printer is going to PND status. Both Printers [...]
Answer Question
| February 27, 2012 11:43 AM
AS400Printing, LAN Printers
Link RDP in Microsoft Access to click computer name to remote control
I have build a Microsoft Access 2007 database for trouble tickets and inventory. I have a table called INVENTORY. One fo the fields is DEVICE NAME. Right now it is simpy a text field. In this field we enter the comptuer name (example COMPUTER1234) We have forms which contain the DEVICE NAME field. I would like [...]
Answer Question
| February 27, 2012 2:48 PM
Microsoft Access 2007, Microsoft Access fields
I have build a Microsoft Access 2007 database for trouble tickets and inventory. I have a table called INVENTORY. One fo the fields is DEVICE NAME. Right now it is simpy a text field. In this field we enter the comptuer name (example COMPUTER1234) We have forms which contain the DEVICE NAME field. I would like [...]
Answer Question
| February 27, 2012 2:48 PM
Microsoft Access 2007, Microsoft Access fields
Windows list of modified file associations (only)
Is there any way/program to list all the modified file associations (that is, changed from their default) on a Windows 7 system? This would help in replicating a user’s environment on another system.
Answer Question
| March 17, 2012 2:26 PM
File associations, Windows 7
Is there any way/program to list all the modified file associations (that is, changed from their default) on a Windows 7 system? This would help in replicating a user’s environment on another system.
Answer Question
| March 17, 2012 2:26 PM
File associations, Windows 7
Can SCCM capture the monitor resolution of remote computers?
Have 40,000 computers deployed and new to SCCM. Is it possible to capture the monitor resolution for all systems? Have an application that needs a higher resolution.
Answer Question
| February 27, 2012 7:32 PM
Monitor resolution, SCCM 2007
Have 40,000 computers deployed and new to SCCM. Is it possible to capture the monitor resolution for all systems? Have an application that needs a higher resolution.
Answer Question
| February 27, 2012 7:32 PM
Monitor resolution, SCCM 2007
Report labels
Since I am new to this – Is there a way to rename the labels for the categories DriveType, VolumeName or Name in a select statement as you would for: “select @{l=’Server’;e={$_.__SERVER}}”?
Answer Question
| February 27, 2012 3:38 PM
PowerShell, Powershell commands, PowerShell Scripts
Since I am new to this – Is there a way to rename the labels for the categories DriveType, VolumeName or Name in a select statement as you would for: “select @{l=’Server’;e={$_.__SERVER}}”?
Answer Question
| February 27, 2012 3:38 PM
PowerShell, Powershell commands, PowerShell Scripts
Content Report for SharePoint 2010
I want to report on the number of documents in my sites collection and have them grouped by document type, i.e. word, excel, pdf, wiki pages, power point. My objective is to establish how the organisational memmory has increased. Thank you for your help!
Answer Question
| February 27, 2012 2:58 PM
Sharepoint 2010, sharepoint 2010 features
I want to report on the number of documents in my sites collection and have them grouped by document type, i.e. word, excel, pdf, wiki pages, power point. My objective is to establish how the organisational memmory has increased. Thank you for your help!
Answer Question
| February 27, 2012 2:58 PM
Sharepoint 2010, sharepoint 2010 features
Five reminders for every appointment
We migrated to Enterprise. Prior to migration we were asked to copy calendar from server to pst file to ensure data is not lost. After migration, I now get five reminders for every appointment. Only two calendars are visible on the navigation pane. How do I get rid of the hidden calendars? I am not [...]
Answer Question
| February 28, 2012 12:56 AM
Enterprise Calender, Windows Vista Enterprise
We migrated to Enterprise. Prior to migration we were asked to copy calendar from server to pst file to ensure data is not lost. After migration, I now get five reminders for every appointment. Only two calendars are visible on the navigation pane. How do I get rid of the hidden calendars? I am not [...]
Answer Question
| February 28, 2012 12:56 AM
Enterprise Calender, Windows Vista Enterprise
Outlook
when I forward an email I do not get the old message in email. This is turned on in options. This always happens if I am sending to a group and only sometimes if forwarding to a single address.
Answer Question
| February 28, 2012 12:49 AM
Email forwarding, Microsoft Outlook, Windows 7
when I forward an email I do not get the old message in email. This is turned on in options. This always happens if I am sending to a group and only sometimes if forwarding to a single address.
Answer Question
| February 28, 2012 12:49 AM
Email forwarding, Microsoft Outlook, Windows 7
Sending HTML file with record length of 5000 char
I need to send an email with an HTML file attached from the mainframe via SMTP. Even with adding a DCP (LRECL) parameter, the spreadsheet is truncated to the 1st 1024 characters. How do I fix?
Answer Question
| February 28, 2012 8:27 PM
Excel 2007, JCL, SMTP
I need to send an email with an HTML file attached from the mainframe via SMTP. Even with adding a DCP (LRECL) parameter, the spreadsheet is truncated to the 1st 1024 characters. How do I fix?
Answer Question
| February 28, 2012 8:27 PM
Excel 2007, JCL, SMTP
Network folder is read-only but only from one COMPUTER
Hi. Here’s my problem. 1- I have a shared folder on Windows Server 2003 that has Full Control (read/write) NTFS permissions for Everyone. 2- This folder is actually accessible for writing for every users. 3- On one particular computer running Windows XP SP2 (on which nothing has changed lately for all I know) the folder [...]
Answer Question
| February 28, 2012 8:14 PM
Windows Server 2003, Windows XP SP2
Hi. Here’s my problem. 1- I have a shared folder on Windows Server 2003 that has Full Control (read/write) NTFS permissions for Everyone. 2- This folder is actually accessible for writing for every users. 3- On one particular computer running Windows XP SP2 (on which nothing has changed lately for all I know) the folder [...]
Answer Question
| February 28, 2012 8:14 PM
Windows Server 2003, Windows XP SP2
Replace changes in Excel
I use thousands of references to spreadsheets that don’t exist yet (but will eventually)in conjunction with the IfError function: =IfError(“path and name of future file”,0,”path and name of future file, tab name and cell reference”). I’m copying a workbook with lots of formulas like this and prepping for the our next fiscal year. Excel no [...]
Answer Question
| February 28, 2012 7:54 PM
Excel workbooks, Excel worksheets, Microsoft Excel 2007
I use thousands of references to spreadsheets that don’t exist yet (but will eventually)in conjunction with the IfError function: =IfError(“path and name of future file”,0,”path and name of future file, tab name and cell reference”). I’m copying a workbook with lots of formulas like this and prepping for the our next fiscal year. Excel no [...]
Answer Question
| February 28, 2012 7:54 PM
Excel workbooks, Excel worksheets, Microsoft Excel 2007
formatting disks
what are the basic formatting instructions for formatting a hard drive
Answer Question
| February 28, 2012 7:52 PM
drive/disk formatting, Windows 7
what are the basic formatting instructions for formatting a hard drive
Answer Question
| February 28, 2012 7:52 PM
drive/disk formatting, Windows 7
Sending an Update vs. Having all required to accept/decline again
I have Office 2007 Outlook and I’m wondering how I can send an update to all where it shows up in their inbox as “No response required” instead of prompting them to accept/decline again? Sometimes I need to change conference rooms and I don’t want to have all the responses coming in again when it’s [...]
Answer Question
| February 28, 2012 3:41 PM
Microsoft Office 2007, Microsoft Outlook 2007, Microsoft Outlook updates
I have Office 2007 Outlook and I’m wondering how I can send an update to all where it shows up in their inbox as “No response required” instead of prompting them to accept/decline again? Sometimes I need to change conference rooms and I don’t want to have all the responses coming in again when it’s [...]
Answer Question
| February 28, 2012 3:41 PM
Microsoft Office 2007, Microsoft Outlook 2007, Microsoft Outlook updates
