Search results

Whenever the time reads 12:00 am I am still not getting the time with the date just the date is showing up but I'm not too concerned with that now I am going to create another column just for the date so don't worry about the time issue I think I can figure it out. I'm working on downloading...

Is there an easy way to modify the code to include only the segments that start with 1 or I am just thinking that it is easy? Because I am not to good with the code if you haven't already noticed

I want to thank you again for everything but I have just one more question to go with the one above. Earlier I mentioned I needed all combinations of all segments but now it looks like I will only use segments that start with 1 (e.g. 1-2, 1-3,1-4,...1-15) not all the other combinations. So is...

Yea that does work but just one problem if the timestamp is 12:00 AM then only the date shows up wtihout the timestamp. You mentioned omitted seconds above but I need the seconds because in my original data I use the seconds. I tired to just add the :ss part to hh:mm but that didn't seem to...

Someone suggested that I need to provide the date as a parameter to a function which creates a date datatype from a string parameter. Probably something like date('20/11/08')

Well not long before I ran into my first problem. I just noticed that in my original raw data for the timestamp, the date is never included. Each day's data is stored by the day. I've tried the update query you mentioned earlier but that gives the data as 12/31/1899 or dates from the 1900's...

ok well now I am going to trying loading all the data for all my days included in my study. I will let you know the results and any possible problems I may incur. Thanks for the help and wish me luck

Point taken..thanks

jal With that little correction from MSAccessRookie, I got the update query to update the TravelSegmentsCopy table as each SegTimeStamp column either reads 1/29/1900 3:20:00 pm or 1/29/1900 3:25:00 PM. Then I do the append query to insert the data into the TravelSegments table and then run...

Thanks MSAccessRookie, that sure was a stupid mistake by me

I'll ask this question also: Should I load all my data into the DB first e.g. all my days data vs. the one day that is present in the DB we have been working with or is that irrelevant right now?

I pasted the code exactly as you have it here and I got the same message about "updating 30 rows" "Proceed?" Then got the error "MS Access can't update all the records in the update query. MS Office Access didn't update 30 fields due to a type conversion failure, 0 records due to key...

Ok so I copied the data and made the table TravelSegmentsCopy and transferred that to a query so I could insert the line in SQL view you mentioned above. I'll explain what I did: I put the TravelSegmentsCopy in the query, selected SegTimeStamp to update, then tried to input your UPDATE line...

Alright well I will try small scale test, first, the way you explained before with just a few timestamps and then get back to you and let you know the results

ok so once I load all the 3 months data into my DB, then try your method and then run the code, then it should work?

Sorry it took so long to reply...I haven't tried this yet cuz I can only open your file as a read-only file but when I get to the last stages of this project I will be adding more travel time data from different days, probably about 3 months worth, and will have the run the code for that many...

Ok wow man that seems to work just great thanks you so much...you also mentioned if I wanted to add multiple days of data just add the date with the timestamp and the code should remain unaffected?? Again unbelieveable thanks

Just a couple instances I noticed, for example at 3:20 pm a few of the segments starting with 8-15. 9-15, 10-15, 11-15 to 14-15 all display the same TTT. I can attach the DB I ran and you can see tomorrow and show you the examples if you are willing to help with that. It's really weird...

The two forms look identical so i don't see the relevance. Maybe there's some differenence in the coding (which I am not eager to study at this moment). the only difference is I deleted the line: miscRS.Filter = "segTimeStamp = #" & currTime & "# AND segment >" & currSegment

I was asking because I may need to add more days data and if I were to do that then maybe I would have to add a date column to distinguish the timestamps