Hi team,
Have scoured all of the posts and tried several different things for days
but just can't seem to nut this one out.
I have a form (FrmSeedBankStockAvailable) in datasheet view that lists seed

I need to (somehow) get data from a table and manipulate it into monthly and
quarterly reports.  I would like to choose the year from a form.  I can
create the report as a cross tab query, but I can't get it to hook to the
form.  I've tried creating the query first and then a ...

I want to create  a receipt form that will contain 2 tables.  One table has
609 records and the other table has no records.  How do I combine the two
tables to enter data and use a receipt number for each record that will
contain 5 digits.  I will be very grateful for anyone who ...

I have a subform with 2 combo boxes.  The selection of one combo boxes limits
the selections the user can choose from in the next combo box.  This is done
using an after update on the first combo box.  The problem that I am having
is refreshing the 2nd combo box with based on the ...

I have a form that has subform containing 3 fields. One field is a The
subform is in datasheet view showing jobs that are incomplete which may
consist of a few rows.
I need to be able to double click an incomplete record in the part number

I've set a filter to show me records in case a field is true but also asks
the user for a value. When i open that form i have to press the button "aply
filter" or else it doesn't filter my records or ask me that value.
It's a form that shows value from a table and the user simply ...

I have a database field containing the value of 2330.  I need to display
this as 23.30.  The field is display only, I do not want to store this as a
decimal in the database.  
I have tried the following:

How do I change the order of tabbed subforms within main form? For example,
if I have 3 tabbed subforms (say, product, customer, and supplier) which run
in that order from left to right but REALLY want the order to be customer,
then supplier, then product?

is there a way to force a password file to be lower case on input so the
expression is forced lower case and masked?

Does the SHGetFileInfo API call work in Access 2003?
I have copied and tested various bits of code invoking this, but the hIcon
and index parts of SHFILEINFO keep coming back as 0 which seems in turn to
cause an "invalid picture".

How do you set the properties on a calendar control to always come up with
todays date, but still have the ability to change the date

Can I do an iff statment like:
=Iff([Text93]<[Text84] Or [CDV]<[ Text68] Or [CHSI]<[Text70] Or
[Text39]<[Text82] Or [DIGI]<[Text71] Or [Text40]<[Text83] Or
[Text60]<[Text102],Yes,No)

I have very little experience and have been slowly working my way through
setting up a fairly simple database for our office.  I have run into a
problem with DLookup that I just can't seem to figure out.
Here is the deal...

Basically, this is what I'm looking at doing.
I'm creating a database, using a lot of drop down items in the form of combo
boxes for quick selection of items to put into a main database.
The user of the database wants to be able to edit/add/delete items from

I need to get the min of two statements
=IIf([TRPB1]<[TRPB2] Or [CDVA1]<[CDVA2] Or [HSIA1]<[HSIA2] Or
[HSIB1]<[HSIB2] Or [DIGA1]<[DIGA2] Or [DIGB1]<[DIGB2] Or
[RPUA1]<[RPUA2],0.05,1)