OK, we admit it: we didn’t exactly knock ourselves out trying to come up with a brand-new topic for this week’s column.
So what does that have to do with this week’s column? Since you mentioned it, though, this week we’ve decided to expand upon a previous column, one in which we showed you how to connect to and read from a Microsoft Access database.And if you have particular questions about Microsoft Office scripting, feel free to send them to [email protected](in English, if possible).We can’t promise to answer all the questions we receive, but we’ll do our best.Welcome to Office Space, the column that offers tips and tricks for scripting Microsoft® Office applications.To see an archive of previous tips, visit the Office Space Archive.Is it possible to add a record in one table and have Access automatically add date from one of the fields into another table??In more detail: Table1 has the following fields: Product_ID, Price, Weight etc...Today we’re going to take the next logical step and show you how you can add records to an Access database.And then, just for the heck of it, we’ll take step and show you how to modify existing records as well.If products are always entered into a form, you can use the After Insert event of the form to Execute an Append query statement to insert a record into Table2. "Support" wrote in message news:40***********************@mercury.... Is it possible to add a record in one table and have Access automatically add date from one of the fields into another table??Anyone care to enlighten me - or point me in the direction of a tutorial??