Search results

WayneRyan I should have mentioned this in the last post as this was the main purpose for this thread. To separate the data as shown above takes approx 25 seconds on a datafile with close to 4,000,000 records. That is absolutely amazing! Again Thanks for sharing this function with us!

WayneRyan Thank You so much for sharing this function with me. Your example was a great starting point for What I was trying to accomplish. My BarTime is actually stored as a long integer as opposed to actual time, so it was fairly simple to adjust your sample code to produce the desired...

Arnelgp I did originally try this method, leaving the rst recordset open and filtering the data as needed, but this method is actually almost 2 seconds slower per record then using the where clauses in the SQL statement...

Jiri I wasn't sure what you were saying. I've posted some sample data which I hope explains better what I'm trying to do. ID BarDate BarTime BarOpen BarHigh BarLow BarClose 342 1/3/1986 1000 210.19 210.19 210.19 210.19 343 1/3/1986 1001 210.2 210.2 210.2 210.2 344 1/3/1986 1002 210.18...

Brokkel Thanks, I look forward to seeing what you've come up with. I've been testing other methods but can seam to better the 3 seconds per record with the code I've posted above.

JHB In this particular example there would be a max of 60 records ( 1 for each minute of Data ).

Dave, I have a database of 1 Minute stock Data, Each record represents the (Date,Time,Open,High,Low,Close) for a 1 minute period going back 30 years. The databases for each stock has roughy 3.5 Million records of 1 minute data. I would like to create different time frames such as 5 minute , 30...

Hello guys I have this program (attached) that I've been working on that does work. It takes 1 Minute stock data and forms different time bars in this case 60 Minute time bars of the date, time, open,high,low,close. The problem is that it takes 25 seconds for each days of data, which is 8...

Thanks guys I was able to accomplish what i needed to with the following code. I have been told elsewhere that this was unecessary and waiting for explanation as to why but here's the Code. I can't say enough what forums like this and people like you guys are to novices like myself. Thank...

Thanks for the response guys. I was able to get the following code to work. I was trying to get a csv file to an array to an access table but some of the headers from the csv file violated access naming standards. since there could be several thousand folders modifying each csv file, Or using...

Hello I'm trying to parse the following into an Array by splitting the csv file using a "," comma separator. There should be 63 different data pieces in this File. When I do a count of them from the (ubound array) i only get 54. The last data piece on each row gets concatenated to the first...

Isskint I have tried this method but always get error message Field "?" doesn't exist in "TempTable". I have tried setting has field names to true but the data gets downloaded with names like (Date) which are reserved for access which also throws up an error. I understand the methods you...

Hello I'm trying to upload a csv file into an Array then add records to a table. I have the following code which gets the information from a csv file which works fine. Problems: 1. When i try to load this into an array , it does not return all the information. It will if a smaller amount of...

Thanks jdraw I will play around with that a little bit and see where that brings me.

I would like to be able to store the data in a table (Quotes). Preferably I would like to have a table ( Stock Tickers ) that would hold a list of stocks and then be able to append the new updated data to the table ( Quotes ). From there I could perform simple calculations and use the more...

Does anyone have a macro to download end of day stock quotes into access database. I would like to be able to choose a start date on the first download and then append the records on each subsequent download. I do this in excel to analyze a few stocks but would like to be able to do this in...

Thanks Bob and John This works Perfect!

Hello , I'm trying to open a form from a main form that gets information from the main form. I usually do this when only one argument needs to be passed, however I need to pass multiple arguments and the are all Numbers(Integers). I found some examples where you string them together with a...

SpentGezer, I was able to get the following to work: Me.Requery DoCmd.GoToRecord , , acLast Thanks for your input.

Hello, I am working on an estimating database. I have a form with 3 separate subforms. There are times when I need to price the same Project for several different customers. I created a Subroutine that copies the current record as well as the Subrecords for the corresponding Bid Number...