I have two subforms on my main form. I want the records on subform B
to correspond with the records on subform A which they do. However,
I want the records on subform A to let me know if there is a
corresponding record on subform B without having to go to subform B

I have one more problem to solve before completing my database.
I need to save address labels to file.  I know Label Wizard does this, but
my problem needs to be selective.  The customers are 'active' or 'not
active' and I need to create separate labels for both.

Hi, I have a problem that I'm pulling my hair out over.
I work at a company that legally has to test the blood lead levels of
it's employees.
Each person must be tested every 6 months. I have the results in a

A while back (around mid September) I posted a message about how I'd
configured my client apps to upload error messages to my web server.
I really like the service, but David Fenton suggested that the IE factor
was unsafe and ill advised.  Since that time, I was tasked to figure out

Is the above possible?
I guess I need an API call for this ? How and where to find this?
One of my new apps is used as a sort of 'dedicated' thing.
Users see an empty desktop with *only* two buttons. They only click a button to start the app.

Is there a way to tell if a combbox is in dropdown mode.
I tried and if statement combobox.dropdown = true
but i get an error. dropwndown function doesnt store if its true or
false

How can I programatically, take some Date/Time fields present in a table in
the current database and change their type to text?
dixie

For a Lodging reservatgions system, I need to build in a Flowchart type
Calendar. Also called a "Tape" in the lodging business.  This has a
list of rental units down the left side and dates along the top. Booked
dates are blocked out.

I have a spreadsheet that uses VBA code in Access to save itself as a text
file.  The line is as follows.
xl.ActiveSheet.SaveAs CurrentProject.Path & "\Reports\" &
DLookup("[LetterLabel]", "tblButtons", "ControlID=141") & ".txt", 20 ' 20 =

I am using this command to import text file:
       DoCmd.TransferText acImportDelim, str_SpecName, str_TblName,
str_FileName, False
- The import will always be missing the first line in the text file.

Dear read,
In a detailed part of a report you can use a form as print layout.
In case the number of record to be printed are not fit in one page the group
header will print on top of the page

I have the following line in a function within my form:
           Me.intStatusID.Value = StatusType.OpenID
Where Me.IntStatusID.Value references a field in this form's recordset
- not a field displayed on the form.

I'm in need of an ALL CAPS FONT for an Access 97 report
mimicking a state government form. All letters are capitalized
in form - that is, there are no lower case letters. But when you
hold the shift key down a type a letter, that letter is a tiny bit

I have a form where the user copies a handwritten contract into a text
field "Contract1".
The contract usually exeeds 255 characters.
Therefore I provided "Contract2", "Contract3", and "Contract4" fields.

I have a main form (frmNewOrder)  and a sub form (SubOrderBeneficiary).
On the main form I have a button which sends the Subform
(SubOrderBeneficiary) to a newrecord. Everything works fine expect that
when I press the button, the controls on the subform display an #Error