VB Forum / Database Access / May 2004

I try to create master/detail form by use vb form wizard. Everything
go fine till I try to run it . Error occur by screen tell that "No
value given for one or more required parameters. How can I solve this
problem. Thank you.

My application is designed with VB6.0 and SQLServer7.0. When my
application starts I have a window with the list of databases. To get
some information from each database I have to connect to them in turn.
I use ADO 2.7 to do it. It goes without problem. After connection to

I have a class project that needs to write orders to a database,
the problem that I'm having is I can't seem to write to the second table, I
use my dataAdapter.fill(dt) and it writes to the first table, but after I change
the sql string and use dataAdapter.fill(dt) again it just ...

I have a VBasic program used for a front-end to an Access97 database running
in win98.
I installed a new computer running Win XP and used the same VBasic program
to access the database

the code below errors out when it runs saying it can not find the field in
the table.
I have tried other code and get the same result.
   If dateIcyBaan = Now() And time < #4:30:00 PM# Then

Can anyone help me with Embedded Visual Basic. I have problems with dll.
Palm doesnt see these dll, I mean, it gives messeges: Could not create
component...for example: Grid.
Please if you know how to register maybe these component on palmtop, please

I have an app in VBA that used to use DAO
Now I have moved to ADO, but,....... how then can I get "all the forms or reports of the database".... they are in the container object in the DAO model, but If I have removed DAO,... how can it be don
thank

I have developed dictionary (Eng, Ger, Fra, Ita) in Access. The word list
for each is in separate table (Eng_Ger), (Eng_Fra), (Eng_Ita).
I want to protect my dict from unlegal copying with next procedure:
examine and save the serial number of the hard drive using API calls.

Can anyone tell me why this code fails to return the output parameter from
the SP.
VB.Net Code ----------------
Dim adoCmd As New ADODB.Command

I have an SP with one input param (SP simplified):
SP dbo.blah
(
@IN

i'm trying to set the hyperlink value in an access database using DA0 3.51
on a field who's data type is set to hyperlink (table was created in
access2000, and converted to a previous version via the tools menu.  my
program interacts with the converted database).  using an update ...

My VB6 program uses grids which I can populate from
an Access database using the SELECT command so long
as I only specify one field in the WHERE command, but
I can't make it work with multiple fields. (I've read the

I have a database with current inventory levels.
I have another db that I link 2 tables from the main database. Parts and
PartInventory.
I also have another table that will will hold fields (Part, Qty, Date).

Could anyone help me with an SQL statement in VB6 please. I have a date
field in the database, after a user input a date in a text box, I want the
recordset to return all records with the month and year as the textbox.
Example: user input 5/13/2004

I'm getting the above error, "not updatable field", while I'm trying to
make an insert on a linked Informix table to an Access2000 db(OS W98SE). I
thought it was the code so that I built a normal graphical query
using Access but I got the same error (3113) : I thought it was