Import from csv file works fine , but not in multi user env.
Sun, 13 Apr 2008 09:19:00 -0700
Hello,
I have a front-end db and back-end db. The FE imports csv files into tables.
This works fine but if more than one user tries to import the files then only
the first gets all data. How to manage this for multi user or catch this with
message "currently in use, try later".??
thx
juvi ...
|
Left join query in ADO gives FALSE instead of NULL from linked sqlserver
Fri, 11 Apr 2008 19:59:27 -0400
(previously posted in .formscoding group but got no responses)
Hi,
I have been using DAO and ADO for years to get at data from linked tables
and by accident I am finding a fault with ADO.
My query is below and tmpTrans is a local Access table while all the others
are SQL2005 tables. I am linked to all of t ...
|
Loop Code
Thu, 10 Apr 2008 22:32:00 -0700
Hi,
I have the code below that would copy data from one table (rsSource) into
another table (rsTarget). Is there a loop code that would enable me to do
something like the following:
Loop for N =1 till 40
If rsSource![ResultN] <> "" Then
rsTarget.Edit
rsTarget![DateN] = rsSource![DateN]
rsTarget![Resul ...
|
Re: 685 bloqueador veicular sem mensalidades - http://bloqueadorgsm.vilabol.uol.com.br 6857103823874760003301782
Sun, 06 Apr 2008 00:34:46 +0100
On Fri 04 Apr 2008 22:49:33, bloqueador sem mensalidade
<bloqueador.rastreador@localizador.gps.com> wrote:
> Bloqueador veícluar com tecnologia gsm - Sem mensalidades
>
> Tenha toda segurança para seu carro com um preço justo.
>
> Apenas R$ 299,00 ( sem mensalidades )
>
> http://bloqueadorgsm.vi ...
|
How to set the ODBCtimeout property in code
Wed, 2 Apr 2008 09:00:02 -0700
Can I set the ODBCtimeout property in code (don't want to fool around with
the Registry settings)
-----------------------
I have code that loops through each table in my database and gets the number
of records in each table. It outputs the table name and number of records to
another table.
Some tables h ...
|
Unsecure MDE
Tue, 1 Apr 2008 14:11:00 -0700
I am use to working with Windows XP and Office XP, but started new job and I
am running Window 2000 and Office 2003. Which means I had to convert each
MDB from Access 2000. I then split the MDB successfully and created the MDE
successfully. However, under the View menu, I can still change the forms
view a ...
|
Office for XP (2002) and Visual Studio 9.0
Fri, 28 Mar 2008 02:44:00 -0700
Hi,
I'm using Access from Office for XP (2002). I programmed an administration
application for myself and this always worked verry nice.
Recently I installed Visual Studio 9.0 and now, when I try to open the
database, I get the following message;
The feature you trying to use in on a CD-ROM or other remov ...
|
|
|
Problem quitting Excel in Acess VBA code
Wed, 26 Mar 2008 12:14:01 -0700
I have the same problem that Mike has on a previous post. My code quits Excel
on the screen but leaves Excel running in the Task Manager. My project is to
transfer an Access Table to Excel and convert it to a Pivot Table. To do this
each time
I have to delete the Excel file and exit Excel. All my code is wo ...
|
Dont read
Tue, 25 Mar 2008 11:47:03 +0100
Vendo coche de segunda mano, Seat ibiza, a? 2001 km
35000, Solo por 4500 euros.
[URL=http://www.anunciosgratis.de]Anuncios Gratis[/URL]
www.AnunciosGratis.de http://www.AnunciosGratis.de Anuncios
Gratis. ...
|
Writing code to turn off a command button.
Mon, 24 Mar 2008 02:37:34 +0800
I have been given the task of updating an employee list/personnal
information for a Regional Health Authority.
Because there are 25 facilities in the RHA, lots of employees work in more
the one site. But I only need to have them listed once.
What I have done is I have form (FRM-CheckName)to enter the empl ...
|
