I have a subform, and i have 3 fields doing a DLookup.  They work, but in the
last row each one that i have the DLookup function it's displaying #error.
How do i get rid of this?
Thanks

I have a table with which includes two fields, FileNo and PublicationNo.
Normally if I'm referencing one field, I can control it so there can't be
duplicates entered.  In this case, I need to control no duplicates for the
combination of these two fields.  Basically, one ...

Hello Experts,
I am trying to compile my database application, but I seem to be running
into an error on one of my forms in the BeforeUpdate event.  Here is the code
for my validation:

Please see the code below. I am just about to go stir crazy if I can't figure
out why, when a selection is made, that the form doesn't open. Please save me
from the insanity!!!
Private Sub Combo140_Click()

How do I get the selected values that are chosen in a list box into the where
statement for a report to use?
Thanks in advance,
SC in Texas

I have 2 tables in a database 1 called Contacts the other called 7 Step
The relationship is a one to one. There is a form called Contact Details.
This form along with the Contacts table was part of the Contacts Template
that I downloaded.

I'm using AC 2007. I have 2 Calendar Controls on a form. I want one cal
to display the current month and the other to display the next month. I have
this code in the OnLoad of the form:
Private Sub Form_Load()

I created the following code based largely on a suggestion by Allen
Browne http://allenbrowne.com/ser-50.html
My form has 4 unbound multi-select list boxes and each one has a query
as its row source.

I would like to filter a report based on both
- OrderID
- DataRange
Here part of the code. I am Ok with OrderID filter, but when I try to add

I am trying to adapt the Mr Lebans routine to export to Pdf and I would like
to print the report based on the data range.
Without the data range is OK, but I don't know where to pass "DataRange"
criteria in the function blRet.

Since a full date is not recorded, my form has a MonthID field (Number
datatype) and a YearID field (also Number datatype).  Both receive values via
a combo list.
I would like to have the form validate that the month and year combination

I'm using SendObject behind a Command Button to e-mail a Report in Snapshot
format, and that works just fine.
But what I'd also like to do is be able to Click a Command Button and e-mail
a specific (fixed)  pdf  file I have on my c: drive, in the folder "forms".

I'm trying to pass a value from my subform and have the mainform display that
record.  I have tried:
Me.Parent![mymainform].SetFocus
DoCmd.GoToRecord acDataForm, "mymainform", acGoTo, recordID_frm_Subform

I am in the middle of programming a search form, and one function I wish it
to have is the ability to search by keywords. Currently, I have a one-to-many
relationship set up between my main table and the table holding the keyword(s)
. They are related by the field lngRecID. On my ...

I have developed an application in Access 2007.  I created a custom ribbon
that basically has nothing on it. (A blank Tab appears)  I generated a
deployment package that uses the runtime.  When I install it on a test
machine, everything looks good. (If I minimize the ribbon, you ...