I have a form which opens up a subform. On subform, there is a tab control
which has five tabs on it. Each tab contains a sub-form on it. I have a combo
box on one of these sub-forms to which I am attempting to add in
functionality to implement a recent entries list. I have the ...

Should the following statement work in Conditional
Formatting for a field?
 DCount("Kept","tblCatch","IvDetId=" & Me![txtIvDetId])>0
I copied the syntax from a form module, so maybe it needs to

Thanks for the previous help.
I now need some direction in setting code to automatically import data from
excel into Access97.
I have set up my queries for the import, and it works like a champ. Before I

Using Access 2003.
Two tables.
tblBank - BankID (autonumber PK), PersonId (Long integer), MonthDate
(DateTime), DepositAmt (currency)

I have researched for this type of question in this forum and can't find
something similar.  I am not sure if this can be done since most questions
are based on different tables.  I feel this is maybe very simple but I am
stuck and can't get this to work.  I have a form with only ...

Hi, all.
As you know in Scandinavia we use «Post office number» and «Post office
name» when addressing post. Each post office has it's «Post office number»
and «Post office name». In a Access database of mine I have a table with two

I posted this question a couple of days ago and got 1 response but
couldn't read it.  Hopefully someone will have and answer.
I have a form/subform for entering invoice data.  What can I do if I
realize that I have already entered the invoice ?  Example:  I enter

Good morning,
I have created a database with Access 2003.
I imported 17 records from Excel into the products table.
When I open the input form to add new or correct the existing records,

I have a combo box with the source of table.id, table.name.  I want to filter
by selecting table.name where table.id=form.id.  The filter works just fine,
but when I remove the filter using the code
Private Sub RemoveFilter_Click()

I have a subform that is a datasheet. I want one of the controls not to be
visible. I've change the Visible property to No but it still shows in the
subform. How do I make it invisible. It is used as part of a calculated
control and I don't want it to be seen.Thanks

I have developed a form with approx 36 fields. Each field/control places the
data in several reports.
I noticed when I get to the end of the form, it begins all over again. I
want the data to be entered only 1 time. Is there a way to limit the form to

I have a form frmreferb which has a sunbform called frmreferbdetails
(Continues Form) on the subform I have a text box called quantity and a
Priceperunit text box. I have a Total Text box with the control source set
to =[Quantity]*[PricePerUnit] this gives me the total of each line. ...

In an Access 2007 form I have a combo box based on a table with 2 fields.
Although I have the Column Count set to 2 and column width for both,
only the bound column displays when the cbo is closed. Only when I
open the cbo does the other column display.

Other controls get hidden when I 'Bring To Front' the Tab control.
Even if I Send Back the List and Subform they stay in front. Is this normal?
Can code have more control.

Hi, I am designing a form that my client would like the date and time
automatically recorded in a field and stored so that when they refer back it
shows when the record was done. The 'NOW' function only shows the current
date & time and keeps updating. Is there a way of putting ...