I have another problem with my form.
On it, I have a command button to "print preview" a report. I would like this report to use only the current information on the active form.
Currently, it will show all the records, starting with the first one on the list. Here is the code ...

I have an unbound checkbox on my form. How can I check the value without it
being bound to a field on a table?

I'm having difficulty in figuring out how to make my existing SQL string to
up date my table for the bound text box. The text box is comments
on the activity the employee has done on this pericular job. The job may take
6 months of activities to complete

   I'm having a table with ~ 2000 records inside.
   I want to add a picture to each record but I don't want to slow down the
DB or increase the size of it.
   I want to show the picture on a for or a report.

I am a new Access user and love this program so far.
I have made a database for an apartment building where the information of
the tenants for each unit is kept. This information is updated using a form.
However, one of the field "Unit Number" will never change and I do not want

First, I know automatic value increment has been talked about a lot,
but I can't seem to get this particular issue resolved.  Basically what
I have are "Case numbers" (automatically assigned) and then "patient
id's" within that case number.  So if we want to enter in 3 patients

Using Access 2000
I have created a  control panel which opens mazimized on_load.
Some of the forms its command buttons control are small.  I open them
restored.

Good morning!
Is it possible to have a combo box with the list being populated by the
names of all the queries/tables/macros. I know i can make the list
manually, but I was curious as to know if there was a way to have

I have a form the opens an Excel file by use of a filedialog object. Excel
opens up, the file is opened also. some formatting is performed and the file
is resaved under a different name and close.  One problem is, after the file
is closed, how do I close Excel?

I have an MS Access form attached to a table. I have a text box which
has its control source set to a field in the table...
However, at run time if certain things change, I want to the change the
text box value to the new number, but I'm unable to do so. I get run

I'm trying to do this formula in access and havin ghard time, can
anyone help me please?
IF[dbo.NTH_ACTIVITY_DEFINITION].ACTIVITY_DEF_DID=[dbo.NTH_ACTIVITY_DEFINITION].ACTIVITY_DEF_DID
AND

I have a list box that I want to base its rowsource on an ADO recordset.  The
user selects a Customer Number then the query goes to the server and looks up
the relevant information and displays it in the list box.
I have successfully done this using:

I've tried searching for this, but have not had any luck.  I'm
relatively new to Access, and this is just getting away from me.  Any
help would be greatly appreciated..
I've got a form set up that has a calendar and a combobox that is

Anyone know if there is a way to assign shortcut keys to tabs on a tabbed
form in Acc2K?  For example, if I have a Summary tab, I'd like the user to
be able to hit somthing like CTL-S to bring that tab to the front.
Any help is appreciated.

I have just completed setting the Tab Order but have came across a strange
problem whereby the P Code text box is not appearing in the tab order box to
select even though is appears on the form under detail??
Does anyone have any suggestions?