Search:
Type: Posts; User: Tim_p
Search:
Search took 0.02 seconds.
-
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...
-
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...
-
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...
-
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
-
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...
-
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...
-
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...
-
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...
-
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
-
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...
-
Worked like a charm
Thanks
-
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 =...
-
Thanks
That works a treat
-
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 =...
-
ok I guess I could compare the string it returns with what I expect it to be.
-
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
-
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...
-
-
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...
-
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...
-
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...
-
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! :-(...
-
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.
-
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
-
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...
-
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...
-
thanks all im looking into it now
-
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.
...
-
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...
|
Click Here to Expand Forum to Full Width
|