how to handle meter readings
in [Tables]
|
Prev: shipping database
Next: Help with pivot table
From: deb on 17 Nov 2009 01:02 I've used an unbound combo box and it works but the meter number i select is not being pulled into the meter reading table - ive got no other fields in the main form, could that be the problem, should i have the meterID in there somewhere (that doesnt make sense though) this is the row source SELECT [ElectricityMeter].[ElectricityMeterID], [ElectricityMeter].[MeterNumber] FROM ElectricityMeter ORDER BY [MeterNumber]; nothing else is set, no events etc the subform is set up correctly - i checked, child and master are set to ElectricityMeterID and thats the link field and it drops the readings into the table nicely so it must be set up correctly - its just the meter number from the main form thats not working i've stumbled my way through waaaaay more complicated forms than this - aaaarrrrggg! -- deb "BruceM via AccessMonster.com" wrote: > You would generally use an unbound combo box for searching. I can't tell if > you have done that, so I'm mentioning it. You say that part is working OK, > so I assume you have this set up correctly. > > The subform is in a "box" on the main form. The box is the subform control. > Be sure its Link Child and Link Master properties are set to the linking > fields. To view the subform control property sheet, click the subform to > select it, then click View >> Properties. Be sure you are looking at the > control properties, which will be labeled something like Subform/Subreport: > ControlName. Click the three dots next to Link Child or Link Master. Access > will probably select the correct fields if the tables are properly related. > > deb wrote: > >i did that, on the combo box on the main form the row source is > > > >SELECT [ElectricityMeter].[ElectricityMeterID], > >[ElectricityMeter].[MeterNumber] FROM ElectricityMeter ORDER BY > >[MeterNumber]; > > > >the record source for the main form is ElectricityMeter > > > >on the sub form the source object is MeterReading > >link child and master are ElectricityMeterID > > > >the ElectricityMeter table has > >ElectricityMeterID (link field) > >MeterNumber > >BuildingID > >LocationID > > > >the MeterReading table has > >MeterReadingID > >ElectricityMeterID (link field) > >ReadingDate > >PeakReading > >OffPeakReading > > > >linked with enforced referential integrity > > > >so you select the meter number from the combo box, fill in the date and > >readings - all good except its not picking up the ElectricityMeterID in the > >MeterReading table > > > >what am i missing? > > > >> If you have a meter table and a related readings table, with a form and > >> subform for data entry, you can use an unbound combo box on the main form to > >[quoted text clipped - 22 lines] > >> >> > >> >> Just so it's billable hours... > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200911/1 > > . >
From: deb on 17 Nov 2009 01:27 my combo box works and the subtable works - checked all the things you mentioned and everything is in the right spot, its just not picking up the meter number in the meter reading table when you input a new reading, the date shows, the readings show but the meter number spot is blank -- deb "BruceM via AccessMonster.com" wrote: > You would generally use an unbound combo box for searching. I can't tell if > you have done that, so I'm mentioning it. You say that part is working OK, > so I assume you have this set up correctly. > > The subform is in a "box" on the main form. The box is the subform control. > Be sure its Link Child and Link Master properties are set to the linking > fields. To view the subform control property sheet, click the subform to > select it, then click View >> Properties. Be sure you are looking at the > control properties, which will be labeled something like Subform/Subreport: > ControlName. Click the three dots next to Link Child or Link Master. Access > will probably select the correct fields if the tables are properly related. > > deb wrote: > >i did that, on the combo box on the main form the row source is > > > >SELECT [ElectricityMeter].[ElectricityMeterID], > >[ElectricityMeter].[MeterNumber] FROM ElectricityMeter ORDER BY > >[MeterNumber]; > > > >the record source for the main form is ElectricityMeter > > > >on the sub form the source object is MeterReading > >link child and master are ElectricityMeterID > > > >the ElectricityMeter table has > >ElectricityMeterID (link field) > >MeterNumber > >BuildingID > >LocationID > > > >the MeterReading table has > >MeterReadingID > >ElectricityMeterID (link field) > >ReadingDate > >PeakReading > >OffPeakReading > > > >linked with enforced referential integrity > > > >so you select the meter number from the combo box, fill in the date and > >readings - all good except its not picking up the ElectricityMeterID in the > >MeterReading table > > > >what am i missing? > > > >> If you have a meter table and a related readings table, with a form and > >> subform for data entry, you can use an unbound combo box on the main form to > >[quoted text clipped - 22 lines] > >> >> > >> >> Just so it's billable hours... > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200911/1 > > . >
From: deb on 17 Nov 2009 02:00
by george i think i've got it!! i didnt have anything in the control source for the combo box yaaaayyyy! -- deb "deb" wrote: > my combo box works and the subtable works - checked all the things you > mentioned and everything is in the right spot, its just not picking up the > meter number in the meter reading table when you input a new reading, the > date shows, the readings show but the meter number spot is blank > > > -- > deb > > > "BruceM via AccessMonster.com" wrote: > > > You would generally use an unbound combo box for searching. I can't tell if > > you have done that, so I'm mentioning it. You say that part is working OK, > > so I assume you have this set up correctly. > > > > The subform is in a "box" on the main form. The box is the subform control. > > Be sure its Link Child and Link Master properties are set to the linking > > fields. To view the subform control property sheet, click the subform to > > select it, then click View >> Properties. Be sure you are looking at the > > control properties, which will be labeled something like Subform/Subreport: > > ControlName. Click the three dots next to Link Child or Link Master. Access > > will probably select the correct fields if the tables are properly related. > > > > deb wrote: > > >i did that, on the combo box on the main form the row source is > > > > > >SELECT [ElectricityMeter].[ElectricityMeterID], > > >[ElectricityMeter].[MeterNumber] FROM ElectricityMeter ORDER BY > > >[MeterNumber]; > > > > > >the record source for the main form is ElectricityMeter > > > > > >on the sub form the source object is MeterReading > > >link child and master are ElectricityMeterID > > > > > >the ElectricityMeter table has > > >ElectricityMeterID (link field) > > >MeterNumber > > >BuildingID > > >LocationID > > > > > >the MeterReading table has > > >MeterReadingID > > >ElectricityMeterID (link field) > > >ReadingDate > > >PeakReading > > >OffPeakReading > > > > > >linked with enforced referential integrity > > > > > >so you select the meter number from the combo box, fill in the date and > > >readings - all good except its not picking up the ElectricityMeterID in the > > >MeterReading table > > > > > >what am i missing? > > > > > >> If you have a meter table and a related readings table, with a form and > > >> subform for data entry, you can use an unbound combo box on the main form to > > >[quoted text clipped - 22 lines] > > >> >> > > >> >> Just so it's billable hours... > > > > -- > > Message posted via AccessMonster.com > > http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200911/1 > > > > . > > |