someone has suggested I use case select statments to achieve my aim of
bringing up a message when one or more conditions are met when a user arrives
at a clients record.  Some clients are high risk (in terms of personal
safety) and I have managed to get a message to pop up for ...

I have a box on a form that I am trying to validate the length of based
on a field in another form.  I have tried using vb code but I get a
type match error or can not find the form if using the logic below.  I
do not think that I have the right process in the code as I am new to

i have a main form with several sub forms located in it, built in access 2003
on my main form is a cmd button which makes sub form 1 visible and hides all
the other sub forms. sub form 1 is connected to a table.
on sub form 1 is a cmd button for inseting a new record. all works ...

What is the best way to fit more data per page on an access report? I
have tried to resize it, and there's more than enough room on the page
as the data gets smaller and smaller, yet the same mount of rows show.
Is there another way to do this aside from the typical manual resizing

I have a form based in T_Ocorr. In this form there are a cboOcorr.
When I click in cboOcorr row, open another form, based in query with a
condition to show us only records with condition choosed in that combo.
I would like to refresh (or requery) data in second form when we choose

I have a form and a subform that I want to be able to open in 3 modes: review
existing data without editing, enter new data, edit existing data.  I can use
openform from a Switchboard and this works well for the “enter new data” and
“edit existing data modes”.

In existing database that was working now some of the built in function
stoped working and i get an undefined function error.
in a new test database they work.
the functions not working are;

Dont know exactly how to explain.
I have a field name cost, currency 4 digits afler dot.
The second field is setup to Round cost 2 digits after dot.
The problem is

In my form, I want to be able to have the date automatically entered for a
record, after a change or modification is made to an existing record.

I have an event on my main form that when you press enter it moves the cursor
to the first record on the subform. However I want it to place the cursor on
the add new record portion of the subform if there is data already found.
I hope I am saying this correct.

I have a groupbox with 4 radio buttons. I've set the default value of the
groupbox to zero. None of the radio buttons are enabled however the groupbox
still holds a value of 1. Any ideas on this wonderful Friday?
Thank you

I would like to have each new record start with the first day of the week
(vbSunday) e.g. first record date would be 03-Sep-06 next record date
10-Sep-06 etc. Each time I start a new record I would like the Date to appear
in the Date field.  This is for scheduling purposes.  Each ...

I need to ask the user in a customised menu something like: 'Settings >
Documents folder location', where the user would define a [path] to a folder.
Then I would use that path in the following code:
Private Sub ID_Ordem_DblClick(Cancel As Integer)

Hi!  
I know similar questions have been asked before but I'm obviously not
proficient enough in Access to make teh answers work for me.
First my database structure.  (I think it's a bit messy, but it's the only I

I have a combo box on a form in which i enter information that occasionally
repeats. A query i have lists the information have entered previously. When
i enter the first letter for a new entry the combo box automatically
displays the first entry in the list with that particular ...