Re: Previous record

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

See:
Referring to a Field in the Previous Record or Next Record
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;210504

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dan Johnson" <dan_johnson@xxxxxxxxxxx> wrote in message
news:O1fnxphXFHA.612@xxxxxxxxxxxxxxxxxxxxxxx
Hello,

I have a rather lengthy question in regard to updating a field based on the
Previous record's input. We have electric vehicles that utilize batteries
for their operation. There are 13 vehicles with approximately 2 battery
changes per day in a group of 28 batteries. As an operator changes the
battery in the vehicle, I would like to automatically input that current
battery into the now Last battery field within a form for the data entry.

I have been able to get two queries written to isolate down to the current
record. Based on the form's current record, the first query filters to ALL
of that specific vehicle's records. The second query isolates down to the ID
(AutoNumber) of the current vehicle. This is the point at which I am stumped

I haven't been able to figure out how to go to the Previous Battery for that
record (vehicle battery change) in an effort to do a later copy via macro.

I currently have the form updating with the Last Battery but that doesn't
work because the Form needs to have the ability to make corrections on older
records. Since one of the older records happened, in some cases, a month
before the Last Battery was installed, it actually needs to be that record's
Previous record.

Unfortunately, I am not proficient in VB and am limited to the wizards for
queries.

I apologize for this lengthy request. Thanks, in advance for any suggestions
for this problem.

--
Dan Johnson



.

Relevant Pages

  • Re: Enhanced mobility for infantry
    ... the enemy as to the actual battery position, but the Germans are Germans, ... FOOs move in vehicles of the same type as the force they are ... the same vehicle they could communicate - which is actually horsecrap, ...
    (sci.military.naval)
  • Re: Previous record
    ... I already have another query that orders the list of vehicles down to the ... I need the Last Battery field populated with Battery 028 ... from the battery that should be in the vehicle currently. ... > stores the date and time of the battery change. ...
    (microsoft.public.access.queries)
  • Re: Oil hits $132/bbl
    ... and swappable battery packs will be way more economical than ICE ... Many areas already experience brownouts in the summer when electricity ... depending on the vehicle speed and the terrain encountered. ... you're not stuck looking for a swap station or waiting for the trickle ...
    (misc.transport.road)
  • Re: What happens when your scooter Breaksdowns / loses power outside ?
    ... >> You will damage the battery!! ... >> just google mobility scooter breakdown service ... So its essentially the same as AA or RAC for your car. ... or mechanical breakdown of your vehicle. ...
    (uk.people.disability)
  • Re: Grand Voyager Death Trap
    ... electrical problems because of the drain on the battery. ... Actually vehicles today do have a normal measurable constant drain on the battery when the vehicle is turned off - due to things like "keep alive" voltages for certain circuits like clocks or volatile memory - they even have an acronym for it - IOD. ...
    (rec.autos.makers.chrysler)