Public folder database maintenance?
We have a large contact database (3000+ records) in a public folder(Exchange 2003). It has a custom form with many user-defined fields. Does Exchange to any automatic maintenance on these databases? Is there a maintenance utility I should be running on it? This database contains vital...
We have a large contact database (3000+ records) in a public folder(Exchange 2003). It has a custom form with many user-defined fields. Does Exchange to any automatic maintenance on these databases? Is there a maintenance utility I should be running on it? This database contains vital...
45 pts.
The IT Blog Top 10: Nov. 12, 2009
10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet...
10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet...
Access 2007 IIF statement in query criteria
This is a query design looking at a checkbox on a form, if its checked, I would like to return only the database fields (ConfigData) that contain text. If it isn't checked, return all the fields whether they have text or not...Pretty basic filter I thought Seems like I'm getting close but can't...
This is a query design looking at a checkbox on a form, if its checked, I would like to return only the database fields (ConfigData) that contain text. If it isn't checked, return all the fields whether they have text or not...Pretty basic filter I thought Seems like I'm getting close but can't...
Access Form Printing Problem
I have designed a set of forms in Access. One of the forms prints the form in total. However tow of the forms will only print the header and footer and does not print the data input portion of the form. What am I missiong in regards to why I can't get these two forms to print in total? Thanks...
I have designed a set of forms in Access. One of the forms prints the form in total. However tow of the forms will only print the header and footer and does not print the data input portion of the form. What am I missiong in regards to why I can't get these two forms to print in total? Thanks...
How do I fetch synonym names with the SQLTables function in ODBC API?
Can somebody please explain how to fetch synonym names with the SQLTables function in ODBC API. I currently use the DSN created with SQL Native Client 10 and SQL Server 2005. My code is as follows:</p><p>ret = SQLTables(stmt, NULL, 0, NULL, 0, NULL, 0,...
Can somebody please explain how to fetch synonym names with the SQLTables function in ODBC API. I currently use the DSN created with SQL Native Client 10 and SQL Server 2005. My code is as follows:</p><p>ret = SQLTables(stmt, NULL, 0, NULL, 0, NULL, 0,...
Database Splitting
What other alternative do I have to split a lotus note database beside writing a code to copy document to newly created database? Software/Hardware used: Lotus Domino
What other alternative do I have to split a lotus note database beside writing a code to copy document to newly created database? Software/Hardware used: Lotus Domino
How to combine 2 linked Excel tables in access 2003 with same field names, using query?
I have 3 employees working who have no access on their PC. they are performing their data entry in excel and I ahve linked all three tables to one access file as I have Access on my PC. I need to combine all 3 tables using query or some other method in access to create one master table. Here is the...
I have 3 employees working who have no access on their PC. they are performing their data entry in excel and I ahve linked all three tables to one access file as I have Access on my PC. I need to combine all 3 tables using query or some other method in access to create one master table. Here is the...
The IT Blog Top 10: Nov. 5, 2009
10. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover has put together a useful tutorial for Sun’s xVM VirtualBox. 9. How to reset the Cisco Catalyst Switch to Factory Defaults Yasir Irfan offers some advice for those needing a fresh late on Catalyst switches. 8. Independent...
10. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover has put together a useful tutorial for Sun’s xVM VirtualBox. 9. How to reset the Cisco Catalyst Switch to Factory Defaults Yasir Irfan offers some advice for those needing a fresh late on Catalyst switches. 8. Independent...
lamp or sap
HI all , i ve complted my engneering in electronics and Commnctn; Now i have two options to take up as my career, sap or lamp; which has more opening and scope ; what are the categories in sap/ Software/Hardware used: software
HI all , i ve complted my engneering in electronics and Commnctn; Now i have two options to take up as my career, sap or lamp; which has more opening and scope ; what are the categories in sap/ Software/Hardware used: software
Mysql syntax
Hi Have a table: budget When I try this: MySql: insert into budget values (’Department A’,1,2,200) Department A represents:A Department called A 1 represents: a courseno from table course 2 also represents: a courseno from table course It doesnt work :|… Any suggestions.... ? ...
Hi Have a table: budget When I try this: MySql: insert into budget values (’Department A’,1,2,200) Department A represents:A Department called A 1 represents: a courseno from table course 2 also represents: a courseno from table course It doesnt work :|… Any suggestions.... ? ...
Constraints (MySql,tables,null,PK,FK etc)
Hi all(waves) noob here ( :) ) ( yes you might look down upon me) ( :( ) never the less....:) Quick question: Tables made so far: department values (depno,dname) course values values (courseno) How would I create a table eg "Table budgets"...with values of two budgets (£100 and £200) for...
Hi all(waves) noob here ( :) ) ( yes you might look down upon me) ( :( ) never the less....:) Quick question: Tables made so far: department values (depno,dname) course values values (courseno) How would I create a table eg "Table budgets"...with values of two budgets (£100 and £200) for...
The most-watched IT questions this week: Nov. 3, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...
Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...
PHP Datagrid
Hi! I m new to php and MySQL database. I want to know how whether php provides any class for datagrid
Hi! I m new to php and MySQL database. I want to know how whether php provides any class for datagrid
Migration from Paradox to MS Access or VB.Net/MS SQL
We have a department that has several applications running on Paradox 11. They need assistance migrating their tables and application UI/code to another platform. Any feedback or guidance would be appreciated. Software/Hardware used: Windows XP desktop, Windows Server 2007
We have a department that has several applications running on Paradox 11. They need assistance migrating their tables and application UI/code to another platform. Any feedback or guidance would be appreciated. Software/Hardware used: Windows XP desktop, Windows Server 2007
How to convert LONG to CLOB or to VARCHAR type in select statement
Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT...
Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT...
The IT Blog Top 10: Oct. 29, 2009
10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view...
10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view...
COMBO BOX (IN VB) HOW BEHAVE LIKE MS ACCESS
HI VB EXPERTS, PLEASE SOLVE HOW CAN BEHAVE THE VB COMBO JUST LIKE MS ACCESS COMBO (OFFICE 2003/2007) EG. IN MS ACCESS COMBO :- A) WHEN START TYPING THEN NEAREST MATCHED SELECTED/DISPLAYED B) ON GOT FOCUS COMBO DROPDOWN ABOVE FACILITIES I WISH TO AVAIL IN VB COMBO BOX PLEASE PLEASE PLEASE ...
HI VB EXPERTS, PLEASE SOLVE HOW CAN BEHAVE THE VB COMBO JUST LIKE MS ACCESS COMBO (OFFICE 2003/2007) EG. IN MS ACCESS COMBO :- A) WHEN START TYPING THEN NEAREST MATCHED SELECTED/DISPLAYED B) ON GOT FOCUS COMBO DROPDOWN ABOVE FACILITIES I WISH TO AVAIL IN VB COMBO BOX PLEASE PLEASE PLEASE ...
IT infrastruture
Dear Sir, I Gaurav Nijhawan 21years old working in a mnc company in gurgaon(India). I have two years of experience in IT for supporting a site. I did MCP( Microsoft Certified Professional). earlier i was working as a desktop support engineer and completely work on Desktop and Outlook...
Dear Sir, I Gaurav Nijhawan 21years old working in a mnc company in gurgaon(India). I have two years of experience in IT for supporting a site. I did MCP( Microsoft Certified Professional). earlier i was working as a desktop support engineer and completely work on Desktop and Outlook...
