Converting SQL data to Microsoft Access through coding in VB.NET
You don’t give a reason why you want to use code rather than just import the tables. You can just import the tables from SQL Server into MS Access directly and save yourself a lot of work. Is there a reason why you want to use code to perform this function? ***** Yes, I fully [...]
View Answer
| November 26, 2008 4:38 PM
Data migration, Database, Microsoft Access, SQL, Visual Basic .NET
You don’t give a reason why you want to use code rather than just import the tables. You can just import the tables from SQL Server into MS Access directly and save yourself a lot of work. Is there a reason why you want to use code to perform this function? ***** Yes, I fully [...]
View Answer
| November 26, 2008 4:38 PM
Data migration, Database, Microsoft Access, SQL, Visual Basic .NET
Protocol bandwidth load
The amount of bandwidth which will be needed will vary from site to site. If you are browsing YouTube you will use a lot more HTTP bandwidth than if you are browsing this site because of the video. It will all depend on the number of users and what sites they are going to.
View Answer
| November 26, 2008 12:12 AM
Bandwidth, FTP, H.323, HTTP, HTTPS, IMAP, POP3, Protocol Bandwidth Load, Protocols
The amount of bandwidth which will be needed will vary from site to site. If you are browsing YouTube you will use a lot more HTTP bandwidth than if you are browsing this site because of the video. It will all depend on the number of users and what sites they are going to.
View Answer
| November 26, 2008 12:12 AM
Bandwidth, FTP, H.323, HTTP, HTTPS, IMAP, POP3, Protocol Bandwidth Load, Protocols
Random values selection
If it is Excel – do you know the start and end row number of the column? Then you can set up Random number generator: =TRUNC(RAND()*(High-Low)+Low) Note: Low & High are the column row references. You now may use this number as the random row number & get the corresponding value.
View Answer
| November 25, 2008 10:37 PM
Database programming, tables
If it is Excel – do you know the start and end row number of the column? Then you can set up Random number generator: =TRUNC(RAND()*(High-Low)+Low) Note: Low & High are the column row references. You now may use this number as the random row number & get the corresponding value.
View Answer
| November 25, 2008 10:37 PM
Database programming, tables
Fastest “get duplicates” SQL
The absolutely fastest in terms of elapsed time depends on many variables including the DBMS, platform, etc. But the most powerful, and usually fastest, is based on COUNT, GROUP BY, and HAVING: SELECT key_col_1 [,key_col_2 . . .], COUNT( * ) AS dup_count FROM the_table GROUP BY key_col_1 [,key_col_2 . . .] HAVING COUNT( * [...]
View Answer
| November 25, 2008 8:56 PM
Database maintenance, Duplicate records, SQL
The absolutely fastest in terms of elapsed time depends on many variables including the DBMS, platform, etc. But the most powerful, and usually fastest, is based on COUNT, GROUP BY, and HAVING: SELECT key_col_1 [,key_col_2 . . .], COUNT( * ) AS dup_count FROM the_table GROUP BY key_col_1 [,key_col_2 . . .] HAVING COUNT( * [...]
View Answer
| November 25, 2008 8:56 PM
Database maintenance, Duplicate records, SQL
Excel Formatting for 2007 Version
Have you tried going into the printer properties and choosing “print all text as black”.? It may depend on your printer driver too.
View Answer
| November 25, 2008 6:55 PM
Database, Development, Microsoft Office
Have you tried going into the printer properties and choosing “print all text as black”.? It may depend on your printer driver too.
View Answer
| November 25, 2008 6:55 PM
Database, Development, Microsoft Office
SQL Queries
It is not possible to perform regular expression searching in sql server (except if you create a dot.net stored procedure), so there is not a simple way to perform this query. You can try someting like this: select ip, replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(ip, ’0′,”),’1′,”),’2′,”),’3′,”),’4′,”),’5′,”),’6′,”),’7′,”),’8′,”),’9′,”),’.',”),’,',”) as OP from yourtable I know, it’s a very ugly query, but it should [...]
View Answer
| November 25, 2008 5:29 PM
Data Types, SQL, SQL Query
It is not possible to perform regular expression searching in sql server (except if you create a dot.net stored procedure), so there is not a simple way to perform this query. You can try someting like this: select ip, replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(ip, ’0′,”),’1′,”),’2′,”),’3′,”),’4′,”),’5′,”),’6′,”),’7′,”),’8′,”),’9′,”),’.',”),’,',”) as OP from yourtable I know, it’s a very ugly query, but it should [...]
View Answer
| November 25, 2008 5:29 PM
Data Types, SQL, SQL Query
TEST DIRECTOR FOR QUALITY CENTER
According to <a href=”https://h10078.www1.hp.com/cda/hpms/display/main/hpms_content.jsp?zn=bto&cp=1-11-127-24^9679_4000_100__”>their documentation</a> the OS requirements are Windows 2000 Server with Service Pack 4 or Windows 2003 Server with Service Pack 1 Standard / Enterprise Edition
View Answer
| November 25, 2008 5:27 PM
HP TestDirector for Quality Center, Mercury Quality Center, Quality assurance, Vista, Windows Vista
According to <a href=”https://h10078.www1.hp.com/cda/hpms/display/main/hpms_content.jsp?zn=bto&cp=1-11-127-24^9679_4000_100__”>their documentation</a> the OS requirements are Windows 2000 Server with Service Pack 4 or Windows 2003 Server with Service Pack 1 Standard / Enterprise Edition
View Answer
| November 25, 2008 5:27 PM
HP TestDirector for Quality Center, Mercury Quality Center, Quality assurance, Vista, Windows Vista
Migrate Power users to user
Is this on local pC’s or in the domain? What is your DC OS level?
View Answer
| November 25, 2008 5:24 PM
Active Directory, DOS Batch, Migrations and upgrades, Scripting, VBScript
Is this on local pC’s or in the domain? What is your DC OS level?
View Answer
| November 25, 2008 5:24 PM
Active Directory, DOS Batch, Migrations and upgrades, Scripting, VBScript
IIS 6.0 and PHP
The error message is related to the javascript engine, there is a workaround working with the registry, but probably the first solution to try is to reinstall the scripting engine. You can found it at this link: http://www.microsoft.com/downloads/details.aspx?FamilyID=47809025-D896-482E-A0D6-524E7E844D81&displaylang=en
View Answer
| November 25, 2008 3:38 PM
IIS 6.0, PHP, Windows Web Server 2003
The error message is related to the javascript engine, there is a workaround working with the registry, but probably the first solution to try is to reinstall the scripting engine. You can found it at this link: http://www.microsoft.com/downloads/details.aspx?FamilyID=47809025-D896-482E-A0D6-524E7E844D81&displaylang=en
View Answer
| November 25, 2008 3:38 PM
IIS 6.0, PHP, Windows Web Server 2003
RPG procedure
Hi, Your code will only read the first record in the file, then keep displaying the three variables. You need another read in your loop. You should also set the pointer to the first key in your file (you have the file defined as keyed) using setll :- FMYFILE IF E K DISK <b>C *LOVAL [...]
View Answer
| November 25, 2008 2:20 PM
Database programming, fMyFile, RPG, RPG/400
Hi, Your code will only read the first record in the file, then keep displaying the three variables. You need another read in your loop. You should also set the pointer to the first key in your file (you have the file defined as keyed) using setll :- FMYFILE IF E K DISK <b>C *LOVAL [...]
View Answer
| November 25, 2008 2:20 PM
Database programming, fMyFile, RPG, RPG/400
Perplexing Combo Box
I assume this is for Excel..? 1) Assign an array to the Combo Box’s List Property. <pre> Dim arrData As Variant arrData = Array(“January”, “February”, “March”, “April”, “May”, “June”, “July”, “August”, “September”, “October”, “November”, “December”) cmbMonth1.List = arrData </pre> 2) Use the GetCustomListContents Method. You only need one line of code: <pre> cmbMonth1.List = Application.GetCustomListContents(4) [...]
View Answer
| November 25, 2008 5:14 AM
ComboBox, VBA
I assume this is for Excel..? 1) Assign an array to the Combo Box’s List Property. <pre> Dim arrData As Variant arrData = Array(“January”, “February”, “March”, “April”, “May”, “June”, “July”, “August”, “September”, “October”, “November”, “December”) cmbMonth1.List = arrData </pre> 2) Use the GetCustomListContents Method. You only need one line of code: <pre> cmbMonth1.List = Application.GetCustomListContents(4) [...]
View Answer
| November 25, 2008 5:14 AM
ComboBox, VBA
new to macros – extracting data
If you want to check if a textbox input is of the format you want, try something like this: If Len$(TextBox1.Text) <> 8 Then: Exit Sub ‘ right number of characters If Not Left$(TextBox1.Text, 3) Like “*[abcdefghijklmnopqrstuvwxyz]*” Then: Exit Sub ‘ first three chars are letters If Not Right$(TextBox1.Text, 4) Like “*[0123456789]*” Then: Exit Sub [...]
View Answer
| November 25, 2008 4:57 AM
Excel macros, Macros, Microsoft Excel, VBA
If you want to check if a textbox input is of the format you want, try something like this: If Len$(TextBox1.Text) <> 8 Then: Exit Sub ‘ right number of characters If Not Left$(TextBox1.Text, 3) Like “*[abcdefghijklmnopqrstuvwxyz]*” Then: Exit Sub ‘ first three chars are letters If Not Right$(TextBox1.Text, 4) Like “*[0123456789]*” Then: Exit Sub [...]
View Answer
| November 25, 2008 4:57 AM
Excel macros, Macros, Microsoft Excel, VBA
VBA Localization
As far as I know, VBA macros can only be written in English. I’d be glad to hear otherwise.
View Answer
| November 25, 2008 4:42 AM
Localization, VBA, VBA for AutoCAD, Visual Basic for Applications
As far as I know, VBA macros can only be written in English. I’d be glad to hear otherwise.
View Answer
| November 25, 2008 4:42 AM
Localization, VBA, VBA for AutoCAD, Visual Basic for Applications
How to use Access object library in my Windows application
In VBA if you want a late bound Access application reference, try this: Dim accApp As Object Set accApp = CreateObject(“Access.Application”) If you want an early bound reference, set a reference to the Access library (go to Tools>References) and use this code: Dim accApp As Access.Application Set accApp = CreateObject(“Access.Application”)
View Answer
| November 25, 2008 4:38 AM
Database programming, Microsoft Access, OpenCurrentDatabase, VBA, Visual Basic for Applications
In VBA if you want a late bound Access application reference, try this: Dim accApp As Object Set accApp = CreateObject(“Access.Application”) If you want an early bound reference, set a reference to the Access library (go to Tools>References) and use this code: Dim accApp As Access.Application Set accApp = CreateObject(“Access.Application”)
View Answer
| November 25, 2008 4:38 AM
Database programming, Microsoft Access, OpenCurrentDatabase, VBA, Visual Basic for Applications
Prompt for password on Linux mail server
You will need to disable anonymous access to your ftp server, but how to do that will depend on what is your linux distribution, and/or what FTP server software you have installed. Please provide more details, and we will be able to give more useful answers.
View Answer
| November 25, 2008 1:51 AM
Linux, Linux administration, Linux FTP, Linux mail servers, Linux security, Linux servers, Remote access, Secure FTP, Secure remote access, SFTP, User Permissions, Web security, Web servers
You will need to disable anonymous access to your ftp server, but how to do that will depend on what is your linux distribution, and/or what FTP server software you have installed. Please provide more details, and we will be able to give more useful answers.
View Answer
| November 25, 2008 1:51 AM
Linux, Linux administration, Linux FTP, Linux mail servers, Linux security, Linux servers, Remote access, Secure FTP, Secure remote access, SFTP, User Permissions, Web security, Web servers
When a Test Engineer needs to be promoted? How to set the expectations at each level?
If these things are not written down as policy then perhaps it is time to do so. If a policy is clearly defined then all would have to be held accountable to it. Perhaps the manager is just going by his own personal feelings on the issue instead of a clearly defined policy? If this [...]
View Answer
| November 24, 2008 7:03 PM
Senior Test Engineer, Software Quality, Software Test Architect, Software Test Engineer, Software Test Lead, Software testing, Software testing jobs, Test Engineer
If these things are not written down as policy then perhaps it is time to do so. If a policy is clearly defined then all would have to be held accountable to it. Perhaps the manager is just going by his own personal feelings on the issue instead of a clearly defined policy? If this [...]
View Answer
| November 24, 2008 7:03 PM
Senior Test Engineer, Software Quality, Software Test Architect, Software Test Engineer, Software Test Lead, Software testing, Software testing jobs, Test Engineer
Hotel database (Rooms availability) using Access 2007
If I understand well, that would be with a query like this: select * from rooms where availability = "vacant" As we don’t know the data types of the fields, the condition in the where clause could need to be changed. If that’s not what you meant, please provide more information in the discuss section.
View Answer
| August 8, 2012 2:16 PM
Access 2007, Database programming, Microsoft Access, Microsoft Access 2007
If I understand well, that would be with a query like this: select * from rooms where availability = "vacant" As we don’t know the data types of the fields, the condition in the where clause could need to be changed. If that’s not what you meant, please provide more information in the discuss section.
View Answer
| August 8, 2012 2:16 PM
Access 2007, Database programming, Microsoft Access, Microsoft Access 2007
How to identify creative test cases which finds unique bugs and accelerates the quality product releases to the market?
I think there is no tool that can be as creative as a human. Tools do what they are designed/programmed to do, so if you want creativity, that is a position for a human, not a tool. Regards, -Carlosdl
View Answer
| November 24, 2008 1:50 PM
Functional testing, Software Break Points, Software load testing, Software Quality, Software testing, Software testing tools
I think there is no tool that can be as creative as a human. Tools do what they are designed/programmed to do, so if you want creativity, that is a position for a human, not a tool. Regards, -Carlosdl
View Answer
| November 24, 2008 1:50 PM
Functional testing, Software Break Points, Software load testing, Software Quality, Software testing, Software testing tools
Testing bugs not in the specification
All bugs should be tested and reported, and enough time must be allowed to do it. In fact, a software testing/quality assurance engineer should always be trying to find new bugs no matter what stage of the quality assurance process he is in, but how you should manage these new bugs depends on your organization’s [...]
View Answer
| November 24, 2008 4:50 AM
Software Quality, Software Quality Assurance, Software testing
All bugs should be tested and reported, and enough time must be allowed to do it. In fact, a software testing/quality assurance engineer should always be trying to find new bugs no matter what stage of the quality assurance process he is in, but how you should manage these new bugs depends on your organization’s [...]
View Answer
| November 24, 2008 4:50 AM
Software Quality, Software Quality Assurance, Software testing
Adding click event to textbox in HandHeld PC
I had to do a Windows Mobile project earlier in the year, and although it used c#, my group and I realized that a lot had been stripped from the mobile libraries. Including simple things like a click event. However, they still can be achieved, you just have to do more digging. It turned out [...]
View Answer
| November 23, 2008 7:03 PM
C#, Click Event, Handheld PC, TextBox
I had to do a Windows Mobile project earlier in the year, and although it used c#, my group and I realized that a lot had been stripped from the mobile libraries. Including simple things like a click event. However, they still can be achieved, you just have to do more digging. It turned out [...]
View Answer
| November 23, 2008 7:03 PM
C#, Click Event, Handheld PC, TextBox
