Search results

I have a log form that I'm trying to develop a query for that will only show entries from the last 12 hours (or one shift). Got the 12 hour one sorted no problem, but the better case would be if I could grab all entries including ones with certain input into the subject field of the form. Let...

I have 2 unrelated tables in a database, tblPM and tblETR. tblETR is the main table that prints out a daily shift log of work done, this is not a problem and working fine. Problem is that the tblPM has no related fields to tblETR BUT, needs to have every entry or change to this table recorded...

I'm having problems coming to terms with this and need some help. I have 2 main tables as follows: tblLog Log_Subject Log_DateOpen Log_TimeOpen Log_initials Log_Manhours Log_TaskCode Lof_Problem Entry - would like to use this for both ETR and Log entries as is a memo field...

I have a main form with one subform in it. The problem I'm having is that when closing the main form (as in an update) all records on main form save to table. The subform is a record that is in another table and I cannot get it to update to it's table. I understand that when you close a form...

I have been tasked with converting an old Electronic Trouble report (ETR) flatfile database to access 97. The old flatfile had 2 basic tables in it, ETR and LOG. The ETR table consists of the following fields: ETR - Text Equip - Text Station - Text SSCODE - text Date_Open - Date/Time...