VB Forum / Database Access / January 2005

i do not know how to create a query
my db is in access
i have to tables "stockmov" and "stock"
stockmov                             stock

Anyone know what might be causing a concurrency error when using OleDb
Update method on a stand alone Access database.  The key of the database is
autonumber if that has any bearing.  Thanks.

I am having a problem that I can't figure out. Don't know if it is in my
logic or in my code. What I am doing is I take data entered into my form and
save it to a table in a database. I then call another form with a Crystal
Reports Viewer to display the data in that table. Then I ...

How can I get to Microssoft Access Field "DecimalPlaces".
It does not show up in the Fields properties in VB6 using ADO.
All I need to do is get the Decimal Places set in Access, also need the
"InputMask", "Format" properties.

is it possible to have a multi column combo box.
actually my requirement is , i have to populate a combo box with values of
3 fields from my table.

Hi all........I have a project that is my first one with VB.net. I have
a listbox with first name, last name, taken from a SQL query that also
contains address, phone and other data pertaining to the name in the
list. I'd like to be able to click on the name and have the person's

I have implemented a paged recordset for a vb6 application that has an MS
Access 2000 database but the query on recordset takes longer to execute
(about 5 minutes for fetching 500 records) than on a non-paged recordset.The
paging I am using is being implemented by using recordset's

I am abou to play around with a new application, which requires users to
connect to an existing .mdb file. I know that I will probably have to move
it to a sql server. I would like to build a client to deploy to each
desktop, but I have no idea on the pitfalls and basic ...

When I insert or update to a MS Access table with a timestamp field, I only
get a date. The time portion of the timestamp is missing.  I am assigning
Now to the field in the VB code.  Anyone have a clue?

I am adding records to an Access  database using VB6  I have two
seperate programs.  if  I add with one program a record the second
program does not see that new record unless I close BOTH PROGRAMS AND
RESTART THEM.  I have tried closing the databases in the programs but

My application allows for data to be imported from previous versions of
databases from previous versions of the software. I have a few basic
questions about SQL statements.
1) How can I tell if a table exists in a database? Sure I could use this: