Search results

This is test data a copy of the real data file. Actually, after I fille dout the form, the information didn't get added to the table unless I refreshed the table. Then after adding the DMax instruction to get the last meter reading (the End Meter Count from the previous record) to populate, we...

Forget MeterCounts2, the table, and MeterCounts, the form - I thought I deleted these. Table is MeterCounts and the form is Meter Counts. The Begin and End cycles are numbers used in the the math in the Excel version to determine the difference between the current and last meter reading = the...

Here is the database. The table Machines has the machine info, and the other table MeterCounts is the main table which is where the daily meter count information goes. There is only 1 form

This is the first time that I have worked with Microsoft Access, so please bear with me. This application was originally created years ago with Excel, and has been a real maintenance nightmare, so Access looks like a better tool to use. As I've worked with this, I catch myself trying to set it...

Thanks for responding jzwp22 - The main table, called MeterCounts, has id (autonumber generated by Acces), machine#, serial#, machine type, meterdate, meter count. We have 26 machines. The combobox runs off another table, called Machine, that contains the machine, Serial#, type. This is to...

Hi - I have a database of 26 machines. They are identified by a unique machine number (101-126). On a form, I select a machine number from a combo box, and enter the current meter reading for that machine. I am using DMax to get the previous meter reading for that particular machine to use to...

Hi - After filling out a form, this new data does not get entered into the table unless I go into the table and click refresh. Do I need to have a command setup to accomplish this? Thanks.

I think I need a walk thru on this. My form is set up to select a machine # (ex. 101) from a combo box. There is a Begin Cycle record and End Cycle record on the table. So, on the form, when the machine # is selected, I would like the Begin Cycle field on the form to be automatically filled...

Using DLOOKUP, if I understand correctly,the [ID] listed is the record ID, the first field in the record generated by Access. There are 10 machines are updated each time, and each has a unique machine # (101-110). Using [ID-1] goes back to the previous record in the table, but I have to get each...

Thanks SpikePl, that document will be very helpful. My reason to go back to a previous record is mainly to catch a data entry mistype. The math will show a negative result if a digit or 2 is left out when entering, or the resulting value will be too large, if an extra digit or 2 is entered. I...

Hi - I have a database that has data for 10 machines which is updated twice a day, at the end of each work shift. The record layout is mach#, serial #, date, shift and meter reading. A form is used to update the table. I need to be able to get the meter reading from the previous record for each...