I have a [One] table with two key fields, [x] and [y].  [One] has a
one-to-many relationship to [Many], the latter having foreign key fields [x]
and [y] and another key field [z].
Form [frmMany] has separate combo box controls for the two foreign key

I have an issue that I am not sure how to solve.  I have a subform
(Datasheet view) that lists milestones associated with a task.  When the
user changes the planned date of milestone completion I then add a
reminder to MS Outlook based on a users answer (Yes/No MsgBox - called

I have this code in the Form_Current event of subform [frm Project
Information].
Me.cboProduct = DLookup("Product", "tblProductGroupFunction",
"ProductGroupID = Forms!frmMain![frm Project

This worked the last time I opened the database.
reportDate: IIf(Len([last call time])<7,Date(),DateValue(Left([last call
time],InStr([last call time]," "))))
It gives "compile error in query expression" now

I am looking for a function which will convert currency to words, eg £450.00
to Four hundred and fifty pounds.
Am using Access 2002
Any assistance would be appreciated

Greetings all.
I'm currently building an access app that mimicks my client's old Lotus app.
They would rather have me prioritize recreation over making improvements so
that their employees will know their way around.  Needless to say, this makes

OK I've been working on a form that displays a tab only when a box it
checked.  How can I do this?
Private Sub Check122_Click()
If Me!Check122 = True Then

Ok so I have a form with multiple tabs.  Each tab is set to the record ID to
tie them all together.  I've removed all navigating control from each tab
(form) however if I move my mouse wheel, I get a new blank tab not associated
with anything.  Is there a way to prevent this?  ...

I have this code for a delete button on my form:
Private Sub cmdDelete_Click()
On Error GoTo Err_cmdDelete_Click
   If vbYes = MsgBox("You are about to delete 1 record." & vbCrLf & vbCrLf

I use this code to present a messagebox when a control is clicked.
MsgBox "If the employee's wage changes, enter the amount" & Chr(10) &
Chr(10) & _
"and the date the wage changed. The employee's " & Chr(10) & Chr(10) & _

I am trying to send the current form as an attachment to the email. In the
process, I tried to send very simple emails but unfortunately was not
successful. I tried:
1)    DoCmd.SendObject acSendNoObject, , , "myEmail", , , "some Subject ",

My problem is that access apps that need the ADOX Library running under Win
XP require "ADO Ext. 2.8 for DLL and Security". When run on Vista, the ADOX
version must be "ADO Ext. 6.0 for DLL and Security".
I have created working functions to add and remove the "ADOX" Library. The

I would like to create code in a form button that opens a popup form with
the cursor automaticaly going to a combobox and automaticaly rolling down the
combobox values without clicking on anything.
Is that possible?

I need your assistance regarding the visibility of a field and its associated
label.  I want to hide the visibility of a particular label and associated
field for each record from a query that that is the source to the form.
I use the check box named "Grievance_Filed" to activate ...

I have a Switchboard with all unbound controls that I use to build SQL for
the underlying query for another data form.  If I enter something into a
textbox and go straight to the button that opens the data form, the value
that I typed into the textbox is not seen.  But if I tab ...