Search results

thanks for that Chris, been caught out by this one before -now I remember...

Hi ChipperT, I just checked and found this: http://www.microsoft.com/sqlserver/2008/en/us/express.aspx Microsoft SQL Server 2008 R2 Express is a free edition of SQL Server that is ideal for learning, developing ..... Supports stored procedures, triggers, functions, and views

hi thenet2, I set the Events table input mask on Event Time to 00/00/0000 00:00:00 and repopulated the table but he query still does not work- does that mean your thinking is wrong on this? however, I did get it to work by using same mask but changing the field type to "text" and the module...

Hi thenet2, sorry if Im being "greedy" but I would like advice from both you and chippert if possible! Since you are approching the prob from 2 different aspects it may be that one approach is better than the other or perhaps a combination of both is most appropriate. I am at work but...

ok, thenet2 ( actually, I suspect I'm the one wasting your time, but seriously, many thanks for all the assistance. you're Ace.:cool:

I cannot for the life of me get this query to work even though that date/time exists in the events table. If I remove the date criteria it works. What am I missing? SELECT Events.State, Events.EventTime, Events.EventTicks FROM Events WHERE (((Events.EventTime)=#11/23/2010 16:11:34#)) ORDER BY...

Chipper T, can you tell me how you would do it using SQL server (express) with triggers and stored procedures? Presumably I could setup an ODBC link to the Access Events table? if you are interested, attached is jpg taken tonight of bats in the IR beams. (I have remote access to webcams in the...

hi thenet2, ok, I added new records in the table but udays() = rstemp.GetRows(rstemp.RecordCount) ... = 0 Is this a problem? and For i = 0 To UBound(udays, 2) 'loop a table for every unique date... here i = 150 I dont know why we need tha short date, can you explain that? thanks

Ok, reinstalled, help working ok now but still no data on hovering over some variables. UBound(udays, 2) is showing as = 0 so I suppose this is the problem I need to work out why. Is there any way of seeing what a dao.dataset conatins?

Hi thenet2, using access 2003 I can only see variable contents for some variables, not all; udays does not display its contents. Perhaps this is one difference between 2003 and 2007 -or perhaps my Access is broken and needs to be reinstalled (help is not working properly) I will try a reinstall...

ill have to get a copy of 2007 and try it, im on 2003 :(

hi thenet2 its the same database you supplied earlier, but with the change to short time format in the events table attached again with my changes now thanks for all your help on this, I suspect you are getting a bit tired of it..

sorry, it was the 2nd occurrence :o I am slightly familiar with debugging tools. i have changed the data/time to short date but it still crashes and the only variables showing anything on hover are the parrays values, temp=0, and i = 0)

Im on Access 2003 it fails on 1st part

tried that: still getting error 3021 no current record. fails at: rstemp.MoveLast

sorry, this is probably a really stupid question: how should I run the module? the run command is greyed out in the toolbar. I couldnt call it in a macro either or run it from a cmd button. Do I need to give any arguements? thanks, :confused:

thanks TheNet2, :D gonna have a go at your DB now :D

thanks ChipperT, yes it looks like that would work:) pints on me next time I'm in Dingle -or Doolin. I'm gonna have a look at theNet2's database now, cheers.

OK, I see what you are doing now, you have the basic concept correct but you miss the fact that there is only one pin and one state per record, not two: ID EventTicks EventTime IPAddress Pin State

Hi thenet2, DISTINCT may be needed but it is causing an error: run-time error 3093 order by clause ([EventTicks]) conflicts with DISTINCT i found this: http://msdn.microsoft.com/en-us/library/bb223434(v=office.12).aspx I modified your code to ... SELECT DISTINCT [EventTime], [EventTicks] " &...