In raport i have a field "material" in  detail section. Sometime
material can have null value than I would like to get  a msgbox
"something" in preview of raport.
When I write the code in  Detail_Print procedure:

In my access form, I do not want the record navigation button in the bottom
to display. How can I hide it from the interface?
Thanks,
Smriti

Is there a way to open the MS Outlook address book using VBA and then
be able to do something with the return value?
I want users to click an icon to open the Outlook address book then
when an address is selected, populate an Access field with the address.

need help going from one txtbox in one subform to another textbox in
another subform
so i have
main frm -inside there are: subfrm1 (textboxes: a1 a2 a3 ) and subfrm2

I have 2 address lines in a table. Quite often they will look like
this:
ADDRESS1:  JOHN SMITH DBA JS TRUCKING
ADDRESS2:  COMPANY

I have a table to track equipment in a network, we'll use 24-port hubs
as our example.  tblEquipment has fields:
ID - Autonumber
Equipment - Text (Hub,Router,etc)

A database converted from Access 97 to Access 2003 contained code to
load jpeg photos into Microsoft Photo Editor.
As Office 2003 Professional does not come with Microsoft Photo Editor,
is there any way to register the copy from the Office 97 disk with the

Anybody had experience with the commerical (or open source) Access based
accounting packages out there.
I'm looking to replace a small business accounting package (Peachtree) that
I can't customize enought to do what I need

In another forum, I've ticked someone off really bad!!!
They've responded with a neat little bomb which, if I
attempt to log-in to the site, throws me completely
out of the internet.  Neat trick! Just out of idle

Is there a way in Access to convert a date in format "mdy - 08/05/2005"
to "ymd - 2005-08-05" using an update query?

Hi Folk
I have written a module that allows you to type a bunch of commands in the
immediate window, for quick access to information when you are creating VB
code.  Here it is, it may be helpful to you (I find it pretty fast and

I have a combo box that displays contact names. The recordsource
contains ID and contact names (displayed as 0;1", column count 2, bound
column 1).
All works well except while changing records on the main form the

I was running an update query and a make table query from a form to
modify some data in a table.
DoCmd.OpenQuery "qryrename"
DoCmd.OpenQuery "qrymaketest"

I have a mailmerge setup from my database.  The database records Police
Cases, the incidents that make up each case and the perpetrators
involved in each incident.
tblCase 1->M tblIncident 1->M tblPerpetrator

I am trying to combine the following two queries into a single one.......can
it be done?
SELECT tblRedline.PartNo, Max(tblRedline.DateValidTo) AS DateValidTo
FROM tblRedline