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

Minggu, 04 Agustus 2013

Re: [MS_AccessPros] Having more issues with queries

Hi Rod,

If you type the following into the debug window you
you can see what a variable type is,

?TypeName("123")
String
?TypeName(123)
Integer
?TypeName('123')
... gives Compile Error

It's a useful technique and you can put any expression
between the brackets. Alternatively you can also use
the Vartype Function to return the TypeNumber.

Regards, Clive.

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> 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@...
> > 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
> >
> >
> >
>