VB Forum / Database Access / December 2003

Can anyone tell me how to set the dataformat of a textbox by VB coding?
Thanks...Douglas

i understand how to load a single image at run time but how would i load all
the images that are in a certain folder?

I would like to thank you all for your help in learning VB.  I just got
my grades back and recieved an A.   Your help is greatly appreciated.
Especially Randy Birch, who has always been helpful, but thanks to everyone
for the

I know I'm in the wrong NG..but I can't seem to find any for Mysql?
I have a few questions here.
How do I connect to multiple databases through MySQL?
I need to get connected to a minimum of 2 different databases per

Recordset has a property CursorLocation,
can any one explain what has cursor location has to do with server side and
client side?
According to me cursors are always on client side.

I wrote a VB6 program on NT4 for a friend who has XP.  He has used the preliminary (beta) version without problem.
Aware problems occur, I would like to give him the tools to recover from a db screw up IF possible.  Because his PC
savvy is minimal, I am attempting to include ...

Although i write programs in VB for a while now, i've allways used the
datacontrol and MS-Access DBs for data storage and never (and i mean never)
used SQL.
I lookt in many sample codes, red some books but i still can't connect to a

I am trying to set up a tree to sort my data.
what i mean is like in access when you insert a subdata sheet and you get
the plus sign and then you click on that
i am trying to organize pictures by year then month then date then all the

I need help with a select query for the following tables
TableName     Field                              Field
Contract         ContractCode                FK.Product.ProductCode
Product          ProductCode                  FK.Exchange.ExchangeCode

I'm doing some pretty familiar calls using a recordset, but I'm getting
bizarre results.
What's happening is that I'm calling one field from one record in a
database, but I'm actually getting back the contents of the field next to

it's me again with a next question:
I have a textbox and there I wanna put several numbers in. But I wanna check
if the user gives numbers in and not letters or a mix of letters and numbers
good          :   12345678901

I would like to guard against any possibility of a User
clicking the Save button twice and for that entry to be
INSERTed
twice. So first I have performed a SELECT on <TrailerNo>,

I have a website with a database. I am writing a program to be used on the
client, and I would like to access the database over the net. I do not have
access to the server, and I can't set up a DSN on it. Is it possible?

I would like to know how to execute code inside a VB
application that will bring up an Access database and then
execute one of it's macros. So far I've been able to write
the following code to bring up the Database, but its not