Access 2007 query with null values
I am currently creating an Access 2007 database for calculating salesperson commissions. I have a table with 5 fields I’m working with: SalesRep, SOWRep, TerritoryRep, Period and Commission. I am trying to build a query that will calculate commission for a salesperson for each record where their name appears in one of the first three [...]
Answer Question
| April 17, 2013 6:29 PM
Microsoft Access 2007, Microsoft Access query
I am currently creating an Access 2007 database for calculating salesperson commissions. I have a table with 5 fields I’m working with: SalesRep, SOWRep, TerritoryRep, Period and Commission. I am trying to build a query that will calculate commission for a salesperson for each record where their name appears in one of the first three [...]
Answer Question
| April 17, 2013 6:29 PM
Microsoft Access 2007, Microsoft Access query
MS Access 2007 functions
Can someone please help me with the expression for the IFF function?
Answer Question
| April 17, 2013 10:26 AM
Microsoft Access 2007, Microsoft Access function
Can someone please help me with the expression for the IFF function?
Answer Question
| April 17, 2013 10:26 AM
Microsoft Access 2007, Microsoft Access function
Microsoft Word keys
Why does Word stop functioning if a key is depressed too long?
Answer Question
| April 17, 2013 11:40 PM
Microsoft Word 2002, Microsoft Word features
Why does Word stop functioning if a key is depressed too long?
Answer Question
| April 17, 2013 11:40 PM
Microsoft Word 2002, Microsoft Word features
Outlook calendar – change invite host name?
Is it possible to change the name of the host for an invitation? One of my managers is retiring and the other manager is taking over all of his scheduled meetings. Would like to have the new manager listed as the host for these meetings and include those invites on the new manager’s calendar so [...]
Answer Question
| April 16, 2013 4:59 PM
Microsoft Outlook, Microsoft Outlook Calendar
Is it possible to change the name of the host for an invitation? One of my managers is retiring and the other manager is taking over all of his scheduled meetings. Would like to have the new manager listed as the host for these meetings and include those invites on the new manager’s calendar so [...]
Answer Question
| April 16, 2013 4:59 PM
Microsoft Outlook, Microsoft Outlook Calendar
Windows Server 2003
Single 2003 DC & additional 2003 DC is running, When user login through wan link multiple users are getting error “The time difference error between client and server could not authenticate with server” Error message displaying in windows 7 machine.
Answer Question
| April 16, 2013 7:39 AM
Windows Server 2003, Windows Server Error Messages
Single 2003 DC & additional 2003 DC is running, When user login through wan link multiple users are getting error “The time difference error between client and server could not authenticate with server” Error message displaying in windows 7 machine.
Answer Question
| April 16, 2013 7:39 AM
Windows Server 2003, Windows Server Error Messages
Codes to bring back deleted files and folders
How can I bring back deleted files on my PC?
Answer Question
| April 16, 2013 6:10 AM
Deleted files, Microsoft Windows XP
How can I bring back deleted files on my PC?
Answer Question
| April 16, 2013 6:10 AM
Deleted files, Microsoft Windows XP
Sheet protection
My spreadsheet is “read only” accessed by others in my business. Certain columns are locked. I’d like users to be able to copy and insert new copied rows, but when the sheet is protected copy and insert copied rows is not allowed. How do I allow this when sheet is protected?
Answer Question
| April 16, 2013 2:28 AM
Microsoft Excel, Microsoft Excel permissions
My spreadsheet is “read only” accessed by others in my business. Certain columns are locked. I’d like users to be able to copy and insert new copied rows, but when the sheet is protected copy and insert copied rows is not allowed. How do I allow this when sheet is protected?
Answer Question
| April 16, 2013 2:28 AM
Microsoft Excel, Microsoft Excel permissions
Add email entries in shared public cal;ender into own outlook calender
I have a client that has his own calendar set up but also in the public folders there is a shared calendar he has access to. He wants to know how when he makes an entry into the shared calendar does it also show up in his personnel calendar. I have also tried to add [...]
Answer Question
| April 15, 2013 2:18 PM
calender invitation, Exchange 2007, Office 2007, Windows 7
I have a client that has his own calendar set up but also in the public folders there is a shared calendar he has access to. He wants to know how when he makes an entry into the shared calendar does it also show up in his personnel calendar. I have also tried to add [...]
Answer Question
| April 15, 2013 2:18 PM
calender invitation, Exchange 2007, Office 2007, Windows 7
Error when logging through remote
Hi, I am facing issue with a server while I am accessing through remote. When I go through remote desktop connection, it gives me an error and I don’t have access. On the other hand, if I am trying to connect remote through console i.e mstsc /v:ipaddress /admin, I am able to login. Did anyone [...]
Answer Question
| April 15, 2013 1:57 PM
Remote access, Remote access server
Hi, I am facing issue with a server while I am accessing through remote. When I go through remote desktop connection, it gives me an error and I don’t have access. On the other hand, if I am trying to connect remote through console i.e mstsc /v:ipaddress /admin, I am able to login. Did anyone [...]
Answer Question
| April 15, 2013 1:57 PM
Remote access, Remote access server
Printer cartridge
I have put in a new black and color cartridges and the black will not print. What is the problem?
Answer Question
| April 15, 2013 1:46 AM
Printer cartridges, Printers
I have put in a new black and color cartridges and the black will not print. What is the problem?
Answer Question
| April 15, 2013 1:46 AM
Printer cartridges, Printers
Windows XP/7 lock issues
Hello Team What are the latest technologies/ways to reduce Windows 7/Windows XP unlock issue types. Example §User is blocked Win Password §Windows, Account locked and password reset.
Answer Question
| April 12, 2013 4:13 PM
Windows 7, Windows XP
Hello Team What are the latest technologies/ways to reduce Windows 7/Windows XP unlock issue types. Example §User is blocked Win Password §Windows, Account locked and password reset.
Answer Question
| April 12, 2013 4:13 PM
Windows 7, Windows XP
Find and replace text in PPT
I have a project to find and replace words in PowerPoint from Excel and then save the PowerPoint. My code is working fine. But when PPT has mp3 then it giving errors. Please see the code and tell me what change I should do. Sub pptopen()Dim a AsIntegerFor a =2To4Dim pptApp As PowerPoint.Application Dim pptPres [...]
Answer Question
| April 11, 2013 11:00 AM
Microsoft Excel, Microsoft PowerPoint, VBA
I have a project to find and replace words in PowerPoint from Excel and then save the PowerPoint. My code is working fine. But when PPT has mp3 then it giving errors. Please see the code and tell me what change I should do. Sub pptopen()Dim a AsIntegerFor a =2To4Dim pptApp As PowerPoint.Application Dim pptPres [...]
Answer Question
| April 11, 2013 11:00 AM
Microsoft Excel, Microsoft PowerPoint, VBA
Creating tools to perform some actions
I need to check for blank lines occurred in Excel file, if so I need to filter and check the associated name then send them a reply to update for that blank line which is taking so much time so wants to automate this task. Kindly help.
Answer Question
| April 11, 2013 7:14 AM
Microsoft Excel, Microsoft Excel files
I need to check for blank lines occurred in Excel file, if so I need to filter and check the associated name then send them a reply to update for that blank line which is taking so much time so wants to automate this task. Kindly help.
Answer Question
| April 11, 2013 7:14 AM
Microsoft Excel, Microsoft Excel files
Productivity
Your team consists of 10 agents, each agent takes 18 calls per day and the average handling time for troubleshooting calls is 90 minutes and the average handling time for transfer calls is 6 minutes and 10 minutes for information calls. The floor averages on the of calls are as follows Troubleshooting calls 30% Transfer [...]
Answer Question
| April 10, 2013 3:39 AM
Microsoft Excel
Your team consists of 10 agents, each agent takes 18 calls per day and the average handling time for troubleshooting calls is 90 minutes and the average handling time for transfer calls is 6 minutes and 10 minutes for information calls. The floor averages on the of calls are as follows Troubleshooting calls 30% Transfer [...]
Answer Question
| April 10, 2013 3:39 AM
Microsoft Excel
Default font style/size for graphics
Microsoft Office 2007. I copy a graphic file to put into a word file, the font style does not stay Arial. It changes to Courier and I have to manually change each text box from Courier to Arial. How can I copy the graphic figure from a word file and keep the font as the [...]
Answer Question
| April 10, 2013 7:27 PM
Microsoft Office 2007, Microsoft Office features
Microsoft Office 2007. I copy a graphic file to put into a word file, the font style does not stay Arial. It changes to Courier and I have to manually change each text box from Courier to Arial. How can I copy the graphic figure from a word file and keep the font as the [...]
Answer Question
| April 10, 2013 7:27 PM
Microsoft Office 2007, Microsoft Office features
Can send emails externally but cannot receive external mail
Hi, I’m an IT tech, and two users have additional mailboxes for finance and audits. These mailboxes can receive internal mails, but cannot receive external mails. We are using Exchange 2010. I have tried to telnet the server and port 25 is not opened.
Answer Question
| April 9, 2013 8:39 AM
Microsoft Exchange 2010, Microsoft Exchange errors
Hi, I’m an IT tech, and two users have additional mailboxes for finance and audits. These mailboxes can receive internal mails, but cannot receive external mails. We are using Exchange 2010. I have tried to telnet the server and port 25 is not opened.
Answer Question
| April 9, 2013 8:39 AM
Microsoft Exchange 2010, Microsoft Exchange errors
Formatting hard disk with Windows XP on it
I have a desktop computer running Windows XP, Home Edition. It seems that over the years my hard disk is infected and is filled with a lot of junk stuff. How can I format and clean my hard disk in order to reinstall my Windows XP from my original disks? Thanks.
Answer Question
| April 8, 2013 4:49 AM
Hard disks, Windows XP
I have a desktop computer running Windows XP, Home Edition. It seems that over the years my hard disk is infected and is filled with a lot of junk stuff. How can I format and clean my hard disk in order to reinstall my Windows XP from my original disks? Thanks.
Answer Question
| April 8, 2013 4:49 AM
Hard disks, Windows XP
Create unattended install package
I ran across an application called ZSoft Uninstaller. It will create a small report on what files were added/changed to the hard drive and windows registry by doing the following in order: 1. Analyzing the hard drive 2. Installing the application/driver 3. Analyzing the hard drive again 4. Compare both before and after I’m not [...]
Answer Question
| April 8, 2013 9:39 PM
Microsoft Windows, ZSoft Uninstaller
I ran across an application called ZSoft Uninstaller. It will create a small report on what files were added/changed to the hard drive and windows registry by doing the following in order: 1. Analyzing the hard drive 2. Installing the application/driver 3. Analyzing the hard drive again 4. Compare both before and after I’m not [...]
Answer Question
| April 8, 2013 9:39 PM
Microsoft Windows, ZSoft Uninstaller
Internet access from Windows
After installing Quickweb, does it prevent opening a web page from Windows IE without going through Quickweb?
Answer Question
| April 8, 2013 10:18 PM
Quickweb, Windows 7
After installing Quickweb, does it prevent opening a web page from Windows IE without going through Quickweb?
Answer Question
| April 8, 2013 10:18 PM
Quickweb, Windows 7
How can I restrict user to delete any document form Windows Server?
I want to do that the user can access file, they can read but not able to save as or delete that file from server. Is this possible or not? If yes then please let me guide.
Answer Question
| April 8, 2013 12:25 PM
Windows Server 2003, Windows Server Permissions
I want to do that the user can access file, they can read but not able to save as or delete that file from server. Is this possible or not? If yes then please let me guide.
Answer Question
| April 8, 2013 12:25 PM
Windows Server 2003, Windows Server Permissions
