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!

Register Log in
  • Congratulations derfloh 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. lestatdelioncourt

    readout textfiles to table

    u can do this in VBA, or with a macro. If u want to do it manually just import the file into excel, select the column and copy/ paste transpose. This will convert the column into a row. Here is the macro to do one file (called:tran001.txt) Sub Macro1() ' ' Macro1 Macro ' Macro recorded...
  2. lestatdelioncourt

    clean up the database

    it depends on ur skill level. You can: 1) use an update query to update the column (would have to do each variation in spelling singly. i.e. one run to correct REMO to REM, one to do REMS to REM). 2) use a macro to do the update. 3) Use a vba module. This has the most flexibility and could...
  3. lestatdelioncourt

    Simple RegEx Problem

    or: Dim test As String = "c:\My Documents\Records\2096 My FileName.pdf" Dim fileName As String fileName = Regex.Split(test, "\\").Last.Substring(Regex.Split(test, "\\").Last.IndexOf(" ") + 1, Regex.Split(test, "\\").Last.IndexOf(".") - Regex.Split(test, "\\").Last.IndexOf(" ") - 1)
  4. lestatdelioncourt

    Simple RegEx Problem

    here is an example using regex: Dim test As String = "c:\My Documents\Records\2096 My FileName.pdf" Dim res As String() Dim fileName As String res = Regex.Split(test, "\\") fileName = res(res.Length - 1) fileName = fileName.Substring(fileName.IndexOf(" ") + 1, fileName.IndexOf(".") -...
  5. lestatdelioncourt

    Calling a procedure in a different workbook (Excel)

    this does too: Run ("workbook1.xls!Test()")
  6. lestatdelioncourt

    Calling a procedure in a different workbook (Excel)

    this seems to work: Private Sub CommandButton1_Click() ActiveSheet.Cells(1, 1).FormulaR1C1 = "=Workbook1.xls!Test()" End Sub
  7. lestatdelioncourt

    Unexplained increase in Database size

    you do not need to use code. in the database properties is an automatic compact on close option
  8. lestatdelioncourt

    Unexplained increase in Database size

    you do nto need to use code. in the database properties is an automatic compact on close option
  9. lestatdelioncourt

    New to VBA calling APIs Please help!!!!! - thanks

    looks like ur problem with the HLLAPI is that u need to call start up first: http://support.attachmate.com/manuals/extra/apis/whllapi.pdf
  10. lestatdelioncourt

    New to VBA calling APIs Please help!!!!! - thanks

    hi, I have done a similar thing before but I embeded the rumba window directly into access. This allows u to connect to the mainframe and do all of the processing without having to do sendkeys. This was a good few yrs back, so I can not remeber exactly how to do it, might be worth lokking into...
  11. lestatdelioncourt

    Code to export data from grid to excel in vb.net2005 or vb.net

    the excel interop relies on excel being installed where the program is run.
  12. lestatdelioncourt

    Code to export data from grid to excel in vb.net2005 or vb.net

    look into the excel interop classes, these allow u to create an excel spreadsheet, and populate the data.
  13. lestatdelioncourt

    Need help to correct code that runs append queries

    you could just check to make sure that the previous days data is in the tables before u run the queries. (might not work if there is no data for weekends/ holidays). Alternatively change the process that populates the previous days data to populate a run date somewhere, then even if there is no...
  14. lestatdelioncourt

    PictureBox Help

    set the background of each horse to transparent, not white
  15. lestatdelioncourt

    Hiding and reshowing Custom Dialogs

    the: Dim Primary As New Form needs to be global then in ur code do: Private Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click Try Primary.Show() Catch ex As NullReferenceException Primary = New...
  16. lestatdelioncourt

    Problem with UPDATE sql command not changing values on VB form

    not sure what ur actual sql statment is, but u could try this: dim sqlStmt as sting = "update nodes set showid ='" & showid.text.Trim() & "' WHERE nodeid = '7'" or if the showid is a number in the db converr it first. i.e. dim sqlStmt as sting = "update nodes set showid ='" &...
  17. lestatdelioncourt

    C# Web Service Error

    Thanks, I worked it all out. The companies anti virus was blocking port 80. Therefore preventing access to the web service.
  18. lestatdelioncourt

    C# Web Service Error

    I have developed an ASPX site on a lap-top with a local copy of SQL server. This site uses an ASPX page to connect to a C# WebService to retrieve data. This all works fine. However when I move the site onto a desk-top PC (Same versions of VS and .Net Frame work). The WebServices are still local...
  19. lestatdelioncourt

    Windows services with C#

    Simple. File new Visual C# Projects Select Windows Service Click Ok Click Switch to code view then add your code where required
  20. lestatdelioncourt

    Hidden Access unhiding on VBA export

    This does not have any effect, the database window is still unhidden

Part and Inventory Search

Back
Top