I tried both of these expressions to get a 0 when there are no
records...neither works.  Any suggestions?
=NZ(DCount([SalesID],"UnPaidChxQ"),0)
Text10=NZ(DCount([SalesID],"UnPaidChxQ"),0)

I use controls’ tag property and BeforeUpdate code to validate missing data
on a form. How can I edit the MsgBox below to show the caption of the label
that’s bound to the control, instead the name of the control (ctl.Name)
that’s currently used? Thanks. - Kurt

I've been shoehorning some objects from a sample "Images in Access" mdb into
one of my mdbs, both Access 97 and mostly successfully. But when I use a
certain form as a subform in my mdb and run it, I get a Compile Error:
"Variable Not Defined" message. This does not occur when the ...

How would you use
object.RootDrive
I am trying to determine what drive a specific file is installed on.

My purpose is to give the user an unmistakable sign when they have opened a
form in Data Entry mode by changing the back color of the form and all
subforms. Rather than hard coding the name of each subform, I would like to
loop through the controls of the main form and if they ...

On my customers form I have a comand button that opens another form for the
orders. how can I auto creat invoice numbers for each order? I tried seting
the default on the [table.invoice#] to 1000+1 and that works if I only place
1 order per customer. I think it would be better in ...

Hi -experimenting with FTP/Download of files using Access - i've been able
to get the FTP.exe working but i'm using txtboxes to capture the
filename,username,password, etc.
and it is possible to download an empty file from the FTP server, if

How do I code a button's OnClick command that will populate a TextBox with a
highlighted item from a ListBox?

I am creating an application in Microsoft Access 2000.  I want the users to
have to enter in a product code in order to use the application.  Is there
some type of built in function to accomplish this?   If not, has anyone done
something similar?  If so, how may I implement this ...

I have posted this before. However, I am yet to find an answer to it.
Is there any product that will allow me to spell check Access 97 memo fields
and possibly other fields in an application? Is it possible to try the
product before I buy it? Any help in this matter is highly ...

I am using a filter to find all the records where Project Type = Asbestos
Survey.  
However, iv made the field into a list box, as i understand that if somebody
incorrectly spelt Asbestos for example, it would not display in the form.

Hi;
   I am trying to, in code,  link to an Advantage database using Access
2003. I try to setup a current connection along the lines of:
With CurrConect

On my form I have a button, which runs code to delete records from a
temporary table:
DoCmd.RunSQL "DELETE myTMPtable.* FROM myTMPtable"
Is it possible to programmatically suppress the delete warning?

I am developing a form with page breaks & subforms and am trying to do the
following:
In a subform, I have a comments box.  When the user checks the "Other" check
box, I have the comments field highlighted & move the focus to the comments

Access forms coding:
Ogle this sample code from threads of yore:
Public Sub NewTab()
   Dim newpage As Page