This is a strange one that I can't seem to find a fix for.
We have a Billing DB application (Access 2000 format) where we upload
billing info in a comma delimited text file to our printer who prints and
mails our bills. The application basically creates a table then exports a

Hello everyone! This is my first post so please bear with me. We have
recently re-vamped an Access application such that in each of our 5
locations
a local SQL server receives published updates from our main office server.

I?ve been using the code below in Access 97 for years now without any
problems at all. Unfortunately, I now have to convert this db to Access
2000. I tried using the conversion feature and that was a bust. All my
reports, queries and other forms work OK except for this routine. The ...

Hello, I am trying to export all the data from one Access database to
another Access database.
I selected one of my five tables, then clicked "File"-->"Export".
Because my table from database A was going to over-write the table

Alison,
You are going to find this a real coincidence! To begin with, I am Roberta
Laird's husband. I think you know Roberta. We also are friends with Laura
McConnell. Anyway, I am in business to provide customers with a resource for

Across all of my Access 2000 applications, I have suddenly "lost" the menu
bar.     File Edit ....... at the top.
I can't find any info on this "problem".
Any suggestions on getting it back will be greatly appreciated.

Access 97.
I have a form where there is an option group with two buttons, and a
combo box.  The combo box Row Source is a query.  The option group has
two options a) include a subset of the query where all records with

What I am looking for is help trying to accomplish control + tab
exiting subform #1 on page #1 and entering the first control (main
form) on page #2.  I've tried the following code, however it seems to
"fire twice", placing me at the first control on subform #2 on page

I have a main form and a subform (based on a query) which works just
fine. When I try to add a page to my form my first page page starts to
flicker.
Has anyone had this problem before?

Hi,
need some help/idea...
I have data table in Excel(about 30 columns) and it's getting too big
(over 65K) so I need to move it to DB (MS Access is the choice)

Can anyone help please.
I need a small executable (either the VB code or the program itself will
do) to run within a batch file to activate a running 3rd party DOS
window (identified by the window name/title) and close it.

I'm sure this is a very easy one if you know, but any help would be
appreciated
I have a field in my database which needs to be as long as poosible.
in the help it says that a memo field is 4000 odd characters long,

Does anyone have an example of using PDFWriter (4.0 or later) from VB or VBA
code?
Specifically, how to use Adobe's PDFDocInfo when calling the Window Printer
Escape API to name to document and prevent the dialog box from displaying.

I am trying to find out what are the big differences between access
database Jet engine and SQL Server? If I have serveral web
applications (same content different copies) running as different
sites(on IIS), each site using an access as a back-end database, all

I have inherited a badly designed database and am trying to improve
it.
It is basically a flat file for survey results.
one table holds, Name, Age etc as well as a field for each question.