Access 2000 database.
With Allen Browne's help, I now have a database that will track and display
a 3 tiered downline of client's with recruits.  HUGE THANK YOU Allen!!!!!!!
http://www.microsoft.com/office/community/en-us/default ...

My list box returns values of '-1' or '0', for my Yes/No fields.  I want it
to return 'Yes' or 'No', not the numeric expression of the value.
In the Table I have set the datatype Yes/No to 'Text' in the Display
property, and I note that the Query on which the List Box is based - ...

Running NotInList event on cboAdjusterID to open pop up frmAdjuster and then
add the new item.  Upon closing frmAdjuster, get "missing operator" error
that when debugged highlights the .FindFirst "[AdjusterID] ... line.  The
combo is bound by the ID field which is a number but ...

Form (frmNEWPROPERTYentry)
subform (subDEFENDANTentry)
on subform there is a control (cboDEFENDANTSNAME) whose recordsource is
DefendantNamesID and is bound to taDEFENDANTSNAME.

Hi Groupies:
I have a dlookup on a continuous subform. It appears to be searching with
the correct value but it is returning the lookup value from the first record
in the table.

Is it possible to hide a record on a subform or at least disable a certain
record once it has been edited?  Or, is it possible to find a record number
and then have that record on the subform disabled so it can't be edited?
Thanks!

Function RecordCountZero()
If DoCmd.OpenQuery("CountOfUserExistingRecords") = 0 Then
   DoCmd.Close ([Costpoint Reversals Processor])
   DoCmd.OpenForm ([Costpoint Processor New Record])

In my database I have a command button which has the
following on click:
Private Sub GiftCatalogue_Click()
   Application.FollowHyperlink "C\...\Silo Gift Catalogue.ppt", ,

I have a form based on a query.  In the forms footer I have a field
[GTotalHours] with a control source of =Sum([Hours]).  For some reason
[GTotalHours] will not calculate anything after the decimal.  For example.
1.1

Is there a way that you can import the structure of a form in Excel to an
Access form?

I have a form to edit a record and my code is causing problems when there are
no changes made to the form.  If I select No when there are no changes, it
gives a run-time error 2046; saving with no changes works. If there are
changes to the data it works fine either saving or not ...

I have been experimenting with a simple cash sheet database with the
following fields:
BillPaymentsTable
PaymentID (AutoNumber & PK)

I have two subreports that print fine when subreport only is on screen.  When
main report is on screen certain fields don't print for print preview or when
report in printed.  Any hints to what the problem is?
Thanks,

I'm trying to print a report based on the corrent record in the form.
I'm sure I've used this code before, but this time it seems to be acting
different then usual.
I don't get an error message, but it pops up a box with the "SlsId" above a

I have a button with an on click event like this:
If Me.Comments = "" Then
 Me.LockedRecord = False
Else