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 strongm 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: *

  1. dlpastel

    Auto Size Text Box Vertically but fixed Horizontally

    Thanks Skip, That worked great!
  2. 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?
  3. 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...
  4. dlpastel

    jet sql to transacgt sql for datetime

    Thanks for all the useful information. One last question. I have the opportunity at this point to handle dates any way I like, as datetime, smalldatetime or character fields since I am moving from Access to Sql Server. Is DateTime the way you would go?
  5. dlpastel

    jet sql to transacgt sql for datetime

    Because of our hardware, I am not able to use Sql Server 2008. The hardware must run on Windows 2000 unless we do a software upgrade costing 30K. Therefore I must use Sql Server 2005 which does not have that date field. It is possible that the time element of each field might not always be...
  6. 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...
  7. dlpastel

    BDP Lite Parser Error

    My bust. It turned out that I had the bin directory as a sub directory of my project, not in the root of the website. Now it works fine
  8. 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...
  9. dlpastel

    Identity_Insert ON

    Kind of new to this. Details.aspx would be the new page to link to right? But where do I find the Id and what is the pk?
  10. dlpastel

    Identity_Insert ON

    Thank you for the answer, that did it!. In this master-detail format, how would I put the details on a separate form so that when the user selects a row a separat page opens up with the Form View
  11. 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...
  12. 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...
  13. 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...
  14. dlpastel

    PADL

    Here is the code. I figured it out. atemp2:= alltrim(str(p_price)) && First change the numeric to a string and trim off spaces atemp2:= strtran(atemp2,".") && Next get rid of the decimal point atemp2:= padl(atemp2,7,"0") && Next pad the left hand side with 0's REPLACE &atemp WITH...
  15. 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()...
  16. 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...
  17. dlpastel

    Source Code Version Documentation

    I am ultimately just trying to document changes in my code and have it save within the code so I always have it. Might look something like this: Version Problem Resolution Date Complete 5.65 Crashes Changed code in myprocedure 03/27/06 I know I can just create a...
  18. 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
  19. dlpastel

    Error 67 Too many files

    Thanks!
  20. 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...

Part and Inventory Search

Back
Top