I have some code for a control 'No of Officers' in my continuous subform
which, depending on the number (from 1 to 8) selected will make visible that
many controls next to it where I enter each officer's ID number. firstly, My
code isn't exactly what I want. All the invisible ...

I have a form called fsubCaseDetails that gets information from another
form fsubCaseSearch. Once the user double clicks a case in the lstCases
on fsubCaseSearch, fsubCaseDetails becomes visible and gets populated
with the information for the selected case.

The query below
SELECT DISTINCT [MyTable1].[ID] , [MyTable1].[Forename],
[MyTable1].[Surname],MyTable.ID,MyTable.forename,MyTable.surname
FROM MyTable INNER JOIN MyTable AS MyTable1 ON

Could someone please help? I am using the 'defaultprt.zip' tool
provided by Ken Getz to change the default printer via VBA code (code
below). My problem is that once the default printer has been changed,
Access 2003 still directs the report to the former default printer.

I have a command which opens a word document, and I would like to insert an
instruction to first check that necessary fields have been completed and give
an error message if not.
I have tried

In my form I locked all the fields in order that the user cannot delete or
change a record.  I do have a command edit button that will unlock all the
fields so the user can update a record and when the user press the naviation
button to previous or next record all the fields will ...

I have an access application where the reports and their underlying queries
change frequently, I'd like to build a push button solution to update these
databases.  Is it possible to return the data in the descrition property of
database objects like queries, forms, reports, ...

Once upon a time,
I was told that, even if at runtime, when exiting an MDE/ADE "application"
the MDE/ADE file is saved by access.
This could explain why my users, after a while (weeks), experience very slow

How can I get just the filename mypic1.jpg from below path? The path can
change to other sub folders, so I'd like to get the text after the last "\".
PATH
C:\data\access\mypic1.jpg

XP/Access 2003
I'm a novice.
Users select records by destination using a Combo box (cboDestination).
If there are no records for the selected destination, a message box asks if

I am trying to refer to a list box on a sub form.  It seems that I have
tried every combination to refer to the list box, but i keep getting the
error that access cant find the "field"  refered to in my expression.  it
names the listbox, so I assume thats what it cant find.

This morning I asked how I could save the value input by a user of a text box
on a form as the default value of that box. John gave me the following code:
Me.txtUnbound.DefaultValue = """Hello World"""
When I open the form the next time the Hello World does not appear. Does

Im quite new to this so pardon my ignorance :)
Am I right in saying that for a data entry form there is no recordset?
If so how can you check for non entered data?
What I am trying to do is verify that data has been entered into the subform

These lines works when the "newstock" value is an integer.
newstock = instock - orderamount
cmdText = "UPDATE tblProduct SET [instock] = " & newstock & "WHERE
[productID] = " & [order.productID] & ";"

Hi
I have a continuous subform.  One of the fields is chkbox.  When the
chkbox=Yes, I would like the AllowDeletions = No, for that row.  If in the
next row the chkbox=No, than I would like the AllowDeletions = Yes.