I have two date fields:-
1. Shows the data that an application was data entered
2. the other shows the date that a file has moved to a new status.
I have set up a formula that does a simple count of the days in between the

I would like to populate an unbound check box based on a if > then > else
test.
My current (incorrect) code is on the on_current event of my form and is as
follows.

Question
How do you link an embedded object like a picture?
Do you put it in a table that is shared across a network, or do you supply
it with your application that is installed on a remote pc, if so how do you

I have a subform on my data entry form titled Notes. It is able to capture
free format notes and date stamps the notes. I want to have the user ID that
entered the notes/ comments to be captured. I have the sub form set up as
follows:-

I have a simple question.  If I have 2 fields: 1) doc_type_no (i.e. "OA") and
2) doc_descrip ("Original Agreement") on a form, how do I get the doc_descrip
to show up on my form by using the doc_type_no field?  
If I change the properties using the "CHANGE TO" a combo box then it ...

I am posting my problem again because I did not get an answer yet and it has
been a few days.  I read often that you do not like multi postings but I
still have not solved my problem.  So thanks for your patience.
I have a subform that is linked to the main form by an aggregate ...

I have a field named date in my database.  I'm trying to do the following on
the form.
A) On the form I want the date to be entered automatically based on today's
date.  I tried changing the date properties to common expression date(), but

I am creating an Access database for a biology lab.  we have 3 values in our
form.  pH value, Concentration, and test result.  if both pH value or
Concentration be in the acceptable criteria, the value in test result should
automatically return ''pass" , otherwise it should ...

I’m using the automatic send email by using false as the 9th sendObject.  
How do I capture the ‘yes”  or “no” that is clicked on the popup.  Here is my
code:  
DoCmd.SendObject acSendNoObject, , , frmActive.AssignedTo.Column(1), , , , ,

I added textips to the buttons on a form and then drew a rectable around the
command buttons to make the form look nicer, but it had the effect of
disabling the text tips.  When I removed the rectangle the text tips worked
again.  

using VBA I want to save data recently entered into a form to a new table/new
mdb. "DoCmd.TransferDatabase acExport," does not work for me because I want a
new mdb created at the time of save.
thanks!

I've got the following code. Everything works except setting the focus back
to the control I am trying to test. I would appreciate any help. I am working
with Access 97.
Private Sub WedForecast_LostFocus()

I am trying to figure out a way, so when I press the button to open a form
on the switchboard, the form displayed is exactly how I designed it.
Right now, I have forms that are designed to display datasheet view and form
view. How do I write the code for the switchboard to open ...

I used the Application.Printers("PrinterDeviceNameOfDesiredPrinter") function
and it worked fine.  However, is there a way to have the desired printer be
obtained from a user selected combo box on a form?  I tried using
Application.Printers([Device Name]) but I get an error.  ...

I have a form with (2) combo boxes.  The values in Combo Box "SubType" are
based on the value I selected in Combo Box "Type".  If I select  Type 1 in
"Type" then the choice in "SubType" should be 1a, 1b, etc..., if "A" is Type
2 then "B" should be 2a, 2b, etc....