I am importing a large text file into a talbe.  Here are the steps:
- Delete all records in a table
- import CSV file into table (Transfertext )
- update additiona fileds in the table (user id , time stamp ect.)

I am developping a software that uses by default an Access database, but I
want to allow the user to create copies of this database on Oracle,
PostGreSQL and other DBMS, keeping the same structure and relations (or
foreign keys), and to access the data of these databases ...

I am curently using a number of macros each of which runs a large number of
queries.  I am told that this is not good practice, and that I should write
VBA code which executes the SQL code for each of the queries in turn.  So,
the VBA would do the same job as the macro, but in a ...

I am trying to set up a prompt when I input data to remind me to check
something?

Hello pros, I have a table with 3 fields [Address](text), [Sent](date),
[Yes/No](Yes/No)
(I am using access 2003) What's the easy way to automatically enter today's
date in the [Sent] field IF the Yes/No button is checked (If checked I want

In the calculation  - Total: Sum(qQueryA.columnA) -  the outcome can be 0,
1, 2, etc..
What I want is, that if the outcome is 0, that outcome will be changed to 1.
Else all outcomes (so 1 and higher) will be excepted as they come.

Fellow programmers, this is a weird one. I have had this happen a couple of
times before, but don't remember what I did to solve the problem.
I have form fields referenced in the source of dropdown fields (like
[Forms]![frmWhatever]![cboWhatever].

I have a report that is based on a query. The query is filled with
information between two dates that are set as peramiters in the query. [Start
Date] and [End Date]. How do I pass the values of the peramiters to my
variables to undertake a calculation to show how many days there ...

I would like the table to hold the invoice total but I can't figure out how
(the actual equation) or where to put it so that it auto sums the individual
items and puts the totals in.  

Anybody there? Please help. I using Access Versions 11.  Below is the code
that I'm having the above error message with. I'm trying to create a
recordset from an access table. I plan on using the recordset in some codes
to follow which is not included in this pasted codes (trying ...

Hi -
I have two Access databases (DB1 and DB2).  DB2 has VB classes and tables
that I'd like to use in DB1.  How can I share Classes across databases?
I tried instantiating DB2 from DB1.

Here's my table structure:
KTFJobs:
pk JobNumber : Number
JobTitle : Text

I am getting an automation error and my code stops here
Set connData = New ADODB.Connection
It was working fine and then someone tried to update the window 2000 server
and had problems doing so.

I have implemented Allen Browne's excellent method to handle opening multiple
instances of the same form:
http://allenbrowne.com/ser-35.html
Question though around referencing the form.  I can open the form and

I have a combobox which lists few values.
I want the user to be able to choose a value or to enter a new one.
I wrote this precedure:
Private Sub curante_NotInList(NewData As String, Response As Integer)