VB Forum / Database Access / April 2004

Hi friends
I need routines to create an excel file with worksheets for each
customer and a text file as well for each customer, first worksheet
would be a "Summary Report", here is the code that would get the data

Hi I have a VB App that connects to a Jet DB. I have a recordset and I am
trying to return the number of records. The RecordCount property returns -1.
Am I doing something wrong:
       Set rsLoc = New ADODB.Recordset

I wonder if some one could help me with an invoicing program I am trying to
write for a client. I'm ok with basic databases but this is a little above
my head.
I have checked all the usual VB sites for a good example but most of them

I have to create a dts package to import a text file into a table of a db
The problem is that The SQLserver and the file don't stay on the same machine and so I can't do the import..
any idea
thanks!!

I have a vb6 app that i'm trying to connect to SQL SEVER to retrive a single column of data from a table and load into a recordset.  Then i plan on clicking a next button that will display the current record in a text box.  Having a few issuses, i believe i connect but having ...

I am using VB6, ADO and winxppro to connect to Oracle 8.1.5 over a
network.  Here is my code:
Set cn = New ADODB.Connection
cn.CursorLocation = adUseClient

I am using a form to update a database. One of the field is a yes/no type
field. I am displaying a datagrid where the Results of No are displayed. For
this i am usinga querry. The datagrid doesnt display the updated record. I
have used the requerry, refresh methods on the querry but ...

I've put together a small VB6/SP5 app that will loop with each loop opening a database, then a recordset, closing the recordset then the database and repeat.  I'll loop thru this a few hundred times watching the available physical memory drop with Windows Task Manager.  A large ...

I want to know How to import coma delimetered file into database
e.g
1, ABC, "Computer, Test", Dep, 85
2, AC, "Computer, Sold", r&D, 99

Can anyone spot a problem with this code?
It works fine untill I try to add value for date(lblDate2)
the variable is formatted as follows
lblDate2 = Format(Date, "Long Date")

I use VB6 + ADO
How do I add a column to an existing FULL table without causing harm to the
data (using vb code...)?
How do I check if the column exists before adding it ?

I have a DataReport bound to a DataEnvironment.  When I add a new record, click the update button,  and go to the DataReport, it does not appear but does appear when the user quits the program and restarts. How can I avoid this?  The user should not have to quit the program just ...

I just upgraded my VS6 with the new SP6; now, when I try to edit MSDE
sproc's, I get an error message "ADO error: could not find stored procedure
'dt_getproctdef'" (which I assume is an internal sproc in SQL server).
Can I do anything else than reinstall VS6/Access, or even worse, ...

I have difficult to find information from microsoft of retrival and deleting
primary key or indexes of an access database. The purpose of this is to
update the database which is built by customers.
Thanks,

Hi Y'All,
Having a really infuriating problem when trying to create an Access 2000
report which calls stored procedures on a SQL Server 2000 database. I'm
getting the error "Microsoft Access Can't Find The Object <proc name>"