Search:

Type: Posts; User: jpskiller

Page 1 of 4 1 2 3 4

Search: Search took 0.02 seconds.

  1. VS 2010 Re: Open and Refesh several excel files at same time Help

    I have updated the task start to


    Dim tasks As New List(Of Task)()
    tasks.Add(Task.Factory.StartNew((Sub() OpenExcel("C:\Temp\Excel\Book1.xlsx")), CancellationToken.None,...
  2. VS 2010 Re: Open and Refesh several excel files at same time Help

    Great should be able to work out so way to write to a form control.

    Do you have any examples of how I could track the threads I start with the above method fso I know when they have completed so I...
  3. VS 2010 Re: Open and Refesh several excel files at same time Help

    Cheers, that's great, this multithreading is useful but also getting complicated very quickly

    How on earth would I update controls on a form, I added to end off Procedure OpenExcel:


    ...
  4. VS 2010 Re: Open and Refesh several excel files at same time Help

    Hi,

    Managed to get it working by using the Task.Factory.StartNew



    Dim tasks(2) As Task
    tasks(0) = Task.Factory.StartNew((Sub() OpenExcel("C:\Temp\Excel\Book1.xlsx")))...
  5. VS 2010 Re: Open and Refesh several excel files at same time Help

    Thanks for this,

    I have added Imports System.Threading.Tasksbut have following issue the Task.Run gives me an error 'Run' is not a memeber of 'System.Threading.Tasks.Task'

    Is this because of...
  6. VS 2010 Open and Refesh several excel files at same time Help

    Hi,

    I am attempting to write a basic excel automation program, which will have a scheduling system, so could have several files which need to be refreshed at same time, but may take different...
  7. VS 2010 Re: Save and Load Treeview with additional options

    Cheers for the advice I have spent more time experimenting and believe I will be able to sort it now, won't be the most efficient method but I can get it working by modifying existing code to add...
  8. VS 2010 Save and Load Treeview with additional options

    Hi,

    I have found code that allows me to save and load a treeview to an xml file, but this just save and loads the node text, I would like the ability to also save the additional options. i.e. the...
  9. Replies
    2
    Views
    3,631

    VS 2010 Re: SqlBulkCopy Change output column types

    Hi,

    I have just tried create the table as you said then fill the data adapter but got exact same error 'the given value of type String from the data source cannot be converted to type nvarchar of...
  10. Replies
    2
    Views
    3,631

    VS 2010 SqlBulkCopy Change output column types

    Hi,

    I am trying to import a large excel file 200+ columns into a sql table, when the excel file is created sometimes several of columns will be float but the main table was built with these...
  11. VS 2013 Re: MySql connector Too many connections error

    Hi,

    I realise this is a really old thread but I have a quick question.

    While the following method will open and close the connections to the SQL server, is this automatically handled when using...
  12. VS 2010 Re: Datagrid Copy All selected rows or Drag and drop all Selected rows need help plea

    Cheers for that, still new to this but Im sure I will be able to sort it now.
  13. VS 2010 Re: Datagrid Copy All selected rows or Drag and drop all Selected rows need help plea

    wow that great thank you very much, one more question how would you drop the grid data onto another control type, lets say a text box or a listbox
  14. VS 2010 Datagrid Copy All selected rows or Drag and drop all Selected rows need help please

    Hi,

    I am unable to get a working solution that would allow me to select multiple rows in a datagrid and drag to another, I am only able to achieve this via a button.

    I have searched around and...
  15. VS 2010 Re: Datagridview button not working when use databoundfilter

    Your absolutely right it was the text box validate, I had forgotten to remove It, it was there because I was experimenting with text change / Validate methods.

    Thank you.
  16. VS 2010 Re: Datagridview button not working when use databoundfilter

    Hi, sorry.

    When the grid is unfiltered then it fires the DataGridView1_CellContentClick and executes the code as expected.

    If the grid is filtered then when I click on button, then...
  17. VS 2010 Datagridview button not working when use databoundfilter

    Hi,

    Appeciate some help please.

    I have a datagridview which I have added a button into.

    When the grid is unfiltered the button works fine but when I apply the filter it does not appear to...
  18. Replies
    2
    Views
    3,200

    VS 2010 Re: Sending application wide Alert

    Thanks for the info that's helpful.

    The Access db started as read only access and had no need for users to write to it, I came up with the idea of alerts/notifications recently, and do have access...
  19. Replies
    1
    Views
    3,395

    VS 2010 Re: RichTextBox Issue with Table formatting

    bump, anyone any ideas
  20. Replies
    2
    Views
    3,200

    VS 2010 Sending application wide Alert

    hi,

    Just need little help with logic please.

    If I have a application open on 20+ system, all of which could be opened at different times.

    How would I be able to ensure an Alert went to all...
  21. Replies
    1
    Views
    3,395

    VS 2010 RichTextBox Issue with Table formatting

    Hi,

    Does anyone have a fix for the issue with RichTextBox and Tables

    I.e.

    Table looks like this in .rtf file

    146805
  22. Replies
    1
    Views
    860

    VS 2010 Re: SMTP Outlook 365 Citrix Issue

    any suggestion?
  23. Replies
    1
    Views
    860

    VS 2010 SMTP Outlook 365 Citrix Issue

    Hi,

    I have a application at work that users use to help fill in templates, it then populates outlook with all relevant information to send.

    My works is currently moving over to Outlook 365, so...
  24. Re: [.NET 2.0+] Visual Studios "My Project" Tab Control (Updated! 12/9/2009)

    Does any one know how I could draw a line on a tabpage using this ta control
  25. Re: [.NET 2.0+] Visual Studios "My Project" Tab Control (Updated! 12/9/2009)

    This is great

    I am using the one modified by i00

    Are you able to change font and size of font on tab text, when I tried it made no difference
  26. VS 2010 Re: VB Datagridview Text box to combobox (distinct) when data is using bindingsource

    Thanks for info guys
  27. VS 2010 VB Datagridview Text box to combobox (distinct) when data is using bindingsource

    Hi,

    I have created Dataset in vb and have bound it to a datagridview control.

    just 4 columns: ID (Primary Key), Name, Active, Role

    At the moment it allows me to add, update details.

    What...
  28. Datatable to Treeview where root is null

    Hi,

    I need some help.

    I have created a hierarchical table in following format

    see thread : http://www.vbforums.com/showthread.php?843851-Create-Tiers-Logic-for-unlimted&p=5143289#post5143289...
  29. Replies
    5
    Views
    799

    Re: Create Tiers Logic for unlimted

    Thanks techgnome for your help I have managed to find information about The Adjacency List Model from http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/

    With help of you and this...
  30. Replies
    5
    Views
    799

    Re: Create Tiers Logic for unlimted

    Hi

    Database is SQL server 2005 and front end will be done in vb 2010

    Options are not unique, option 4 options could be same as another options 3 etc.

    if I can see an example table which has...
  31. Replies
    5
    Views
    799

    Re: Create Tiers Logic for unlimted

    thanks I'm still stuck with multi tables in my head and cant see how to structure a flat table with all options that relate back to each other on deeper levels, I know that is the best way to go but...
  32. Replies
    5
    Views
    799

    Create Tiers Logic for unlimted

    Hi,

    Not sure where to ask this but will try here first.

    I am trying to put together a piece of software which will walk you thru a task by giving appropriate answers depending on your selection...
  33. Replies
    4
    Views
    1,033

    Re: Excel Export Text Format Issue

    Thanks I've marked thread as resolved. I presume that closes it.
  34. VS 2010 Re: LineShape, RectangleShape ect Dont work correctly in Panel Container

    Thanks I decided to to use a group box I had for putting the labels etc in
  35. VS 2010 Re: LineShape, RectangleShape ect Dont work correctly in Panel Container

    Cheers, I had never used them before, seem ok on a static form but not anything that moves.
  36. VS 2010 LineShape, RectangleShape ect Dont work correctly in Panel Container

    VB 2010


    H,

    I have a winform with a splitter control on

    Top panel is fixed, headings etc

    Bottom Panel will have a list of questions so this is scrollable.
  37. Replies
    4
    Views
    1,033

    Re: Excel Export Text Format Issue

    Cheers managed to get working with minor change to fit my range.



    Dim formatRange As Excel.Range
    formatRange = oSheet.Range("C:C")
    ...
  38. Replies
    4
    Views
    1,033

    [RESOLVED] Excel Export Text Format Issue

    Hi,

    I am having issue with exporting my dataset to excel on one of the columns.

    The data in the column is stored as text and should always be around 19 chars long.

    Issue is the exported...
  39. Replies
    9
    Views
    1,171

    Re: Continuous Display or Data From DataTable

    Thanks got it working now

    I dragged my Datasource on to the DataRepeater and that works fine, so I added a button and in the button On Click Event I added


    Private Sub Button1_Click(sender...
  40. Replies
    9
    Views
    1,171

    Re: Continuous Display or Data From DataTable

    Next daft question

    If I put on a button in the DataRepeater from the click event on the button how would I get the reference to the row I was on so I could then reference the data in textboxes etc.
Results 1 to 40 of 122
Page 1 of 4 1 2 3 4



Click Here to Expand Forum to Full Width