ACCESS FEED: Re:RE: [MS_AccessPros] Fill up something instead of add new record

Jumat, 06 November 2015

Re:RE: [MS_AccessPros] Fill up something instead of add new record

Duane-

Can you please give an example for using sql update query, I mean in vba code? Thanks in advance.

Best Regards,

Kevin

发自我的小米手机

在 "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年11月5日上午8:21写道：

Kevin,

This is probably a simple update query. Can you provide some information about your primary keys? Is GroupBookingID a primary key in one of the tables?

Duane Hookom, MVP
MS Access

To: ms_access_professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 5 Nov 2015 07:41:55 +0800
Subject: [MS_AccessPros] Fill up something instead of add new record

Dear All-
Is that possible to fill up an existing record with some field from other table or form with strSQL, instead of insert a new record? For example:

An existing record from tblCityTour

tblCityTour
CityTourID: 11
GroupBookingID
CityTourDate: 11-Nov-2015
HotelStarID: (field I want to fill up)

The table from which I want to get HotelStartID.
tblGroupBooking
GroupBookingID: 2
ClientID: 5
HotelStarID: 3

Is that possible to fill up HotelStartID with the one from tblGroupBooking? Thanks in advance.

Best Regards,
Kevin

zhaoliqingoffice@163.com