I have a form bound to a table. When entries are made to the form, I
want
only values that are multiples of 5 input into the table. Anything
that is
not a multiple of 5 should come up with a warning and not allow the
user
to go any further in the form.

I was trying the following in the Validation rule in the properties of
the text box:

=DLookUp("[PointValue]","[Point]")

but it will not work. It will allow a value of 5, but not of 10 or
15....etc

The point table has values from 5 to 100 in multiples of 5.

Does anyone have any suggestions as to how I can accomplish this?

Hello! I am attempting to code a routine that originates Outlook
appointments from within an Access 2K database. Although I have no problem
coding for the basic appointment parameters, I am having trouble with the
attachments. (NOTE: Also posted in Outlook forum.)

BACKGROUND -- I have built a project management database that contains a
group of forms dedicated to training. Within this group, the user can
designate attendees, resources, and documents that will be used to schedule
subsequent training sessions. Paths to the documents are stored in
tblProcessDocs. Only those docs linked to the primary key of the training
record are available for attachment to the appointment.

When I attempt to attach the documents, however, I receive the following
error: "File name or directory name is not valid." (NOTE: Error number
changes depending upon the file selected, but the description remains
consistent.)

HOW IT WORKS: In the routine (code below), I set the basic parameters for
the appointment, assign recipients, and assign resources. Then I create a
snapshot recordset and determine if the main training...

Environment Info:

- MS Access Sales System (front-end)
- SQL Server Standard (back-end)

Information of the Problem:

** In the Inventory items data:
- when user enters a new item and does not
encounter problems entering it, the subsequent changes to the item
information will not cause any problems

- when user enters a new item and encounters problems during the
entry stage, the subsequent changes to the newly entered data will
cause a "Drop Changes" error

To quick fix the situation of the problem, I had to help the user and make
changes to the item information directly at the back-end.

Does anyone have an idea where to start in fixing the problem?

Thanks!

Another issue today... How do I code this type of thing... Two fields, first
field one makes a text selection from a list; second field, one would fill in
a number (this field defaults to 0). I want to make sure that someone does
not fill in a number >0 in field 2 if they have not made a selection in field
1. There are about 18 of these fields that need to be coded.

I hope this makes sense and appreciate any help someone can give me. Needing
to get this done by this afternoon so hope there's one of you fantastic
knowledgeable people available. Jani

I have a PivotChart (as a form in PivotChart view) that I formatted to have
the series label show in the chart (which is easier for the end-user to
evaluate in a pie chart if they can see the number each piece represents).
The problem is that when a piece of data in the chart goes to zero (or
started at zero) and later a value is assigned to the data, the label will
disappear (or never be assigned). All of the other labels will remain. It is
only when the the piece of the pie didn't exist and now has data to be
represented that this occurs.

Hopefully Microsoft has a fix for this or there is some code that can work
around this. I've search the web and Mircrosoft's site but couldn't fin
anything. Does anyone have any ideas?

Thanks!

I am using the On Exit event for a control on a subform to set focus back to
the next control on the main form. This works fine if the user has pressed
Tab to navigate to the next field. However, if the user uses the mouse to
click to a different field, the On Exit code will be a major annoyance.

How can I capture whether the user has pressed the Tab key to go to the next
field?

I have two subreports that print fine when subreport only is on screen. When
main report is on screen certain fields don't print for print preview or when
report in printed. Any hints to what the problem is?
Thanks,

I have a form to edit a record and my code is causing problems when there are
no changes made to the form. If I select No when there are no changes, it
gives a run-time error 2046; saving with no changes works. If there are
changes to the data it works fine either saving or not saving. Below is my
code. Any help would be very much appreciated. Thank you! Jani

Private Sub Command129_Click()
Dim strMsg As String
strMsg = "Data has changed."
strMsg = strMsg & " Do you wish to save the changes?"
strMsg = strMsg & " Click Yes to Save or No to Discard changes."
If MsgBox(strMsg, vbQuestion + vbYesNo, "Save Record?") = vbYes Then
DoCmd.Close
DoCmd.OpenForm "frm_MainMenu"
Else
DoCmd.RunCommand acCmdUndo
DoCmd.Close
DoCmd.OpenForm "frm_MainMenu"
End If
End Sub

On my form I have a field that is a Combo Box (1,2,3,None) If None is not
picked I want another field (Estimated Total Field Hours) to be required.
Fairly new user.
Thanks in advance!

I have a combo in which to select "DestCountry". There are about 20 of these.
Then there's another control that shows the "Price Band". That's also a combo
with 5 different values to choose from (1-5).

I wanted to code the AfterUpdate event on the DestCountry control, so that
the Price Band would be populated automatically.

As a first attempt, I used this:

If DestCountry = "Australia" Then
PriceBand = 5
End If

It doesn't work. I then tried having an ordinary text box for PriceBand
i.e. not a combo, and it worked fine. Is there something different I need to
do to get it to work on a combo, or is just not possible?
Many thanks
CW