Sabtu, 03 Agustus 2013

[MS_AccessPros] Having more issues with queries

 

Besides the previous post, I am having issue with an insert query.

dbs.Execute "INSERT INTO tblPaymentSchedule " _
& "( lngTPTID ) VALUES " _
& "( '" & Me.Tbox_TPTID & "' );"

getting error message : object variable or with block variable not set

when query string is put in message box the following is displayed:

INSERT INTO tblPaymentSchedule ( lngTPTID ) VALUES ( '284' );

lngTPT is defined as a number (long int)

Just not seeing my issues tonight.
Rod

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar