Creating Access Form
Use the Like statement with the wild card operator * Ex. Find all rows where field1 has a word that starts with “con” Select * from table where field1 like “con*” Ex. Find all rows where field1 has a word that has “con” anywhere in the word Select * from table where field1 like “*con*” [...]
View Answer
| January 10, 2011 2:30 PM
Access Database, Access forms, Access Forms Database, Access query
Use the Like statement with the wild card operator * Ex. Find all rows where field1 has a word that starts with “con” Select * from table where field1 like “con*” Ex. Find all rows where field1 has a word that has “con” anywhere in the word Select * from table where field1 like “*con*” [...]
View Answer
| January 10, 2011 2:30 PM
Access Database, Access forms, Access Forms Database, Access query
System configuration for double CPU
just wondering what application are you running on till you need 2 cpu’s? why not overclock the cpu till about 3.8ghz or 4ghz? but do make sure if you do overclock that your cooling is sufficient to lower down the cpu temperature.
View Answer
| January 10, 2011 1:42 PM
AMD, AMD PC hardware, CPU, Hardware AMD
just wondering what application are you running on till you need 2 cpu’s? why not overclock the cpu till about 3.8ghz or 4ghz? but do make sure if you do overclock that your cooling is sufficient to lower down the cpu temperature.
View Answer
| January 10, 2011 1:42 PM
AMD, AMD PC hardware, CPU, Hardware AMD
Windows XP SP3 network at capacity
maybe more information is needed like are you using AD? are you using DHCP? if yes then what i the number or IP that you allow to automatically reach the other users? how about switch connection? how many users are connected to the network?
View Answer
| January 10, 2011 5:32 AM
Network administration, Windows Network Administration, Windows networking, Windows XP SP3
maybe more information is needed like are you using AD? are you using DHCP? if yes then what i the number or IP that you allow to automatically reach the other users? how about switch connection? how many users are connected to the network?
View Answer
| January 10, 2011 5:32 AM
Network administration, Windows Network Administration, Windows networking, Windows XP SP3
Actiontec ADSL and Internet providers
How can I add a Windows Home Server to my Actiontec GT724WGR network?
View Answer
| January 9, 2011 9:11 PM
ActionTec GT724WGR, ADSL modems, ISP, Modem/Internet compatability, WOW Internet
How can I add a Windows Home Server to my Actiontec GT724WGR network?
View Answer
| January 9, 2011 9:11 PM
ActionTec GT724WGR, ADSL modems, ISP, Modem/Internet compatability, WOW Internet
User log in to Active Directory Windows Server 2003
You need to use third party application like <a href=”http://www.manageengine.com/network-monitoring/activedirectory-monitoring.html”>OPMANAGER</a> its a great software.
View Answer
| January 8, 2011 5:13 AM
Active Directory, Active Directory User Profiles, Active Directory Users, Event Viewer, Windows Server 2003
You need to use third party application like <a href=”http://www.manageengine.com/network-monitoring/activedirectory-monitoring.html”>OPMANAGER</a> its a great software.
View Answer
| January 8, 2011 5:13 AM
Active Directory, Active Directory User Profiles, Active Directory Users, Event Viewer, Windows Server 2003
Create “if then” formula in Access 2003
I think it would help for you to give an example of what you have and what you want. If I am understanding you, each article number has three intro dates and three outro dates, but you want it to only have one of each?
View Answer
| January 6, 2011 6:59 PM
Access 2003, Access 2003 date query, Access 2003 forms, Access forms
I think it would help for you to give an example of what you have and what you want. If I am understanding you, each article number has three intro dates and three outro dates, but you want it to only have one of each?
View Answer
| January 6, 2011 6:59 PM
Access 2003, Access 2003 date query, Access 2003 forms, Access forms
Will Windows NT 4.0 still be able to login to SBS 2008
Yes, Windows NT clients will be able to log into your Windows 2008 SBS server. You will need to be sure to install the WINS service on your server and setup the DHCP server to send out the server’s IP address as the WINS server to all your clients.
View Answer
| January 5, 2011 6:46 PM
SBS 2008, Small Business Server 2008, Windows 7, Windows NT, Windows NT 4.0, Windows XP
Yes, Windows NT clients will be able to log into your Windows 2008 SBS server. You will need to be sure to install the WINS service on your server and setup the DHCP server to send out the server’s IP address as the WINS server to all your clients.
View Answer
| January 5, 2011 6:46 PM
SBS 2008, Small Business Server 2008, Windows 7, Windows NT, Windows NT 4.0, Windows XP
What’s the typical life span of a Windows Server?
There are Windows servers out there that have been running happily for the last 10 years that are still working just fine. I wouldn’t ever recommend formatting and reinstalling just because. If you have a need for the newer version, or you have upgrade rights then by all means standardize on a single version, it’ll [...]
View Answer
| January 5, 2011 6:40 PM
Server maintenance, Server management, Windows Server 2003, Windows Server 2003 Enterprise Edition, Windows server administration, Windows Server Management
There are Windows servers out there that have been running happily for the last 10 years that are still working just fine. I wouldn’t ever recommend formatting and reinstalling just because. If you have a need for the newer version, or you have upgrade rights then by all means standardize on a single version, it’ll [...]
View Answer
| January 5, 2011 6:40 PM
Server maintenance, Server management, Windows Server 2003, Windows Server 2003 Enterprise Edition, Windows server administration, Windows Server Management
Replace HP Proliant ML 350 disks without losing data
So you have HP ProLiant ML350 servers running Windows Server 2003. There are currently 6 different generations that you could have of that server type. But putting that aside the ML350 does support hot plugin of HDs. So if you have not used all the drive slots and the OS resides on just 1 of [...]
View Answer
| January 5, 2011 2:06 PM
Hard disks, HP ProLiant, HP ProLiant ML 350, Windows Server 2003
So you have HP ProLiant ML350 servers running Windows Server 2003. There are currently 6 different generations that you could have of that server type. But putting that aside the ML350 does support hot plugin of HDs. So if you have not used all the drive slots and the OS resides on just 1 of [...]
View Answer
| January 5, 2011 2:06 PM
Hard disks, HP ProLiant, HP ProLiant ML 350, Windows Server 2003
Windows XP slow in DSL environment
Check you antivirus and make sure all the patches are updates, figure out what resources are most used when you system is connected to internet and kill them if they are irrelevant. Cheers Yasir
View Answer
| January 5, 2011 5:33 AM
DSL, DSL routers, Valmsmith, Windows XP, Windows XP performance
Check you antivirus and make sure all the patches are updates, figure out what resources are most used when you system is connected to internet and kill them if they are irrelevant. Cheers Yasir
View Answer
| January 5, 2011 5:33 AM
DSL, DSL routers, Valmsmith, Windows XP, Windows XP performance
IP based Access Restriction for Terminal Services
As per my knowledge its not possible to block the users using an IP address, you can make use of your Siwtches or firewall to create an access list to block the teminal service port 3389. Mean while I am also trying find out the possibilities, if I came accross I will let you know. [...]
View Answer
| January 5, 2011 5:30 AM
IP Subnetting, System administration, Terminal Services, Terminal Services Security, Windows Server 2003, Windows Server 2003 Enterprise Edition, WINTEL, Wintel Server
As per my knowledge its not possible to block the users using an IP address, you can make use of your Siwtches or firewall to create an access list to block the teminal service port 3389. Mean while I am also trying find out the possibilities, if I came accross I will let you know. [...]
View Answer
| January 5, 2011 5:30 AM
IP Subnetting, System administration, Terminal Services, Terminal Services Security, Windows Server 2003, Windows Server 2003 Enterprise Edition, WINTEL, Wintel Server
System i Access Windows 7 V6R1 install error 1713
My first thought is that your Windows 7 Machine is missing the following update/install package, Microsoft Visual C++ 2005 SP1 Redistribution Package. This assumes Windows 7 32-Bit. Reboot, then try the install of Access i again. http://www.microsoft.com/downloads/en/details.aspx?familyid=200B2FD9-AE1A-4A14-984D-389C36F85647&displaylang=en Are you installing all the components of System i Access? If not, which ones are you attempting to [...]
View Answer
| January 4, 2011 5:23 PM
Client Access, iSeries error messages, iSeries V6R1, System i, System i Access, V6R1, Windows 7
My first thought is that your Windows 7 Machine is missing the following update/install package, Microsoft Visual C++ 2005 SP1 Redistribution Package. This assumes Windows 7 32-Bit. Reboot, then try the install of Access i again. http://www.microsoft.com/downloads/en/details.aspx?familyid=200B2FD9-AE1A-4A14-984D-389C36F85647&displaylang=en Are you installing all the components of System i Access? If not, which ones are you attempting to [...]
View Answer
| January 4, 2011 5:23 PM
Client Access, iSeries error messages, iSeries V6R1, System i, System i Access, V6R1, Windows 7
Best solution for deploying Linux virtual desktop
I would suggest you try Verde VDI from Virtual Bridges. They originally started in partnership with IBM, Novell and a couple of other companies in 2006 and created the first Linux VDI solution but it is based on the Linux KVM as opposed to the Xen hypervisor. And you can cluser the VERDE servers for [...]
View Answer
| January 4, 2011 5:00 PM
Desktop virtualization, Failover, Linux, Linux Virtual Server, Thin clients, Ubuntu, Ubuntu Linux, Windows XP, Windows XP clients
I would suggest you try Verde VDI from Virtual Bridges. They originally started in partnership with IBM, Novell and a couple of other companies in 2006 and created the first Linux VDI solution but it is based on the Linux KVM as opposed to the Xen hypervisor. And you can cluser the VERDE servers for [...]
View Answer
| January 4, 2011 5:00 PM
Desktop virtualization, Failover, Linux, Linux Virtual Server, Thin clients, Ubuntu, Ubuntu Linux, Windows XP, Windows XP clients
How to connect 3 PCs through ASUS switch
This is the first I knew that ASUS made switches, though I cannot say I am surprised. First, ensure your router is handling the NAT, DHCP, and DNS services for you. NAT is the address translation form the IP address your ISP gives your circuit to a private network such as 10.x.x.x or 192.168.x . [...]
View Answer
| January 4, 2011 3:43 PM
ASUS, Windows XP
This is the first I knew that ASUS made switches, though I cannot say I am surprised. First, ensure your router is handling the NAT, DHCP, and DNS services for you. NAT is the address translation form the IP address your ISP gives your circuit to a private network such as 10.x.x.x or 192.168.x . [...]
View Answer
| January 4, 2011 3:43 PM
ASUS, Windows XP
Windows 7 and KIXTART scripts
According to the documentation on the Kixtart site, Windows 7 is not listed as a supported platform. “KiXtart 2010 is supported on systems with an Intel 80486 or better microprocessor systems running Windows Server 2008, Windows Vista, Windows XP, Windows 2000, Windows NT 3.x/4.x, or any version of Windows 95, Windows 98 or Windows Millennium [...]
View Answer
| January 4, 2011 3:08 PM
Kix, Kix Logon Script, Kix Scripts, Windows 7
According to the documentation on the Kixtart site, Windows 7 is not listed as a supported platform. “KiXtart 2010 is supported on systems with an Intel 80486 or better microprocessor systems running Windows Server 2008, Windows Vista, Windows XP, Windows 2000, Windows NT 3.x/4.x, or any version of Windows 95, Windows 98 or Windows Millennium [...]
View Answer
| January 4, 2011 3:08 PM
Kix, Kix Logon Script, Kix Scripts, Windows 7
Email Notification If Scheduled Task In Windows Fails
If you can use a batch file (or other script) to determine success or failure, there are several mechanisms you can use for email notification. If you’re running Exchange, I seem to recall that there’s a command-line utility to send email – FROM a logged in machine. Netlatency.com has a sendmail command-line utility one word [...]
View Answer
| January 4, 2011 1:16 PM
Brightmail, CipherTrust, ClearSwift, Desktops, Exchange, Management, McAfee, MessageLabs, Microsoft Office, Microsoft Windows, OS, Postini, Rockliffe, Security, Servers, Spam, SpamAssassin, SQL Server, SurfControl, Symantec, TrendMicro
If you can use a batch file (or other script) to determine success or failure, there are several mechanisms you can use for email notification. If you’re running Exchange, I seem to recall that there’s a command-line utility to send email – FROM a logged in machine. Netlatency.com has a sendmail command-line utility one word [...]
View Answer
| January 4, 2011 1:16 PM
Brightmail, CipherTrust, ClearSwift, Desktops, Exchange, Management, McAfee, MessageLabs, Microsoft Office, Microsoft Windows, OS, Postini, Rockliffe, Security, Servers, Spam, SpamAssassin, SQL Server, SurfControl, Symantec, TrendMicro
Turn off the automatic archiving feature in Microsoft Outlook
Change your main view to Folder list. Right-click the clendar and choose properties. Click the auto archive tab. Is it set to archive? Change it to “Do not archive items in this folder”. Open your archive, go to the calendar there and change the view to a list view. “Select all” entries, right-click and move [...]
View Answer
| January 4, 2011 4:26 AM
Exchange Archiving, Office 2007, Outlook, Outlook calendar, Vista, vista 2007
Change your main view to Folder list. Right-click the clendar and choose properties. Click the auto archive tab. Is it set to archive? Change it to “Do not archive items in this folder”. Open your archive, go to the calendar there and change the view to a list view. “Select all” entries, right-click and move [...]
View Answer
| January 4, 2011 4:26 AM
Exchange Archiving, Office 2007, Outlook, Outlook calendar, Vista, vista 2007
Automate SPLF deletion in AS/400
Hi RainyDaye, The system has a command DLTSPLF. You can write a quick CL program to issue this command with its appropriate selections and add a job to the Job Scheduler to call your CL program. You may wish to execute this jon daily or on seelcted days. Cheers.
View Answer
| January 4, 2011 12:21 AM
AS/400, Automation, OUTQ, SPLF, Systems administration
Hi RainyDaye, The system has a command DLTSPLF. You can write a quick CL program to issue this command with its appropriate selections and add a job to the Job Scheduler to call your CL program. You may wish to execute this jon daily or on seelcted days. Cheers.
View Answer
| January 4, 2011 12:21 AM
AS/400, Automation, OUTQ, SPLF, Systems administration
APC device connected via USB shutting down other systems
Yes you can. I’m not sure is it possible with APC ups-management software but you can do it with open-source NUT – “network ups tools”. NUT consist of (1) handful of ups drivers, (2) ups daemon which communicates with the ups(es) through appropriate driver(s) and shares the information on the network (with some limited security [...]
View Answer
| January 3, 2011 4:55 PM
APC, Network applications management, Network connectivity, Network Controller, USB
Yes you can. I’m not sure is it possible with APC ups-management software but you can do it with open-source NUT – “network ups tools”. NUT consist of (1) handful of ups drivers, (2) ups daemon which communicates with the ups(es) through appropriate driver(s) and shares the information on the network (with some limited security [...]
View Answer
| January 3, 2011 4:55 PM
APC, Network applications management, Network connectivity, Network Controller, USB
install Mac OS X leopard on laptop
Well MAC don’t support MAC OSX on any of the laptops apart from MacBooks pro. They don’t have any OS designed for non mac apporved laptops. Its illegal to to install MAC OS on a HP laptop. Cheers Yasir
View Answer
| January 2, 2011 5:25 AM
Installing/upgrading operating systems, Mac OS, Mac OS X Leopard
Well MAC don’t support MAC OSX on any of the laptops apart from MacBooks pro. They don’t have any OS designed for non mac apporved laptops. Its illegal to to install MAC OS on a HP laptop. Cheers Yasir
View Answer
| January 2, 2011 5:25 AM
Installing/upgrading operating systems, Mac OS, Mac OS X Leopard
