The SQL string returns 4 records if pasted into a QBE grid and run
manually. But in this DAO setting, I can't seem to get it to retrun
any records. When line #340 executes, error tells me No Current
Record. Ideas?

I have created various reports for my database.  When I open the
report in display mode all of the reports display on half of the
screen without any buttons to close, maximize, print or do anything.
The only way I can get the report to close is to hit the escape key.

    A customer has requested that if a integer field shows a 0 or is
null that it appears as 'ND" (or no data).
Not too sure whether this can be defined in the table design or can it
be done as an expression in a report?

I have developed an appointments system database and I use the attached code
in the main form's current event to detect appointment clashes in the
subform.  Is it possible to go to the offending record in the subform so as
to highlight it?  I did originally have this code in the ...

I have a database in MS Access containing 2 tables:
the first one called "weeks" has 4 columns: id, week number (ex:
2007/01), start date(ex:01/01/2007), end date(ex: 07/01/2007)
the second one is called "tests" and has 5 columns: index, date, name,

I have a very large Access 2000 database that for security reasons years ago
I had disabled all right click menus at start up. I now have a need to
develop a form front end were I want the user to be able to use all the
mouse right click filter options (I.e. filter for, filter by ...

I'm not sure what I'm doing wrong here, but I am not able to get value
based on the following query:
select TYPE_ID from MY_TABLE where MY_TABLE.COLUMN_1 = 123456
This query works when I run it in my SQL developer tool displaying the

How do I default a Check Box to have the tick already in it

Is there any way, from within Access, to concatenate several PDF
reports?
Thanks in advance.
Angel.

tblproduct (simplified)
productid(pk)
productcode
productcost

New at macros, trying to send a report to file so it will work on any
machine.
I can't figure out how to send to the TMP directory, or to MY
DOCUMENTS without knowing the user's name... what do I put in the

I have a window with a subform that has a subform.  The main (outter)
window is a single form that enables navigation through the recordset
via buttons (btnFirst,btnPrevious,btnNext,btnLast).  I would normally
put an unbound combobox at the top to enable the user to "jump" to a

I have a simple database using Access 2000 which currently has three fields. I
keep track of my lighthouse collection. The fields are all text, and list the
name of the light, which company it's from, and what state it's located in. I
was wondering if it's possible using Access to ...

When making changes to an object in Access 2007 I have the Navigation
Pane on the left-hand side of the screen and the object under change
displayed in a separate pane on the right-hand side of the screen.
The right-hand pane is too wide to fit on the screen and I cannot,

So I bought a new laptop 10 days ago to test my apps with Vista. (home premium)
Apparently Office 2007 is pre-installed. (a time limited but complete test version, no SP1)
So I take the opportunity to test some new features of Access2007 before actually 'stepping over'.
First thing ...