Yesterday someone reported that their database was growing and wanted
to know what is going on.
I looked at it and in the tables were about 20 new ones named stuff
like aa  ba  asetc bsetc ac  bc    etc

I have linked a table to from Oracle to  Access via ODBC.
I have set up all the proper privilages; however, I am having an issue
inserting data.
I can edit the data already in the table.

When I want to print a report using code I normally use the following code
     DoCmd.OpenReport "RptName", acViewNormal
This works OK when I'm only printing one copy of the report.
What I'm trying to do now is open the CommonDialog using .ShowPrinter

First, apologies iif this is an old problem.  I do read this group,
but I may have missed it.
   When I open a form in A2K to put data into a record (or create a
new record), all is well provided I do not touch the wheel on top of

How do I retrieve the current mdb filename in VB?
Thanks in advance,
john

If I have data in the following format in a database
LE    Amount   BS Class
1      10           Asset
1       15          Liability

I have a form with a first name and last name field right next to each
other. The last name field has no label.
I'm using: defaultvalue="[First Name]" and defaultvalue =="[Last Name]" for
new recs so a beginner-type user knows what goes where. After looking at a

I have a form (that was built before me) with the capability to tag a
company record and/or a contact record (seperate tables linked by
companyid) as "Active" or "Inactive" that is causing me problems.
The problem is, there is a list box that shows companies and contacts

I have an exception table [System exception] that I want to use to
override the "system" for 11 records and use another table
([dbodtlrecs] for the rest of the records.  When I used the following
IIF statement the XTAB query returns the correct "system" for the

Is there a way to trap for a Ctrl or Alt key when typing in a field? I want
to be able to perform an action when the user types Ctl+A or Alt+A or
whatever. I noticed the KeyDown function allows you to check for the state
of the Shift key. I'm looking for something like that for ...

I posted on this subject back a couple weeks ago and learned enough to
know how much I don't know.  I'm thinking I need to simplify and ask
fewer questions.
I've been creating Access databases on an occasional basis for about

I am developing an application in Access 2000 (A2K) which has multiple
forms and subforms.  Until now, all subforms displayed scroll bars
properly (according to the subform's property setting).  However, a
new subform control will not display horizontal scroll bars despite

Simple one this I guess, but I'm quite stuck at the moment.
I would like to update the records displayed in my listbox
(lstStudents) using criteria selected from my combo (cboForm) in a
form.

Is there any way to retrieve data from a Word document, in paragraph form,
and import it into Access?

Has anyone coded a VBA module to access CDDB or freeDB to retrieve
album/song info into a music database.  Thanks.