Recent content by Trevil

Thanks kss444. Yes, the sample you show is what you get in the window -- which is a nice report -- but it doesn't easily allow me to do analysis. The output file I get is actually a "fixed-width" text file with all of the columns for the data. I added code in my program to just import that...

SWEEEEEET!! I just ran this: strSQL = "sqlcmd -S (local) -E -d MYDBNAME -Q""DBCC ShowContig With TableResults,ALL_Indexes"" -o""C:\TEMP\showcontig.txt"" MyAppId = Shell(strSQL, vbMinimizedFocus) Must have done something wrong -- because IT WORKED - FIRST TRY!! (And actually the output results...

Yes, I could do as you suggest, but being the lazy individual that I am, I want to automate the process as much as possible - plus I will not have 'hands-on' access to the database. We have servers running in 70 countries and I don't have access. I already have a scheduled task that runs a VB...

Trying to capture output from DBCC SHOWCONFIG WITH ALL_INDEXES to a file. I have seen examples using 'EXEC ...xp_cmdshell...' that allows output to a file, but access to the shell is blocked for security reasons -- and I don't want to enable it. Is there some other way to get the statistics...

I believe your combobox displays three columns that look something like: 1234 | Print123 | HP LaserJet Since the first field is the ID field, but you want them to type in the Code, which is the second field, you need to change your sql to be: SELECT tblProduct.ProductCode, tblProduct.ProductID...

Thank you very much for your input. 1. Yes, we created several different MDE's -- using different workstations in different environments. Normally we use a VB6 application that does "acApp.SysCmd 603, strDBPath, strMDEPath" but we also created an MDE by just doings "Tools | Database Utilities...

A simple example, assuming your table has fields named "FirstName" and "LastName", you could either have the query use: SELECT [firstname] & " " & [lastname] AS FullName FROM Contacts; or SELECT [lastname] & ", " & [firstname] AS FullName FROM Contacts; Learn from the mistakes of others. You...

If you're using VBA code for your import, then you could always have it either save using a sequence number (would either require a table with a record that has a value that is incrementes, or you could get a list of the files already saved and either increment or loop), or you could save and...

I see a few strange things: 1. Is the following really the code you are using? If gstSqlSort1 <> "" Then 'gstSqlOrderBy = gstSqlOrderBy & "," & gstSqlSort1 'End If because the 2nd & 3rd lines are comments. 2. In your 'Sort1_sub', you go to all of the trouble to build the sort...

What do you have for the properties "Limit To List" and "Auto Expand"? If you want a user to be able to enter a value not in your list, LTL must be "No"; If you don't have "Auto Expand" set to "Yes" the list will not narrow as you type. Learn from the mistakes of others. You won't live long...

We are testing a new release of an application developed with Access-2000, but find a very severe performance problem when the application is launched by a VB6 program that issues a SHELL command. When launching the application by double-clicking in Windows Explorer, one screen will load in 2...

Sorry, but SS only has the versions that have been actually checked back in. Any local changes that have not been checked in will only reside on the workstation where the changes were made. As suggested before, you should change all four SS options(Tools|SourceSafe|Options) to "ASK". Learn...

You can safely remove / alter indices, but I would suggest doing it when you have exclusive use of the database. You will need to remove the relationship BEFORE you remove the index. If needed, I have some code laying around. Learn from the mistakes of others. You won't live long enough to...

I think you would learn more by placing a breakpoint at the top of your code, then step through the code one line at a time. By doing that you will see where in your code that Outlook is popping up the interface. As a hint, it is where you are referencing message objects. Learn from the...

In order for you to change objects in your project, since you mention it is controlled by sourcesafe, you would have needed to check them out, or cheat and use something like notepad to avoid sourcesafe. Once you changed your files, did you ever check them back into sourcesafe? If not, then...