VB Forum / Database Access / March 2005

is there a way to concatenate the contents of an array (looping through the
array) and storing each item in a comma delimited string?
Thanks!

Hi
I am currently a program that needs to add data an Access Database that is
in version Access 2000, the problem is that this program will need to run on
more than one platform and write data to a different machine.

Good day all,
Using VB 6 and SQL query to an Access type database.
I have a table called JobCard that has jobnumbers in and I need to pull out data relating to another table called Job
Card Product and another called Product. I can make my first inner Join work like this:

I know how to check a textbox to see if it's a date
(Isdate(txtfield))
but how can I check to see if it is a date in the future?
Thanks

  I have an application that, upon exiting, has to update upwards of 300+
records in a SQL Server database.  The update statements are very basic
ones, following textbook update guidelines.     I am programming in Visual
Basic .Net 2003

I am attempting to set up a form in VB.Net that will display 3 grids from 2
tables.  
The tables are setup like this:
Transaction table with TransID

I can't figure out why the following code isn't working.  I even copied and
pasted it directly from MS Access 2000, SQL view in the Query designer.  Am
I perhaps missing a Project Reference?  I'm using:
MS ActiveX Data Objects 2.8 Library

My table in an Access 2000 database that is shared between several
computers, and contains a Memo field with lots of information on it (about 1
to 10Kb of plain text).
The program is written in VB6 SP5, and must continue that way for a while.

I have a form with testboxes linked to one table in a database and a
datagrid linked to another table. These two tables have a relationship
between them. I can get my text boxes to display and recieve data, but
everytime I enter data in teh datagrid it comes up with an error ...

I use Visual Basic 6, Service Pack 6, Microsoft ActiveX Data Objects
2.8 Library(msado15.dll) and access 2000 database using JET 4 OLE. I
have an application that adds records simultaneously to the same table.
During the simultaneous add and update, a Locked error occurs, and most

I want to use the find method to look for  book titles in an Access
database.
The problem comes when there is an apostrophe in a title eg The Devil's
Bank.

In an Access 2000 app, I have a global adodb.connection and recordset. What I
would like to do is have a sub that takes the text of a query (in the Queries
collection) as a string and opens the recordset based on that query. My code
looks like:

In the command shell, I am trying to set the results of a find command to a
variable, so that I may access the variable later. The command I have so far
is:
dir | find "03/07/2005  03:17 PM"|\\ramtss11\MarketData\Diag\utils\cut.exe

I have a vb application that talk to the MS Access in the back end. In the
development environment everything seems to work as it should. When i did an
EXE and i try to run the same bit of code i have the following error:
Run-time error '387':

Hi, I am developing a windows app that is migrating from ACCESS to SQL
Server.  In VBA I have embedded my connection strings in code behind the
forms.  My questions is this:  is there a safer way to store this information
besides connecting on the fly?  Can the information be ...