Recent content by cheshire_smile

http://www.access-programmers.co.uk/forums/showthread.php?t=212296

When you generate the query set the critera as: Close Date > Start of FY Open Date < End of FY

The Form or Report identifier is optional when referring to control properties. It is necessary, however, when referring to subform or subreport properties. To refer to a control on a subform, use the following syntax: Forms![main form name]![subform control name].Form![control name] To refer...

TRY: Forms!MAINFORM!sfMarkSold.Form!RecordSource = SQL

I have a table with a stataus of a terminal collected every minute (time collection can be changed to other time spans). I need a VBA script that will collect the time stamp stamps based on their status or change in status. Sample Table: Terminal_ID--Time_Stamp-------Status 2-------6/19/2011...

If it helps, this is what I came up with. but this is too combersome, because it runs each record times each record. So if i'm running it on 100K records, then it's processing it a billion times. I've tried indexing all the fields, I've also split the Terminal_Name from the table and given it a...

The sample I provided is for only one terminal_ID, and is from 00:01 to 00:14 on the 19th for Jun. (There will be other terminals as well). Notice that the records are ordered by time_stamp AT 00:04 the up and dn went from 1 on the previous record to 0 AT 00:06 the up and dn went from 0 on...

Because there is no stop time, or no value where up AND dn <> 0 after wards. It's Up AND Dn <> 0. I only used 1s in the example, but the values can be more than 1.

Have you tried changing the record source of the report and adding the condition "where ID <>" CheckboxName??? Not sure if this applies here. you did'nt post much info to work with. you may want to compress and post a copy of your file.

I need help with developing a query, or a VBA script to get start and stop times where a condition is met. I have a table called Temp_Table. Sample data: ID-Terminal_ID-Time_Stamp--Dn---Up 1----2----6/19/2011-00:01---1----1 2----2----6/19/2011-00:02---1----1 3----2----6/19/2011-00:03---1----1...

Thank you both for you input. The data is not stored which is why it's in a Temp table. I am using access as a report generation tool. I import the data from a DB (which I only have front end access to) then run the query to generate a usage report along with outage stats. I know the naming...

I'm having tryouble running a query on a single table with 100,000 records. It was taking over an hour to run the query, so I tried indexing all the fields. This droped it down to about half an hour. I need it to run faster. Here is the query: SELECT UpDn_Analysis.Terminal_Name...