I do not understand why I have an error message on a NoData message based on
a report. I have a form which has a combo box to choose the parameter of a
report. Once you choose the parameter from the list, you click on OK and it
runs the report. If there is no data for the report, ...

Hi Groupies:
I have a table with all employees (250 records) and another table with a
record of the certifcations they have received, (200 records). The
relationship is 1 to 1 based on the Employee Number. The Employee form has a

I've just started a new DB. The main form has a control Clock that simply
displays the current time and date to the second. It is live, as I put the
Timer Interval as 1000 and the On Timer procedure as [Clock] = Now
A few things:

I have a form that has a combo box and 2 text boxes.  The combo is populated
via a select and has 3 columns, FieldA , FieldB, and FieldC.  When the user
selects FieldA in the combo box, I want to autopopulate the two text fields
with the FieldB and FieldC values that coorespond ...

I want to open a form in Continuous Forms view and have a specific record
first then the subsequent records following. I get the value of a field named
[ItemCode] from another form that is already open and I have used the code :
           DoCmd.OpenForm "Cost", , , "[ItemCode] = ...

I keep getting a syntax error and i don't know what i am doing wrong.
I have two list boxes.  box 1 is lstAccreditation, box 2 is lstAccreditationFR
I use the following code to call each box depending on the language
required.  The english one works great, but the french one keeps ...

I have a number of subforms that relate to a single master form. I would like
to call a class that acts as a "dataservice" to get the record set for each
of the differnt pices of information. The problem is that I am not sure how
to make the module recordset equal the recordset ...

I need to be able to send an Outlook task from an Access from. The code I
have tried is not working. I am currently using this code:
Private Sub SendTask_Click()
Function fncAddOutlookTask()

Is there any way to alter the font, fontSize etc of the text in a SubForm
I have an UnBound Form with a SubForm which is bound to a query and if I
could get the details in the SubForm to print smaller on screen then the
horizontal scroll bars would vanish !!

Sorry for the repost, but I didn't get any comments regarding this:
I was revising my code as recommended to avoid using:
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

I have [master form], [subform1], and [subform2]
I want [subform2] to refresh after BarcodeID in [subform1] is updated.
In [subform1] for BarcodeID control I have:
Private Sub BarcodeID_AfterUpdate()    'in subform1

I was hoping o ue a query qryOut as my recordsource for an output file.  Is
this possible?  Reason being that this query is based on another
query...trying to take the easy way out.
Dim db As Database

I have a list box that is querying a table for its data - it is a list of
processes, and the associated procedure steps for those processes. I need to
allow users to select multiple procedure steps (i.e. steps 1 and 2-6 for
process A) and have those saved in the record for that ...

I use the transfertext to output the data the way my customer wants.  
Is there a way I can create the text file and mail it to them as an
attachment in the same set of VBA code?
TIA,

I have a combo box whose drop-down list of values should be the current list
of all of the unique values that have thus far been entered into that field
(the control source field for the combo box is the same as the list of the
drop-down)