The IT Blog Top 10: Nov. 19, 2009
10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for users of Sun’s VirtualBox. 8. Success [...]
Answer Question
| November 19, 2009 6:46 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for users of Sun’s VirtualBox. 8. Success [...]
Answer Question
| November 19, 2009 6:46 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Access Tab Control Problem
I had a form that was working fine. I was able to open a form by clicking on the ID in the subform using code “[Forms]![Sales Home]![ConvoQuery subform].[Form]![ConversationID]=[ConversationID]” and it would open the form I wanted. I have however changed the form to put my subforms into tabs. Now “[Forms]![Sales Home]![ConvoQuery subform].[Form]![ConversationID]=[ConversationID]” will not work. [...]
Answer Question
| July 28, 2010 6:30 PM
Access 2007 forms, Access Forms Database, Microsoft Access 2007
I had a form that was working fine. I was able to open a form by clicking on the ID in the subform using code “[Forms]![Sales Home]![ConvoQuery subform].[Form]![ConversationID]=[ConversationID]” and it would open the form I wanted. I have however changed the form to put my subforms into tabs. Now “[Forms]![Sales Home]![ConvoQuery subform].[Form]![ConversationID]=[ConversationID]” will not work. [...]
Answer Question
| July 28, 2010 6:30 PM
Access 2007 forms, Access Forms Database, Microsoft Access 2007
PHP and MS Access Database
I’m trying to access an access databse located in my LAN thru php. When I run the script, I get the below error in Apache’s error log file: “[strong]PHP Fatal error: Uncaught exception ‘com_exception’ with message ‘Source: Microsoft OLE DB Provider for ODBC Drivers Description: Operation was canceled.’ in C:\WAMP\httproot\x1.php:6nStack trace:n#0 C:\WAMP\httproot\x1.php(6): com->open(‘DRIVER={Microso…’)n#1 {main}n thrown [...]
Answer Question
| January 22, 2010 5:22 AM
Access Database, Microsoft Access, PHP
I’m trying to access an access databse located in my LAN thru php. When I run the script, I get the below error in Apache’s error log file: “[strong]PHP Fatal error: Uncaught exception ‘com_exception’ with message ‘Source: Microsoft OLE DB Provider for ODBC Drivers Description: Operation was canceled.’ in C:\WAMP\httproot\x1.php:6nStack trace:n#0 C:\WAMP\httproot\x1.php(6): com->open(‘DRIVER={Microso…’)n#1 {main}n thrown [...]
Answer Question
| January 22, 2010 5:22 AM
Access Database, Microsoft Access, PHP
SQL
is it possible to have a where sql statement that is open ended. I have notice that there are time that parameter box pops up with some the Access pass-through queries that I have. Is it possible with SQL to be able to have a box pop up that would ask for a specific input to [...]
Answer Question
| February 27, 2010 4:40 PM
Access 2000, Access Datasheet, Microsoft Access 2000, SQL, Windows Server 2000
is it possible to have a where sql statement that is open ended. I have notice that there are time that parameter box pops up with some the Access pass-through queries that I have. Is it possible with SQL to be able to have a box pop up that would ask for a specific input to [...]
Answer Question
| February 27, 2010 4:40 PM
Access 2000, Access Datasheet, Microsoft Access 2000, SQL, Windows Server 2000
inactive timeout different for one user
can I set a different inactive timeout (logoff) for one user?
Answer Question
| November 18, 2009 3:02 PM
AS/400 user sessions, Timeout
can I set a different inactive timeout (logoff) for one user?
Answer Question
| November 18, 2009 3:02 PM
AS/400 user sessions, Timeout
To trap the item name of more than one item selected in list control
1)Is it possible to trap the item name of more than one item selected in the list control?Then how?I wish to trap the item name of more than one item selected in the list/combo control with/without the help of index numbers of the item selected. 2)And then use this item name to pick up data [...]
Answer Question
| November 19, 2009 7:40 PM
Microsoft Access, SQL, Visual Basic 6.0
1)Is it possible to trap the item name of more than one item selected in the list control?Then how?I wish to trap the item name of more than one item selected in the list/combo control with/without the help of index numbers of the item selected. 2)And then use this item name to pick up data [...]
Answer Question
| November 19, 2009 7:40 PM
Microsoft Access, SQL, Visual Basic 6.0
Datasheet view sorting question
Using the datasheet view, when sorting on a field with or without a dropdown menu, select a choice and then no data appears, even when there is data in the list. This is a repeatable problem. Has anyone else experienced this problem?
Answer Question
| November 17, 2009 4:16 PM
Datasheet View, SharePoint 2007, Sorting
Using the datasheet view, when sorting on a field with or without a dropdown menu, select a choice and then no data appears, even when there is data in the list. This is a repeatable problem. Has anyone else experienced this problem?
Answer Question
| November 17, 2009 4:16 PM
Datasheet View, SharePoint 2007, Sorting
foxpro 2.6 on windows 98
I am developing a software in foxpro 2.6. on windows 98 When i run the project after every 16 trasactions it gives an error as follows :- ” DO NESTING IS TOO DEEP “ there is no logical or syntax error in the project. But still it gives this error. Anybody can tell me [...]
Answer Question
| November 20, 2009 11:31 AM
FoxPro, FoxPro 2.6, Windows 98
I am developing a software in foxpro 2.6. on windows 98 When i run the project after every 16 trasactions it gives an error as follows :- ” DO NESTING IS TOO DEEP “ there is no logical or syntax error in the project. But still it gives this error. Anybody can tell me [...]
Answer Question
| November 20, 2009 11:31 AM
FoxPro, FoxPro 2.6, Windows 98
Database being auto duplicate when exit.
hi you, i’ve created a database for my dept and place it on shared server. The problem is everytime user exit from the database, there will be a duplicate of database at the server. Example: my database file name is correspondence_log.accdb, when user finished used the database, there will be an auto duplicate database created e.g [...]
Answer Question
| January 5, 2010 7:23 AM
Access 2007, Access Database, Microsoft Access
hi you, i’ve created a database for my dept and place it on shared server. The problem is everytime user exit from the database, there will be a duplicate of database at the server. Example: my database file name is correspondence_log.accdb, when user finished used the database, there will be an auto duplicate database created e.g [...]
Answer Question
| January 5, 2010 7:23 AM
Access 2007, Access Database, Microsoft Access
Composite foreign Key in SQL Server
I have a composite foreign key that has to be part of the primary key of the new table… but an error appears in SQL server… CREATE TABLE Se_paga_con (IDpel INT NOT NULL, IDvta INT NOT NULL, IDnota INT NOT NULL, CantidadPeliculas INT, PRIMARY KEY (IDpel,IDvta,IDnota), FOREIGN KEY (IDpel, IDvta) REFERENCES PeliculaEnVenta(IDpel, IDvta)); IDpel AND [...]
Answer Question
| November 17, 2009 1:56 AM
Composite Foreign Keys, Foreign keys, SQL Server 2008, SQL Server error messages
I have a composite foreign key that has to be part of the primary key of the new table… but an error appears in SQL server… CREATE TABLE Se_paga_con (IDpel INT NOT NULL, IDvta INT NOT NULL, IDnota INT NOT NULL, CantidadPeliculas INT, PRIMARY KEY (IDpel,IDvta,IDnota), FOREIGN KEY (IDpel, IDvta) REFERENCES PeliculaEnVenta(IDpel, IDvta)); IDpel AND [...]
Answer Question
| November 17, 2009 1:56 AM
Composite Foreign Keys, Foreign keys, SQL Server 2008, SQL Server error messages
how to migrate repository from SVN to VSS version control in Linux based server
Hi Experts, I would seek the help to know how to migrate from SVN to VSS for version control in Linux based machines Which is better out of two,already we have svn setup
Answer Question
| November 23, 2009 7:29 AM
Linux, SVN, SVN to VSS Migration, VSS
Hi Experts, I would seek the help to know how to migrate from SVN to VSS for version control in Linux based machines Which is better out of two,already we have svn setup
Answer Question
| November 23, 2009 7:29 AM
Linux, SVN, SVN to VSS Migration, VSS
DECFLOAT – Internal Format
Hello, How to translate an internal DECFLOAT value into a visual format? DB2 Administration Guide: “Convert and return a DECFLOAT representation of a number or string representation of a number”, (Appendix A. Writing exit routines). There is an example there: Internal Format DFP Format String Representation D8F77D00000000000C 222C000000001E80 +7.500 They do not explain, how to [...]
Answer Question
| February 1, 2010 2:47 PM
DB2, DB2 9, DB2 administration, DECFLOAT, z/OS
Hello, How to translate an internal DECFLOAT value into a visual format? DB2 Administration Guide: “Convert and return a DECFLOAT representation of a number or string representation of a number”, (Appendix A. Writing exit routines). There is an example there: Internal Format DFP Format String Representation D8F77D00000000000C 222C000000001E80 +7.500 They do not explain, how to [...]
Answer Question
| February 1, 2010 2:47 PM
DB2, DB2 9, DB2 administration, DECFLOAT, z/OS
Erro in Subform in Ms Access Reports
Hi All! I have a question that i have designed a report in ms access and I put a subform and linked it with the Party Group, I have put vb codes to use calculate some values if value on subform is null then VBA debug for error, I have used below all function but [...]
Answer Question
| November 16, 2009 7:34 AM
Access reports, Microsoft Access, Microsoft Access subforms
Hi All! I have a question that i have designed a report in ms access and I put a subform and linked it with the Party Group, I have put vb codes to use calculate some values if value on subform is null then VBA debug for error, I have used below all function but [...]
Answer Question
| November 16, 2009 7:34 AM
Access reports, Microsoft Access, Microsoft Access subforms
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 customer information that is extremely important to the company.
Answer Question
| February 1, 2012 5:43 PM
Database maintenance, Exchange, Exchange Public Folders, public folders database
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 customer information that is extremely important to the company.
Answer Question
| February 1, 2012 5:43 PM
Database maintenance, Exchange, Exchange Public Folders, public folders database
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 Explorer Depends on Adobe Tony Bradley explains [...]
Answer Question
| November 12, 2009 7:00 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
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 Explorer Depends on Adobe Tony Bradley explains [...]
Answer Question
| November 12, 2009 7:00 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
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 seem to [...]
Answer Question
| November 14, 2009 5:04 AM
Access 2007, IIF statement, Microsoft Access
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 seem to [...]
Answer Question
| November 14, 2009 5:04 AM
Access 2007, IIF statement, Microsoft Access
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 [...]
Answer Question
| November 11, 2009 11:03 PM
Access forms, Microsoft Access
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 [...]
Answer Question
| November 11, 2009 11:03 PM
Access forms, Microsoft Access
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, <br>SQLCHAR*)”‘TABLE’,'VIEW’,'ALIAS’,'SYNONYM’”, SQL_NTS);</p><p>I am getting back a table and views in a result set — [...]
Answer Question
| November 10, 2009 9:40 PM
ODBC, SQL tables
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, <br>SQLCHAR*)”‘TABLE’,'VIEW’,'ALIAS’,'SYNONYM’”, SQL_NTS);</p><p>I am getting back a table and views in a result set — [...]
Answer Question
| November 10, 2009 9:40 PM
ODBC, SQL tables
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?
Answer Question
| November 9, 2009 4:58 PM
Access Database, Database optimization, 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?
Answer Question
| November 9, 2009 4:58 PM
Access Database, Database optimization, 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 [...]
Answer Question
| June 22, 2012 6:37 PM
Access 2003, Data management, Microsoft Access 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 [...]
Answer Question
| June 22, 2012 6:37 PM
Access 2003, Data management, Microsoft Access query
