Search results

I think that's what I was looking for.....thanks! Jim

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...

No on has any ideas? Really need some guidance on this one. Jim

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...

Thanks Pat that sounds like it wa smy problem. had some default values in their and removed them and its working fine now. Thanks for all the ideas. Jim

Text boxes in subform are bound fields. Jim

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...

OK, I don't have a problem with most of that. I'm still at odds what to do with the action field in ETR table and the entry field in the LOG table, these two fields are esentially the same, ie. the when making an ETR entry this action field will be the same info that goes into the entry field in...

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...