I am doing a scatter plot and it needs to scale based on the time value so I can't use the sequence number.
After some doing I was able to contact the software writer and have them alter the log time to run continuous and not reset to 0 at 24 hours.
After I had the time consistant I was able to do my scatter plots.
Thanks for the help, Arne
arnegrant
Last Activity: Feb 5 '10, 08:23 PM
Joined: Jan 21 '10
Location:
-
Fast running sum or a way to index times.
I have a table with the following
Autonumber Time Temp
1 01:00:10 500
2 02:01:10 600
3 02:00:15 650
.
.
.
.
11,759 23:59:00 700
11,760 23:59:10 600
11,761 23:59:50 ... -
arnegrant replied to Get most recent file in a folder and then import it with transfertext into a table.in AccessThank you, the Reference and the code were both very helpful.Leave a comment:
-
arnegrant started a topic Get most recent file in a folder and then import it with transfertext into a table.in AccessGet most recent file in a folder and then import it with transfertext into a table.
I have the transfer text portion working fine, and I can select the most recent file in excel vba, but I can't get the most recent file portion of the code to work in access vba.
It ends with error "compile error variable not defined"
I'm a bit new at vba, could anyone help?
Private Sub Command6_Click( )
On Error GoTo Err_Command6_Cl ick
Set objFSO = CreateObject("S cripting.FileSy stemObject")...
No activity results to display
Leave a comment: