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
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
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
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
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
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
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
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
View Answer | November 25, 2008 3:38 PM
IIS 6.0, PHP, Windows Web Server 2003
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
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
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 “**” Then: Exit Sub [...]
View Answer | November 25, 2008 4:57 AM
Excel macros, Macros, Microsoft Excel, VBA
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
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
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
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 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
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
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
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