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 IamaSherpa 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. captphan

    Formatting with Macros Excel 2003

    Excellent thank You I am glad I don't know it all because then I would be bored. -Obie
  2. captphan

    Troubling saving in Excel 2003 after Formatting with a Macro

    When ever I format Cells.Select Cells.EntireColumn.AutoFit using a Macro in Excel 2003, Excel crashes when I save the file. The only error message is Micrsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience. Has anyone else run into this and...
  3. captphan

    Formatting with Macros Excel 2003

    I save succesffuly before Cells.Select Cells.EntireColumn.AutoFit The only error message is Micrsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience. I am glad I don't know it all because then I would be bored. -Obie
  4. captphan

    Formatting with Macros Excel 2003

    When ever I format using a Macro in Excel 2003, Excel crashes when I save the file. Has anyone else run into this and no of a work around. I am glad I don't know it all because then I would be bored. -Obie
  5. captphan

    How do I do the equivalent of a dlookup

    I am codin in vb.net I am glad I don't know it all because then I would be bored. -Obie
  6. captphan

    How do I do the equivalent of a dlookup

    This is where my lack of experience using these tools comes into play. is it Varaiblename = "SELECT YourColumnName FROM YourTable WHERE KeyColumn = YourKeyColumnValue" I am glad I don't know it all because then I would be bored. -Obie
  7. captphan

    How do I do the equivalent of a dlookup

    I am doing some work with my database on a web page using VB. I want o grab just the value of one column from a row I have the key for. In access and VBA I would use the dlookup function. How do I do this in SQL server. I am glad I don't know it all because then I would be bored. -Obie
  8. captphan

    Chart Mean and Std Dev

    I figured something out and the fact that noone replies suggests I should share. I now have a chart that looks like this | | | | | | + + | + | | + | | | | | I was able to do it using the Stock chart. If you ever need help post here and I will give the dirty details I am...
  9. captphan

    Front End Development Tools

    I have been trying to get the reporting tools am I unable to get them because I have SQL Server Management Studio Express and not a full version of SQL on my computer. My company has a full liscence. I am glad I don't know it all because then I would be bored. -Obie
  10. captphan

    Chart Mean and Std Dev

    I am using Crystal 11 I have a table with Means and Stddev. I want a chart that Plots each mean and then adds bars up and down for the StdDev. so each point would lool like _ | * | - Any thoughts? I am glad I don't know it all because then I would be bored. -Obie
  11. captphan

    Front End Development Tools

    Sorry Assuming the quality of the Canidates for each langauge ... I am glad I don't know it all because then I would be bored. -Obie
  12. captphan

    Front End Development Tools

    Assumiong the quality of each langhuage is equal what way would lend it self to thmost secure site. I will be dealing with medical inforamtion so this is a major concern. I am glad I don't know it all because then I would be bored. -Obie
  13. captphan

    Front End Development Tools

    Thanks the only thing I thought I had decided on is now in flux. JK I do appreciate the input. Since your answer moved away from where I though I was heading with my question let me reword it. What really is my best way to access the data securly and have a pretty web page? I have read about...
  14. captphan

    Front End Development Tools

    I am building a large project on a SQL Server backend, and am not sure what the best tools for front end development are. Although a developer with experience in a multitude of languages myself, I am in position to hire people to help with what ever skills I need so my personal knowledge is not...
  15. captphan

    Move a field out of the way of another field

    Brain fart I got it now sorry I am glad I don't know it all because then I would be bored. http://goallineblitz.com/game/signup.pl?ref=9436220 -Obie
  16. captphan

    Move a field out of the way of another field

    I have a field where I have checked can grow above another field in the data section. How do I ensure that if the top field does grow the other field moves down? I am glad I don't know it all because then I would be bored. http://goallineblitz.com/game/signup.pl?ref=9436220 -Obie
  17. captphan

    Connect to Excel

    Thank you for pointing me in the correct direction. I am glad I don't know it all because then I would be bored. http://goallineblitz.com/game/signup.pl?ref=9436220 -Obie
  18. captphan

    Connect to Excel

    My issue is figuring out how to creat a linked server. I am glad I don't know it all because then I would be bored. http://goallineblitz.com/game/signup.pl?ref=9436220 -Obie
  19. captphan

    Connect to Excel

    I have an excel spread sheet that is changed weekly. I need to get this data into SQL or Crystal to generate a report. I am new to SQL and am actually using SQL Server Management Studio Express. When I lived in the tiny world of Access I could simply create a link to the Excel Spread sheet...
  20. captphan

    Multi part identifier could not be bound

    I am brand new to SQL server and am getting the following error textMsg 4104, Level 16, State 1, Line 1 The multi-part identifier "dbo.XDS_Shift.userid" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "XDS_Location.userID" could not be bound. Msg 4104, Level...

Part and Inventory Search

Back
Top