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

Rabu, 04 November 2015

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

I did somthing like this myself. But nothing happend after running. And I checked the debug.print strSQL, there's no error notes either.

Dim strSQL As String
        strSQL = "UPDATE tblPartItineraryCityTour" & _
        "SET [HotelDistanceToCityCenter] = " & Me.Parent.HotelDistanceToCityCenter & "," & _
        "[HotelCategoryID] = " & Me.Parent.HotelCategoryID & _
        "WHERE PartItineraryCityTourID = " & Me.Parent.PartItineraryCityTourID

        CurrentDb.Execute strSQLOne, dbFailOnError

zhaoliqingoffice@163.com

From: Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]
Date: 2015-11-05 08:21
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Fill up something instead of add new record

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