I read through some of the messages here and got lost. I current have a form
that pulls up data from a table based on a select query. I would like to add
on option group so the user can choose to view records with the status of
"open" or "closed" based on the currently selected ...

I have a button on a form that is used to preview a particular report.
I would like to give the user the ability to select one of three reports,
after clicking the button.
I have in mind something like:

On an Access form, how do I verify an user input image file with pathname is
a valid JPG file type?
For example, users may incorrectly labelled a non JPG file with JPG
extension. Any ideas?

I have got a textbox on a continious form that sums [hour1].
The only problem is that it takes a couple of seconds to sum that field.
Is there a way to sum in VB?
I need to do so validation with the sum, but the way it sets now it looks at

I want to show data objects as Y-axis (rows) and dates alng x-axis (fields)
Date    01.01.05    02.01.05    03.01.05 ...
Obj1    Free            Free            Occupied
Obj2    Free            Occupied    Free

I have a form that accepts
BegDate1  BegHour1  EndDate1  EndHour1
BegDate2  BegHour2  EndDate2  EndHour2
BegDate3  BegHour3  EndDate3  EndHour3

(ACC2000) I have this form where the detail page is
something like 20 inches high in total. I have data
entry "sectioned off" into 4 sections, section 1 from 0-5
inches, section 2 from 5-10 inches, etc.

I have a form with 10 report buttons once one of these buttons are clicked
the relevant criteria and the print button appear on the form, once the
criteria is entered and the print button is clicked the relevant report is
opened.

Is there a way to (view only) 2 different table in one query and if so what
are the stipulations?

i have some vba that records changes to the values of controls on a form
(before update event). this code is on both main and (correlated) sub-forms.
when i use change a pk (e.g. "Patient Number") on a main form the change's
recorded in the designated memo length field, but i ...

I need to be able to add a new field to an existing table, but can't figure
out how to do it w/ VBA.
Existing table is named tblWhatsNew.
A new boolean Yes/No field needs to be added to tblWhatsNew whenever a new

I am trying to set the date control on a form to the current date.  The code
I am using is:
Me![OrderDate] = Date
but date always returns Null.  It works fine if I try using Now instead

I have been testing the log with no problems. However, it is time to do
something with the data in the log table. But with no examples of how to
view the audit data on the website, I thought it would be a good idea to ask
on the newsgroup if any one had extracted the data from ...

I need to create a sequential numbers like this: 1, 1, 1, 2, 2, 2,
..............1, 1, 1, 2, 2, 2, 3.  Can someone advise me how to accomplish
it.
Thanks,

I have a form, whose data source is a a table-column. If a specific displayed
record has a zero (0) for a value, I want to show a <blank> instead of the
zero. I've been beating on this for awhile now, and have been unable to do it
successfully. If I create an unbound field in the ...