ACCESS FEED: RE: [MS_AccessPros] Having more issues with queries

Sabtu, 03 Agustus 2013

RE: [MS_AccessPros] Having more issues with queries

I think your previous issue was caused by a lack of delimiters and this was was too many delimiters. Strings and dates require delimiters and numbers don't.

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

----------------------------------------
> To: MS_Access_Professionals@yahoogroups.com
> From: desertscroller@cox.net
> Date: Sun, 4 Aug 2013 05:09:43 +0000
> Subject: [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
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>