Hi Again,
Throwing this one out to you again as i am not getting anywhere and
can find little to no information out there.
I am currently displaying images (Jpegs) in access via the routine set

I have a field that records whether an Employee is permanent or
temporary. My thought was to simply have 1 field that if checked means
that the employee is a permanent hire as opposed to an unchecked box
which means that person is a temporary employee.

I know that I can use the Parent property to get the name of the form
that a subform is on, but what if I need the name of the subform/
subreport "box" on that form that contains my subform? I've not found
a direct way to get that little nugget of information.

Using Access 2007 and Windows XP
I get the Error : Can't complete the output operation
Error occurs whe I use the sendobject or OutputTo
Ex.

I seemed to have lost the ability to move my mouse over a variable in
my VBA code and have it's current value displayed.  There's probably a
setting somewhere but I'm not sure what it is.  Would appreciate any
help.

Hello, im trying to open a form from an dialog box form:
the button on the dialog box has this on the onclick event:
DoCmd.OpenForm "frmCASES_UNION", acViewNormal, , "MCH_CASECODE = #" &
Me!txtCCODE & "#"

Hi all, can anyone help me with this one?
I have a database that has multiple linked tables and i want some code
to tell the database on startup to do first check for the tables in a
folder on one drive, and if not present to get them from another.

Sagekey is almost there but below is the more advanced solution,
although no software is hackers free as they claimed. But for ms
access access deployment, I think nothing bet this product as of this
time.

My application has a form based on a parent table with a subform based
on a child table.  The relationship is Cascade Delete.  The first
record displayed when the form opens has five child records. The form
allows this record to be deleted without a prompt, though SetWarnings

I'm deliberately posting this message in this group, so please don't
flame me....Does anyone have any experience with the training that
Microsoft offers for .NET?  Our company plans to make the transition
from Access/VBA to .NET, so we are beginning to look into some

I have a table i use to store scores for employees.
EMPID  Q1  Q2  Q3
1234       3    2     4
Q1,Q2 & Q3 being the separate questions and the numbers (in this case

Access 2003
 I need to keep a history of the change of status of two fields to a
history table.  My problem is that I keep appending all of the records
in a table instead of the fields I want in the "current record".  The

Using Access 2007
Can I open the calendar that automatically appears next to date fields with
a keyboard shortcut as I dont want to use the mouse
Thanks

Hi Group (fairly limited knowledge of Access and almost none of Access
VBA.  Using Access 2003).
I need to sum time, I've found through the groups archive an sql
extract that led me to this

I have 2 fields one completed date and the other a combo box with 4
headings, completed is one of them
If completed is selected and the date hasnt been filled in I would
like to have a message box saying that if "Completed" is selected then