VB Forum / Database Access / August 2004

when I am trying to open a word document in vb,tables and footnotes
were shown chaotically!!
what should I do to solve this problem
thanks for any help

Dear Sir,
When I Open Catalog in ADOX & try to retrieve the Columns from Columns
Collection it returns fields with Alphabetical Order of Field Name. How to
Get Field in Original Order.

I want to import a textfile into a access datadase, i'm using following
code:
I always get error 3109
Can someone help me please?

To my understading Date datatype in VisualBasic stores both date and
time. But how can I assign both. I have two dtpicker controls on my
form
   Dim dtmCurrent As Date

I have been developing a database update procedure, and the first table I worked with was named BCRDates; the linked table (to BCRDates in the source database) was named BCRDateslnk.
The links are created as temporary QueryDefs and deleted as execution progresses through an array ...

i have a problem with sending data from one database field (dataflex) to
another (fox pro) in VB.net.
simply, i use a datareader to read one row from the dataflex database and
want to copy some of that info into the other fox pro database.

I'm using data shaping to dynamically display survey questions on a
page which are made up from information held in several tables.
The structure of my database is as follows
tblSection

I return a recordset from Microsoft SQL Server 2000 containing, amonst
others, a SmallDateTime field (Allows NULL).
I then step through all the Fields in the Recordset.Fields collection
to return each value. The values can be "Read" fine until I come to

I need to retrieve (and load) pictures (jpgs) to a sql server database.
I have a field with the image type created on a table. I saw (here of
course) some code that load the picture to a field in the database using
an adodb.stream object, but I need to retrieve it too....

I'm trying to solve a database execution time puzzle. Here are the
facts:
1) The application is an asp web site.
2) The asp pages use a VB6 dll for data access.

a user can perform a database action in my app.
To give him a clue what happens, i want to show him the records that
will be modified, in a separate form .....
so.............

I'd like to validate user's name and  password against domain information.
How can I do that?

I have an access application
code and data in the same file.
It runs on a single computer
with a single user

Hi *.*
It seems that all of people in this newsgroup create dynamic connection,
command, recordset and so on! So this is my question: Is there anything
wrong with using Vb6 Data Environment or not? Which one is better? Using DE

If I create a linked table (VB6, DAO, Access97) using literal values, the code executes flawlessly; if I use variables in place of the literals I receive an error. (Line flagged with ">>>"). Does anyone have any suggestions; I've probably looked at this so much I"m not seeing the ...