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 Mike Lewis 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: wp1
  • Order by date
  1. wp1

    New to JS. Working with it in goog

    I got it. Took the ';' off the if(); condition area. Greg
  2. wp1

    VBA Access CSV file manipulation before import

    I will, next time I'm there. Thanks. and for you: https://thenextweb.com/dd/2011/12/12/finally-sarcasm-has-a-voice-in-print-with-its-own-font/#.tnw_cFF6YY30 thought you would get a kick out of this
  3. wp1

    VBA Access CSV file manipulation before import

    here is a picture of the error and the screen. Notice the 'Online Upload' button at the mid-right of the screen cap.http://files.engineering.com/getfile.aspx?folder=f6d8a9c4-43a4-4dec-8059-dd9bb5f45081&file=2017-08-12_11-13-37.png
  4. wp1

    VBA Access CSV file manipulation before import

    attached is the windows explorer screen capture showing filename and file locationhttp://files.engineering.com/getfile.aspx?folder=9abdcc68-14ed-41e3-930e-70ff03983d1f&file=pic.doc
  5. wp1

    VBA Access CSV file manipulation before import

    Yes. Here is code copied from the application computer. Private Sub Command107_Click() 'Added by Greg Martin 08042017 On Error GoTo Err_Command107_Click Dim strTextLine As String Dim aryMyData() As String Dim strSQL As String Dim directory As String Dim FileName As String Dim i As Integer...
  6. wp1

    OS and SQLServer Upgrade

    Connection string below works on Windows Server 2008 and SQLServer 2008 version 10. Upgraded both to WS 2012 and SQL server 2012 v 11 and this is broken. Had IIS installed, copied over ASP code...I think its the connection string. Does anything standout? strAnaCsvConnectionString =...
  7. wp1

    Database memory usage issue

    i take that back, when i went to database properties, it said FULL in the drop down list, BUT running your query returned SIMPLE
  8. wp1

    Database memory usage issue

    its Full. So a backup will reset the log file?
  9. wp1

    Database memory usage issue

    Msg 195, Level 15, State 10, Line 2 'Mishawaka' is not a recognized built-in function name.
  10. wp1

    Database memory usage issue

    also, not sure why it would crash over a big log file. over all size is 6.3gb data size is under 200mb. Its a transactional database used mainly for static referencing. There is some logging, but most of that is handled on another DB don't know how to tell growth rate. Can say its taken...
  11. wp1

    Database memory usage issue

    i just found that it was the log file. How do i safely purge this thing
  12. wp1

    Database base memory usage question!

    got it, it was the log file
  13. wp1

    Database memory usage issue

    PS I have over 50 GB of memory to on the virtual server. Its not a drive capacity issue.
  14. wp1

    Database memory usage issue

    I have a sql server 2008 database called Mish. It has crashed twice in the last 2 months and recovered both times fine. It said as of yesterday when looked at size in db properties, that it was 6.3GB in size and only had 10MB worth of storage left. First question is how is the size selected...
  15. wp1

    Database base memory usage question!

    PS. I have over 50 G of space left on the virtual server.
  16. wp1

    Database base memory usage question!

    I have a sql server 2008 database called Mish. It has crashed twice in the last 2 months and recovered both times fine. It said as of yesterday when looked at size in db properties, that it was 6.3GB in size and only had 10MB worth of storage left. First question is how is the size selected...
  17. wp1

    GetFiles()

    NEVERMIND THE FIRST QUESTIONS! I don't think my getfiles is working. it looked like my array was being reset with nothing in it. looking into that.
  18. wp1

    GetFiles()

    i am using the directory.getfiles feature. I have 169 files i am sifting through to grab filenames that match user input. My array is folderFiles that is setup for 200 slots. No matter what i do, when i run this line of code: folderFiles = System.IO.Directory.GetFiles(folderPath) I get...

Part and Inventory Search

Back
Top