Search results

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...

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...

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...

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...

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...

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...

Hello, I have an estimating database. Which generally gets data from 4 different Tables. I Have a form with a Bound main form and 3 Bound subforms to get this data This has been working well. There are times that I need to create an Identical Estimate for different customers. I now manually...

Hello, I'm getting an Error ( Error in From Clause ) with the following Statement: strSQL = "SELECT * FROM [Bid Work Type SubCategory] WHERE [BidWorkTypeCategoryID]= " & strCategoryID Set rsN1 = New ADODB.Recordset rsN1.CursorType = adOpenKeyset rsN1.LockType =...

Hello, I have an unbound Employee Time Card form that Inserts many records at once. I use a combobox to display the active employees. I'm trying to create a macro that would set a true / False field to true (in Employees table) after this employees records have been added. Once the employee...

Hello, I have a form that uses a combobox filter. it works for all the records except the first record. When I select the first record I get an error message..(Either BOF or EOF is True. I would assume that it would be true as the record selected is the very First One. I have played around with...

Hello, I'm experimenting with splitting my access database and possibly using Vb.net or other as a front end. I have begun updating my forms to unbound forms and populating,adding,deleting etc.. with them using ADO. This has gone well and all forms are working properly. My question is that I...

Hello, I've created an unbound form to for experimental purposes. I have navigation buttons to move to first,last,next,previous. I get an error message if I'm at the last record and hit the move next command button. I've been experimenting with EOF and BOF if statements But I keep getting the...

Hello I have the following code to populate an unbound form. I keep getting the Error Message (Invalid Outside Procedure). Does anybody know why Option Compare Database Private rstEmployees As ADODB.Recordset Private cnn As ADODB.Connection Private Sub Form_Open(Cancel As Integer)...

Hello, I have a project in which I need to populate an already designed Excel form. I use an access database to store the data. I have created a query that assembles the needed data. I filter this data down by using a (StartDate,EndDate, and Project ID) Parameter. To make this easier to filter...

Hello, I'm trying to create a macro takes data from an access database record-set and fill out a form using this data. I get the record-set into excel alright I'm not sure about how to go about transferring the data over. I've enclosed the excel spreadsheet which has 2 sheets on for...

Does anyone know if you can use 2 Parameters in a Dmin Function. For Example: Public Function ClosestToTiebreakerPoints(WeekNum As Integer, MostWins As Integer) As Double ClosestToTiebreakerPoints = DMin("TieBreakerPoints", "WeeklyCountWins", ("Week =" & WeekNum & ")And("NumberWins =" &...

I'm having a problem with the proper syntax for a query Statement and I'm getting An Error 3075 Syntax Error. Sql2 = "SELECT WeeklyPicks.GameID, WeeklyPicks.Week, WeeklyPicks.Username, WeeklyPicks.Pick," & _ "qryCalculateScores.Winner, WeeklyPicks.TieBreakerPoints" & _...

I was wondering if it is possible to reference a textbox name property with a variable. I have a form that has 16 textboxes (txtHome-1 - txtHome-16) I was hoping to be able to loop through them and fill each textbox with different Data without having to specifically set all txtBoxes...

I was wondering if it is possible to open a treeview control expanded to a certain child node. I use a form(Form1) with a treeview control to make a selection which populates a subform (On the same form as the Treeview control) which is bound to a record from an access table. Some fields of...

Can any one tell me the proper syntax for the Statement below: strSQL = "SELECT * FROM [Work Type SubCategory] WHERE [Work Type Category ID]= strCategoryID" strSQL is Text Work Type SubCategory is a Table Work Type Category ID is field in above table strCategory is Long ( this gets passed...