Recent content by patrickglass

Hello, thanks for the quick reply. i seem to not be thinking today as i cannot seem to wrap my head around this. heres is the code i am running. i dont know what is the problem with is. i am suspect of the 3rd argument in the function and how they were all referenced. if someone could help i...

Ok well i attempted it and was unable to get it to work. i still do not know how to get a value when there is going to be no "Where" clause Private Sub Form_Current() On Error Resume Next Me.txtHours = DLast("[HourReading]", EquipmentHours) 'not working - error Me.txtDateHours = "i dont...

Hello, i have an equipment table and an equipmentHours table. linked by an id on the two. basically i have an hour reading on the machines that gets entered every once and a while. no set times or dates. i have an equipment for where you can view the current equipment data. i was now would...

Thanks a lot for the reply it works great. bye for now. Patrick Glass

yes it will always be the previous record. i DO NOT want the newest date record. this is because we do not input in a logical method as we get the data day by day but not of consecutve days. Patrick

Hello, i have been having some problems with my database app. i have a form where the user enters in data name and shift. for multiple records in a row the date and shift would be the same. what i plan to do is have a on update event of the name control that would fill in the other two fields...

well sorry i wasn't asking a question really. i have however found a rough solution that may work for you Private Sub cboMakeList_AfterUpdate() Me.cboModelID.RowSource = "SELECT tblModels.ModelID, tblModels.Model FROM tblModels WHERE (((tblModels.MakeID)=...

i hate to take over this thread but i am looking for the exact same solution. Currently i am using Me.cboAssemblies.Requery on the onUpdate from cboEquipment the linking works fine but as soon as i change one of the equipment combo boxes all the other cboAssemblies go blank I was just...

I have attached the file i am working with

Hello im new to this forum and I just recently became involved with access so please bear with me and my many questions. I work for a mining company in Canada and we have training events. These records must be kept showing who attended and what was covered. I have used the event template and...