I have a table that stores date/value pairs. The dates are successive end-of-month values.
For each month, I need to know if
(1) a value is not present, but was in the previous month (e.g. a "sell")
(2) a value is present, but was not in the previous month (e.g. a "buy")
(3) a value was present for both months (e.g. a "keep" of that value)
e.g.
12/31/2014 A...
billelev
Last Activity: Dec 18 '19, 09:11 PM
Joined: Nov 30 '06
Location:
-
How to detect differencess/similarities between Rows in Tables
-
Awesome...Thank s for your help! -
I have...But only in passing. I'm playing around with the Shell method and then might resort to application automation at a later point. I'm trying to come up with a framework that will work with multiple applications, not just Access, and so Shell might be better in that instance.
In any case, thank you everyone for your help with my automation questions.Leave a comment:
-
ADezii, I have tried your code and it works really well. Many thanks for your input.
I have one other issue, *** Edit *** which can now be found in a new thread.Leave a comment:
-
Access Command Line Arguments
Is it possible to start an Access database, using the above code (*** Edit Shell() ***), but also by passing in arguments? I'm pretty sure I've done this before using the Shell command, and given the routine RunUntilFinishe d uses Shell I think I should be able to. I'm not sure what I have to do on the Access side to accept the arguments, however.
Any thoughts? -
Awesome...This looks fantastic. I'll give it a try on Monday and let you know how it goes.
Thanks for such a quick response.Leave a comment:
-
How to Automate the Running of Multiple Applications
I have a number of models that I need to run at regular times each week. The models may be based in Access, Excel or a math based statistics package called R. The models may also be a combination of all three. For example, Access may pull in historical pricing information, this is processed by R, and the results are displayed in Excel.
I can obviously use the Windows "Scheduled Tasks" application to kick the process off... -
This would be the resulting relationship layout......Leave a comment:
-
I could do that, but I presented simplified Location tables - there are more fields than the few I mentioned, and hence more nulls.
I guess I could just have a linking table between Series and the Locations that contained each of the unique Location IDs (rather than the query)?Leave a comment:
-
I've realized a problem with the proposed solution. I should have mentioned that the WebLocations and DatabaseLocatio ns should be unique and therefore not repeated. Multiple Series can have the same DatabaseLocatio n or WebLocation. In this case, the only way the above solution would work would be to repeat the definition for the locations.
Maybe the way to explain this is to say there are well defined and unique web and database...Leave a comment:
-
Yep, ChipR, that does make sense. I'll try implementing that and see how it goes. Thanks.Leave a comment:
-
Help with Access Database Table Structure
I'm building a database and am a bit stumped about how to construct/link tables. I will describe the current configuration, then present the problem I am trying to solve.
Currently:
I currently have a table called tblSeries. This table holds information about a time series of data, and how that data should be displayed. It has a SeriesDataID field that will link to another table (tblSeriesData) that contains information... -
Thanks - that's a great solution. I guess I would have to write a custom function if it generated values other than -1 and 1, though.Leave a comment:
-
Using Count within a Cross Tab Query
I have a cross tab query with Date as a row heading and a series of Names as column headings. The Value for each Date/Name intersection can either be -1, 0 or 1.
For example:
I would like to have a column ("Members") that counts the non-zero values for each row. This would give something like the following:Code:Date, Name1, Name2, Name3, Name4 1/1/2000, -1, -1, 0, 1 1/2/2000, 1, 1, 0, 0
...Code:Date,
-
The data arrives in an array. Thanks for all your input.Leave a comment:
-
That seems to have helped a lot - thanks.
As an aside - is looping through the array the only/best way of inserting data into a table?Leave a comment:
-
Inserting an Array of Data into an Access Table
I have a large array of data (1000 x 40 x 3) that I am inserting into a database table. It is incredibly slow, and so I was wondering if there is a quicker way of inserting array data into a table.
Here is the code I am currently using:
...Code:' [Date],[Security],[Field] With rs For nSec = 0 To UBound(vtData, 2) For ndate = 0 To UBound(vtData, 1) For nfield -
.End(xlUp) not working for some cases in Excel/VBA
I am using the following code to find the last row that contains data, within a particular column on a spreadsheet.
It works for columns that contain only numbers. However, for cells that contain formulas, I get the following message:Code:Dim ws As Worksheet Set ws = Worksheets(Me.ChartDataSheetName) GetLastRowWithData = ws.Cells(ws.Rows.Count, dataCol).End(xlUp).row
...Code:Run Time Error 13
-
You are correct in that the sub-forms are always present when the MainForm is loaded, with one key exception...Whe n MainForm is originally loading. This is causing the problem. That's why I wanted the code in SubForm1 to check to see if SubForm2 had loaded.
Once MainForm is loaded (and therefore the sub-forms) I don't need any checks, i.e. I can simply use:
...Code:Private Sub Form_Current() Forms("frmChartSeries").frmSeries.Form.FilterLeave a comment:
-
Thanks for your help...In trying to implement a solution, I encountered a related problem, which will involve some more explanation...
MainForm has two sub-forms, SubForm1 and SubForm2.
When the record in SubForm1 changes, I want to display different records in SubForm2.
I can almost achieve this by using the following code in the Form_Current event of SubForm1
...Code:' === Code in SubForm1 ===
Leave a comment:
No activity results to display
Leave a comment: