Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dlpastel
  • Content: Threads
  • Order by date
  1. dlpastel

    Auto Size Text Box Vertically but fixed Horizontally

    I am using a text box in a Word 2007 document. I would like it to stay a certain width whether text is added in or not however when the user reaches the end of the line and continues typing I would like the text box to grow vertically to accomondate the next line of text. Is this possible?
  2. dlpastel

    Averages of columns in a table with SQL

    In reference to the chart below: Date Callers Times Called 09/21/2009 2 1 09/21/2009 3 2 09/21/2009 1 3 09/22/2009 1 10 09/22/2009 2 3 09/22/2009 3 4 I am trying to get an average number of the two above columns. I am using the code below. The problem seems to be the "GROUP BY...
  3. dlpastel

    jet sql to transacgt sql for datetime

    I have an access database which will be ported over to sql server however, sql server seems to automatically store the date with the time as 07/09/2008 12:00:00:00 This is for a telephony program so the caller would punch touch tones of 070908 Normally my query for access would say "select...
  4. dlpastel

    BDP Lite Parser Error

    Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: Could not load file or assembly...
  5. dlpastel

    Identity_Insert ON

    I am using Visual Web Developer 2008 and SQL Server 2005. I am trying to set up a autonumber type of incrementation as I had done with MS Acess I keep getting the error: Cannot insert explicit value for identity column in table 'ApcToDo' when IDENTITY_INSERT is set to OFF. I am not sure where...
  6. dlpastel

    Can't connect to SQl server 2005

    I am developing a web site with Visual Web Developer Express and it works fine on my local server provided by Visual web developer. But when I upload the files and try to access the web login control I get the following error: "An error has occurred while establishing a connection to the...
  7. dlpastel

    MsChart Help

    I am trying to graph an average lifetime of a pay customer in our Clients database The fields I am using are: StartDate (day the person joined) LastUsed (last time the person used the system) MemberType (Payline or Freeline customer) I want to chart a average that spans a specifed date range...
  8. dlpastel

    PADL

    I have a numeric value in a database field that is set up as 7,2 format (7 total length with decimal point at 2) I am trying to change numeric values to a string. For example I would like to change 148.32 to "0014832" or 50.00 to "00005000" It seems like I need to use a combination of STR()...
  9. dlpastel

    Run Windows App From Clipper

    I am trying to run a windows app called txttopdf.exe from a a Clipper application. My clipper program reads the line of code: Run ("C:\Utility\txttopdf.exe") but nothing happens. So I tried just to open a dos window by writing a program with only one line: Run "C:\Winnt\System32\cmd.exe" and no...
  10. dlpastel

    Source Code Version Documentation

    Is there any program add on that can be used with VB6 to document source code changes besides Visual Source Safe. I just want a easy way to document what was done in each version. Thanks, Dan
  11. dlpastel

    Error 67 Too many files

    I have a program that gets very busy from time to time and when I try to do a FreeFile it says Error 67 Too many files. How do I get around this. 1. Do I add a files= statement to config.sys. 2. I do not have a config.sys. Do I create one in the root? 3. How can I find out how many files are...
  12. dlpastel

    Opening a dbase file with ODBC

    I am trying to open a Clipper dbase III file and get the error: [Microsoft] [ODBC dBase driver] Index file not found I do not use any ndx indexes with the dbf. I do use nsx indexes but I do not need to open any indexes for what I want to do. How do I get around the error? Below is my code...
  13. dlpastel

    Using colorblock

    I am trying to use the colorblock feature to change the color of all columns on a single record or multiple records on my browse screen depending upon the field value of my database field "Area" I want that if the value of my field "Area" is "A" then all columns for all records with the value...
  14. dlpastel

    Sorting Files from Newest to Oldest with Dir

    I need to sort the filenames in a directory from newest to oldest with the Dir command. I know the Dir command does not include this feature and I believe you need to use a array. Could someone show me how to do this? I want to sort the following filename from newest to oldest...
  15. dlpastel

    Multiuser app

    I am trying to prevent one user from accessing a ADO record on a sql server database if another user is already in that work order. I would like to tell the second user that this record is now being opened in read only mode. I am opening the record as adlockpessimistic Then I change a field...
  16. dlpastel

    Deleting records from multiple tables with Sql Server and ADO

    I am trying to delete records from several tables in a SqlServer database where each table has a common work order number (called jobnum) I want to use the Invoice.jobnum field to delete records with the same jobnum in several different tables. Here is the code: 'Delete a invoice...
  17. dlpastel

    Storing and retrieving dates with Mask Edit Box

    I am trying to figure out the best way to store and retrieve dates. I keep getting errors when I run the following code.: (For retrieving records from the database and putting them into the mask edit control) Sub EditRecord(aForm As Form, aRecordset As ADODB.Recordset) Dim c As Control...
  18. dlpastel

    Saving the immediate window

    Is there a way to save the immediate window, or is it available as a file somewhere? I do a lot of debug.prints that I would like to view later Thanks, Dan
  19. dlpastel

    Bad index expression error 610 with Six driver

    Strangest thing has started happening. I use 5.2e with the Six driver rdd. I keep getting "Bad Index expression error 610 whenever I try to add code ANYWHERE in my program. I can even just put FUNCTION TEST RETURN anywhere in my program and after I compile it and try to run the program I get...
  20. dlpastel

    Convert dbt files to fpt files

    I have a Clipper program which was using the ntx driver. I want to now use the cdx index. I added the library to the link script and that works but I can no longer read the memo fields. Is there something else I have to do like convert the dbt memo fields to foxpro style files? Thanks, Dan

Part and Inventory Search

Back
Top