VB Forum / VB Syntax / September 2003

I have a ADO DC connection with a database
and in the Form_Load i have the code :
Dim rs As Recordset
Set rs = Adodc1.Recordset

There is a statement that I haven't needed before, but now when I really
need it I can't find it in the VB help.  I have a long-running program that
needs to occasionally yield to the system so other windows activities can be
updated.  I can't recall what that statement is.  Any ...

I have make a ADO DC connection with a
database and at RecordSource i have write
a SQL clause that include the function StrReverse()
When i run the project i receive the error message:

I got this to work but I'm not sure if this is the correct
way to go about it. In the past with ado database activity
I use to use if eof, movelast, etc. Now with the SQL
statement that is no long valid. I did notice I could

I have make a ADO DC connection with a
database and at RecordSource i have write
a SQL clause that include the function StrReverse()
When i run the project i receive the error message:

Someone posted this over on the comp.lang.XXX groups... thought I repost it
here (on the off-chance it hasn't been sold yet)
Rick - MVP
For those who have been looking to purchase a

Dim sql As String
Dim a As String
Dim b As String
a = Val(PRICE_XOND.Text) * Val(YPOLOIPO.Text)

Does anyone know in VB script if there is a function for
PMT or anything close to it?
Thanks!

I am trying to load an picture at run time at every Form's
StatusBarPanelPicture property but it seems that it doesn't show up .
Any ideas?
Thanks Panayiotis.

I can believe how troublesome this is!
I need to rename a number of files in a directory. eg
file1.exz > file1.exe
file2.exz > file2exe

I currently have to work with a client on a VB5 application with some
code that was ported over from VB6. Many of the functions in the ported
code make use of the Split() function, which as you know did not exist
in VB5.

As my project grows, I'm adding forms and modules which sometimes have
duplicate API declares.
Should I:
a) Place the Declares and UDT's in a global module for every form/module

I would like to know if is a beter way to get
exact week number bounded to particular date .
The user should write a date in TextBox ctl, so  another textbox should
recive a week number.

No not a spam!
I've come across someone elses code which uses the following line...
.
.

I'm trying to Update a current record. I've managed to
have in put in the actual text with the first Set RsQD,
and it works. With the 2nd Set RsQD, I'm trying to send it
the text contents of a text box. I've tried the method