I have several sub-reports in the footer of a main report.  In certain
situations when one of the sub-reports is pushed down to near the
bottom of the page by the sub-reports above it, the sub-report report
header will display at the bottom of the page, but the detail displays

I have a user who wants to enter Arabic text right-to-left in our 97
Runtime. He says he can enter the text in but it is left-to-right.
Any ideas how?

We have numerous Access 97 apps that we run on our Terminal Server,
but two apps in particular is giving us a problem. The problem we are
running into is when you select a drop down menu, it errors out saying
the SQL server cannot be found. This is through the terminal session

I have this database that calculates and stores the incentive amount
earned by employees of a particular department. Each record is
entered
by entering the Date, Shift (morn, eve, or night) and the 'employee

I've got a combo box control (cboYoMomma) on a main form (frmMain) that I
want to enable only if a subform (sfrmSubForm) does not have any records in
it.  But, once there are records in the subform I want to un-enable that
combo list so it can't be changed.  And, if all the ...

As new Records are added I need to in a Query, count the number of
occurrences of several specific Fields that have change from the
previous record.
As a reference point, each Record is unique for Date and Time so if

In a query one can use the 'IN' operator but how can I do the same
thing in a if statement?? as in the below which does not work.
if MyRec!ClmTyp="p" and MyRec!PolSym in (I,K,O,P,Q,R,S,Z) then
thanks

I am working in MS Access 97, on a database which ahs been established
with no errors for a year.  I have a dodgy field which has imported
into my database, I have no idea how.
A string of text, around 100 chars long has imported into a field

Please help me correct the statements in sub "BoundData"
The following sub is in a module.  Everything runs with no error messages,
however,data is not reaching the text box.  Data is being appended to
WorkingTable but not filtered by value in text box.  If I input data into the

Hi I have written the following query and am having problems with the
last outer join in ms access... it doesn't like the multiple
conditions that I have in there, if I have just one or the other its
OK but not both... and I have tried putting the second condition in a

I have a report that I run every quarter. When I opened it this
quarter, one of the subreports is not displaying. No error message -
just nothing displays where the subreport data should be. If you run
the subreport on its own, it displays fine. It just won't display on

When I searched the newsgroup for this problem, I saw two or three
instances of the question being asked, but it was never answered.  Not
too promising, but here goes:
I have a form with four subforms, and bit of code that cycles through

I am experiencing a little trouble with some code for a date field.  I want a
message box to appear to inform me that I have less than 6-months dating on
an item when someone enters in the receipt document; Expiration Date field.
I am using the below code but keep getting an error.

All of a sudden one of our clients can't use her application.  She
gets "You don't have exclusive access to your database at this time"
when trying to open our application.
The only thing she did today, according to her, was to download and

Good day dear members of the comp.databases.ms-access newsgroup.
Please I need your help on the following.
I'm the administrator of an Access 2007 database.
I would like my enterprise personnel could add entries to one