VB Forum / Database Access / December 2003

I'm opening my record set like this;
Private rstTips As New ADODB.Recordset, varBmkTips As Variant
Private Sub Form_Load()
   'open the record set

I need to schedule a DTS package once everydnight. The
flatfile would be overwrited everynight before schedule
time. i need  my sqltable to overwrite too with the latest
data. (Not keepon adding data to the table). I did the

I'm in the process of writing a VB front-end application for administrating
a SQL Server database.  The back-end portiong of this application will
consist of a Scheduler Agent and a Job Agent.   The Scheduler Agent will
simply see what jobs have been scheduled to be executed and ...

I am new to vb6 programming and was programming a database application . I
want to retrieve last record only and then update it and save it to
database. I only want single data field to be displayed in textbox area.
So any help will be appreciated.

I have a SQL script containing definitions for a number
of stored procedures. I'd like to execute it from within
my VB6 app using an ADO command object.
I'm trying this;

Set mystream = New ADODB.Stream
mystream.Type = adTypeBinary
mystream.Open
mystream.LoadFromFile "c:\home.bmp"

I have an application that is multi-user.  In theory
(grin) the different users should never access the same
record within my MS Access table - because of the way I
wrote the application,  to my knowledge,  my program

I am shortly going to start a project that is essentially a VB program
storing data in a Microsoft Access database.  Can anyone tell me what I need
to watch out for in order to get this program to work on all versions of
Windows from 98 onwards?

need to highlight the first item within a ListView row programmically after
it is filled.  I have the FullRowSelect property set.
How do I go about doing this from within my code?

I have a problem using DTPicker connected to DB.
DTPicker is bound to DB (Date field), per Data Control in DAO project,
Checkbox Value=true
If I click during the runtime on the checkbox, then is the date value from

Thank you again in advance for any and all assistance.
Is there a simple way to make a program run for say 30 days and then give a
messagebox, "You Demo Time has expired, please contact..."?
I have a small program for Yahoo I built, but I want to give it as a demo, and

I have the following statement when trying to access Excel data in VB6:
Data1.RecordSource = "SELECT * FROM 'Sheet1'$"
Data1.Refresh
I can't seem to get the syntax right to stop the error:

I am new to VB and am trying to create a simple app using
VB 6 that will search by employee last name.  The way it
is setup is simple and works fine if you enter the exact
last name.  How can I change the code so that it will find

Thank you in advance for any and all assistance.
I have a VB 6 application and with a cmdCopy button, I would like to open a
file, C:\program files\program directory\program file.txt and copy to the end
of that text file information data on the clipboard.

I am getting an error telling me that I am not providing the parameter that
it is expecting.  The query runs fine when launched by hand from Access.
The error says that I am providing too few parameters.  It is expecting 1.
Below is the code that I am using.