Search:

Type: Posts; User: Tim_p

Search: Search took 0.02 seconds.

  1. Replies
    5
    Views
    1,463

    Re: sqlite search all columns

    Hi all,
    Thanks for taking the time to read and reply to my question I will try and format questions better in the future.

    I really like the look of jmcilhinney of being able to check within...
  2. Replies
    5
    Views
    1,463

    sqlite search all columns

    Hi all,

    Im building a small app that has an sqlite Db attached so i need to create a user search function but I don't want the user to have to state which column the string they are looking for is...
  3. Replies
    6
    Views
    1,701

    Re: extracting all pdfs saved into access database

    hi adding where ID is not null would be good but I'm having trouble with the syntax what iive got is but it gives me an error conversion from type string to Boolean is not valid

    Select * from...
  4. Replies
    6
    Views
    1,701

    Re: extracting all pdfs saved into access database

    Hi thanks for the reply sorry for the poorly worded question yes the value is null I'm just trying to skip over these ones

    many thanks tim
  5. Replies
    6
    Views
    1,701

    extracting all pdfs saved into access database

    Hi all,

    So I'm migrating our current system away from MS access to an alternative system my final part of this is to extract all of the pdf's that have been attached to an access database.

    So...
  6. Replies
    8
    Views
    1,878

    Re: adding a timer to function

    Hi Thanks for the detailed reply I like the idea of just adding a delay and a loop so ive come up with this in my background worker it seams to work well and gives me control if the process has been...
  7. Replies
    8
    Views
    1,878

    Re: adding a timer to function

    Hi thanks for taking the time to read through.

    I think lack of sleep led to calling that function twice. It should be if count = 1 but like you said theres a bit of a problem with my logic.
    so...
  8. Replies
    8
    Views
    1,878

    adding a timer to function

    Hi all

    Im trying to add a timer to a function to a sub routine in case the process runs for to long so the current function waits until there is only one file left before allowing the function to...
  9. Replies
    2
    Views
    963

    Re: datagridview datatable date sort

    hi I had to use dateparseexact but you helped me get it over the line


    dt.Rows.Add(CStr(fields(0)), Date.ParseExact(fields(1), "dd MMM yyyy", provider)

    thanks tim
  10. Replies
    2
    Views
    963

    datagridview datatable date sort

    Hi All,

    Im fetching info from a csv file and importing it in a datatable then a datagridview i'm whising to sort by date but as the info are just stored as strings I need to convert them into...
  11. Thread: Update Csv file

    by Tim_p
    Replies
    2
    Views
    1,359

    Re: Update Csv file

    Worked like a charm
    Thanks
  12. Thread: Update Csv file

    by Tim_p
    Replies
    2
    Views
    1,359

    Update Csv file

    Hi all I’m trying to update a single value in a csv file I wish to change the value of one column from a 1 to 2

    I can find the correct row using


    dim lines() as string =...
  13. Thread: file locked

    by Tim_p
    Replies
    4
    Views
    1,002

    Re: file locked

    Thanks
    That works a treat
  14. Replies
    2
    Views
    792

    filtering datagridview

    Hi all i'm trying to filter a datagridview I'm getting an error
    unable to cast
    system.data.dataview
    to type
    system.data.datatable




    Dim dv As DataView =...
  15. Thread: file locked

    by Tim_p
    Replies
    4
    Views
    1,002

    Re: file locked

    ok I guess I could compare the string it returns with what I expect it to be.
  16. Replies
    5
    Views
    1,874

    VS 2019 Re: Best / fastest way to read a xlsx file

    hi im currently using Closedxml https://github.com/ClosedXML/ClosedXML
    it seams very fast as well and doesn't need excel installed on the target machine
  17. Thread: file locked

    by Tim_p
    Replies
    4
    Views
    1,002

    file locked

    Hi all im trying to check if a file is locked.
    so we have a network excel file that many people edit im using closed xml to read this file in vb. this already works perfectly in a try catch...
  18. Thread: xml database!!

    by Tim_p
    Replies
    14
    Views
    2,128

    Re: xml database!!

    thank you :-)
  19. Thread: xml database!!

    by Tim_p
    Replies
    14
    Views
    2,128

    Re: xml database!!

    hi all,
    thanks for all your comments so far so ive been tinkering away with a question based system whereby I create a text file which any other users instance checks for if there are multiples...
  20. Thread: xml database!!

    by Tim_p
    Replies
    14
    Views
    2,128

    Re: xml database!!

    ok thanks for the input it may be an option ive heard of many negative things about access though somebody did have a version previously but they saved the images a blob entries? so I grew massive...
  21. Thread: xml database!!

    by Tim_p
    Replies
    14
    Views
    2,128

    Re: xml database!!

    another thought ive been having is a forward only written file whereby no matter what the user is doing adding or edit a record each new entry is only added to the end of the file this would then...
  22. Thread: xml database!!

    by Tim_p
    Replies
    14
    Views
    2,128

    Re: xml database!!

    Hi thanks for the reply so far many have tried to get a server or for them to roll out SAP to our site but it didn't happen pre covid its defiantly not going to happen when there is little money! :-(...
  23. Thread: xml database!!

    by Tim_p
    Replies
    14
    Views
    2,128

    Re: xml database!!

    the concurrency is what i'm worried about. I know a proper sql database would be the best option but it is not allowed along side keeping all our data only on our local network.
  24. Thread: xml database!!

    by Tim_p
    Replies
    14
    Views
    2,128

    Re: xml database!!

    I was looking at that this morning I believe it requires c++ runtime to be installed not sure if its preinstalled on our work computers
  25. Thread: xml database!!

    by Tim_p
    Replies
    14
    Views
    2,128

    xml database!!

    Hi all,

    Now before you say use sql my company/departments IT infrastructure is locked down we can't install any programs or use any outside (web based ) datastore.

    firstly yes anyone know if...
  26. Thread: filter datatable

    by Tim_p
    Replies
    21
    Views
    4,177

    Re: filter datatable

    Hi
    Ive just been think wether im using the best method, im worried about excessive memory usage.
    My dtaviews are declard at outside of a subroutine so they are accessable to several routines.
    So...
  27. Thread: filter datatable

    by Tim_p
    Replies
    21
    Views
    4,177

    Re: filter datatable

    thanks all im looking into it now
  28. Thread: filter datatable

    by Tim_p
    Replies
    21
    Views
    4,177

    filter datatable

    Hi all,

    Im currently trying to extract information from excel and display it in a different way so ive managed to pull the info from excel using


    'Open the Excel file using ClosedXML.
    ...
  29. Replies
    2
    Views
    933

    Standalone with database

    Hi all,
    I work for a small offshoot of a large company with very restrictive IT infrastructure only approved programs may be installed. Currently excel is used for far too many tasks that really...
Results 1 to 29 of 29



Click Here to Expand Forum to Full Width