Is it possible to have a conditional format to set, for example, the
.Visible property of a control? Or is it only possible to use the
FormatCondition members such as .ForeColor etc...?
Thanks in advance.

I am having a problem with the syntax for the following code.
   '''If specified a Work Area
   If Not IsNothing(Me.cboWorkArea) Then
       varWhere = (varWhere + " AND ") & "[WorkArea] LIKE '*" &

Anyone know how to get the columncount from a listview from code. Here's
what I would like to achieve...
Recordset with 4 fields
I know how to program the listview when the columncount is always the same.

I have several tables I want to use the same form for, I would like to
select the record source from a combo box.
I have a combo box that list all the tables from a table named "Table
names" when I select the name I would like that to be the record

Hello, everyone,
I'm wondering if anyone has any suggestions for this...
I want this data entry form to allow access to only a subset of
records in the underlying table, based on their Type Code.  I have a

I would like to have a screen shot for my data entry form only.
I tried to use ALT+ PrtSc key press to catch the screen.
It seems to copy all the Access application, not the data entry screen.
I found the help file that it says ALT + PrtSC can capture active Windows.

I use the following code as the row source in a combo box:
SELECT [Months].[MonthNo], [Months].[Month] FROM Months UNION Select Null as
AllChoice, "(All)" as Bogus From Months ORDER BY [Months].[MonthNo];
The combo box works fine and produces the correct results (which are then

I'm trying to create an auto generating drop box on a data entry form.  That
is, someone would be entering data that may pertain to more that one project.
I'd like to have a drop down menu that, once a value is selected from it, an
exact duplicate appears underneath, and the ...

i'm having some probles with this, hope someone can help me.
i have 2 tables: tblPrestamos  and tblPagosPrestamos y created the querys and
opened 2 recorsets
   Dim db     As Database

I have a customer info input form and link to a subform.  However, I would
like to lock a particular field in this subform and leave the rest of the
fileds in this subform unlock.  
Anyone can help?   Thanks a lot.

I want to have running text on the status bar.
Any example to do this?
Your information is great appreciated,

Hello,
I am looking for an ActiveX Control that will allow me to navigate through
Jpeg files located in a folder in a specific location.  For example, Client A
has jpeg files pertaining just to them, as does Client B, etc.  All I am

When I filter records in a split form using a lookup field in a combo box
nothing is displayed in the Record # of #. I've had this problem
since installing Access 2007 and I was hoping iyt had goytten bettor but no
such luck. Nothing is displayed there at times when I open the form. ...

I have eight fields in a continuous sub-form.  When any of them changes, I
need to recalculate a 9th field (Average Rating).  In addition, I want the
Average Rating to be calculated when the form appears.
I currently have the calculation in a module that is called from each of the ...

Access 2003 and Word 2003 files.  Is it possible to print a list of Word
documents from within an Access form without having to open each document in
Word and print it?
I have a subform which lists all the WordDocs that relate to the primary key