Search results

hi, I said beam to keep it simple, its actually an array of beams 30cm high covering entire roost entrance -with only 1cm vertical seperation between beams! noise will be from birds (can eliminate since daytime only) and at 1cm apart there is no chance of anything relevant missing a beam. noise...

hi, it is an event logger; i.e. it logs a bat transit every time it goes in or out and then rests until the next event BUT... we have to use two horizontally parallel beams in order to determine direction, so for each transit, a bat will break one and then the other beam. To complicate things...

Hi, heres your code (slightly changed -it didnt like DISTINCT etc.) one problem is I havent worked with access in a few years and im very rusty -and I dont really understand how to work with recordsets anyway -I know sad. so yes, the example is too complex although Im trying to muddle through...

yes...;) :eek: could you give me a clue as to how it should be done? p.s. and thanks for all the help so far.

Hi Gemma, the database I inherited works as far as collecting raw data -it is generic for hardware:http://www.ipcas.com/products/serial-ethernet.html the problem I have is converting the data which is collected into something that is useful. Thenet2 understands the issue and I am trying to...

Hi I had problems with your code -couldnt get it to work. But given what you said about the date limitations perhaps using date at this stage is not the best way to approach the problem -especially since there will be more than 30 dates. I was thinking that using EventTicks might be better...

"Are you talking about assigning those integers to each record based on the four-digit pattern that is recognized after 4 records are looped?" YES! How would I get the results into a table rather than a mgsbox? many thanks

cheers the_net_2.0,:D using your code below(only modified field names) I was able to produce a msg box with number of bats and insects. This is real progress, now I need to determine direction and store the answer as a file or a table for each day (or somehow or other determine between days...

0,0 means no signal: there is no bat in the beams (the occurance of 2 bats in the beams is so rare it can be ignored) example bat just flies out: noting in beams: both pins = 0 bat breaks 1st beam: pin 1 goes high (1) bat breaks 2nd beam: pin 2 goes high (1) bat leaves 1st beam: pin 1 goes...

sorry about this: "so what happened here? looks like a bat came through, because beam 0 was triggered while beam 1 was still triggered, right? but look at the 3rd record. the second beam I put my arm through the beams and pulled it back out thus the strange pattern -normally I toss a paper...

hi, its not speed that causes both beams to trigger -and crucially stay triggered for long enough-it is the size of the animal. A bat is big enough to trigger both beams wheras an insect will only trigger one at a time as it transits. Thus a bat produces the pattern: pin1=1, a few ms later pin...

its to monitor rare roost populations. A zero means the absence of a bat breaking the beam, a one means the beam is broken. Thus each of the beams will be at one if there are no bats crossing. If a bat crosses the 1st beam will change from zero to one and then back to zero after the bat leaves...

hi, this is logging continuously and will soon exceed the number of rows in excel I am trying to log the date/time of transit and the direction -speed would be nice. VBA would be great but how? there are two inputs: pin 1 and 2 -it doesnt matter which is whic,h since "out" or "in" can be...

Hi, I really dont know where to begin here::( I inherited an Access database (attached) which is permanently connected to a data source (wo electonic triggers from pair of Infrared beams). These are used to count bats entering and leaving a roost. There are 2 sequential beams so hopefullly...