VB Forum / Database Access / December 2006

I want to create a standalone application and want to connect it to the
database of www.ncbi site
ncbi site is having their public database ..
so i am trying to create a vb application and connect it to that

I have a data combo box populated with database values
Now my problem is i get the values from database perfectly but when i run
the form i see the combo box empty before clicking it but when i click it ,
i see database value, then why its showing me blank combo before click, i

I am using VB6 and true dbgrid 7. I am using the sstabs and SQL ADODC
It kind of works, I can edit existing data all day.
I can insert new rows all day, so long as after I insert a new row I
click somewhere in the grid or insert.

I am relatively new to ADO, but up to now I got things working the way
I wanted. But now I've run into somethng really annoying.
I am working in MS Access. I am using an Access frontend separately
from a backend. The tables from the backend database are linked in the

I am trying to insert values into MS Access. It is giving me this
error.
Syntax error in INSERT INTO statement.
I am unable to solve it. Please help.

I am using VB6 + Access2003 Program.
I installed the program on Windows ME while the database is
in another computer (with shared folder) that I reach through network drive mapping in the Win ME computer
(i.e.: "G:\db.mdb").

Hi, I want to learn Visual Basic, but I don't know where to find a good book
to teach me everything I need to know about it.  Can you help me with that?  
Thank you,
Adrian Mowrey!

I'm new at ADO and really wanting some sample code of how to use it to open
a known xls, and get the list of worksheet names. Then once a worksheet name
is known, how to get the info from it. Also, can I get the cell formatting
info as well? or just the contents?

I need to have a server side cursor for my connection but I need to be able
to move back a record. I tried using the cursor type as dynamic when I open
the recordset but I keep getting errors. Any help would be appreciated.
Ellie

I created script file in SQL Server 2000 Enterprise Manger. The name 1.sql.
Its contents:
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[_ATest]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

How do I show the same windows dialog for selecting a DSN as does windows in
ODBC Sources?
That would be the window titled
"ODBC Data sources administrator"

I've been struggling with a query for a couple of days, and I can't
seem to find a solution... so I thought I'd see if any of you have an
answer.
I am trying to write a search to pull information from a couple

   If someone could help me with this it would be greatly appreciated.
I have the following code, part of a function (irrevlant and parameter
declaration has been removed). Suffised to say the function works most
of the time and a recordset is usually returned. However sometimes, ...

Can I access an Oricle database with VB6?  If so, how?

OK, I'm confused. The below code works fine until I select a
supplierperson that returns a large number of rows.  Why does the
MsgBox("HERE") display when in fact the sqlDataAdapter has not
returned the data? I can see a horizontal scroll bar on the