Search results

Thanks guys

Hi all, My data base consists of two tables linked on an ID field. The form is a split form with the datasheet at the bottom for the parent table. The child table is displayed on a subform of the main form. I have a calculated field in the subform footer that adds hours worked on a project...

Solved see below Private Sub AddNewSubRecord_Click() DoCmd.GoToRecord , , acNewRec Me!CheckDate.Value = Date RunCommand acCmdSaveRecord Dim db As Database Dim rec As Recordset Set db = CurrentDb Set rec = db.OpenRecordset("Select * from CheckItemDetails")...

Just tried the append query that was suggested. Get key violation error. Checked indexes and field type and can't seem to find anything wrong. Like the idea though.

Here is the query SELECT CheckItemDetails.CheckID, CheckItemDetails.ItemID, CheckItems.ItemName, CheckItems.ItemDescription, CheckItemDetails.Check FROM CheckItems INNER JOIN ([Check] INNER JOIN CheckItemDetails ON Check.CheckID = CheckItemDetails.CheckID) ON CheckItems.ItemID =...

Kind of new at this game. I'm working on a form that lists pieces of equipment. That is the main form. The sub form has the daily inspection information and an add new record button on it. The sub sub form has the inspection items in a data sheet, 14 to be exact. What I would like to do is...

I've been programming for years using dBase. For the most part I have been self taught. A situation at work came up and I started to work with Access so I'm real new to this programming environment. I enjoy building apps but sometimes a guy just needs a bit of help. Again greetings from...