I have code that executes an image re-formatting program from within Access
(REASON below).
SITUATION:
I run it "successfully" using the Shell command within a AccessVB loop

Using Access 2002, I wish to produce a report. A user has a form with a
listbox, the listbox show items from a select query. The user then
multi-selects items in the listbox then prints these items in a report like
schedule.

I have a report I want to use to print only the current record before me on
screen.  How do I write a query to select just the on-screen (current) record
to send to the report so I can click a button that says "print this record?"

I have a continous form with some fields, like: ProductKeyInReceipt,
Diameter etc.
I want the Diameter field to not be locked only if the product that the user
selects from the ProductKeyInReceipt should have a diameter (otherwise I

Access 97
I have a number field on a form for each week day - Mon through Fri
Numbers are whole numbers.
At times any day could have zero qty.

Here's what I'd like to do:
I want a popup message box with text saying "To insert a NEW RECORD, click
this", and then a small screen-cap of the ">*" button. I want this msgbox to
stay up for 5 seconds, OR until the user clicks OK.

Hi all, I'm designing a database for my coin collection.  I've begun to use a
switchboard form as the main screen.  The top button opens another swithboard
form.  In this one I want to have six seperate btns which would open up a
sbfrm filtering out countries from each continent. ...

I have a form that I would like to use to open a report in the preview mode.
I think that I'm close but I keep getting an error msg On the
DoCmd.OpenReport Line. Here is the code that I'm using.
Private Sub cmd_btn_Print_Record_Click()

Thanks for taking the time to read my question.
I would like to select an item in my listbox with code.
so far I have:
Me.CategoryList.Column(1, x) but you can't add anything after that.

I want to be able to from a form page enter in a value which after being
stored I can get a running 15 consecutive day average plus a running four day
average based on a date (i.e. the past four mondays average and the past four
tuesdays average and so on for the entire week.).  ...

Good afternoon,
I'm working on a small application that contains a combo box to select
integers ranging from 1 - 8.  I have txtboxes for each of these
options.  Should the user select 3, then 3 txtboxes will be visible,

Hi
I want a border to appear around a shape when the cursor moves over it and i
want no border of the shape when cursor moves out of that area.
i.e.

I have a form that has 2 combo boxes on it.  I want the list items for
combox2 to dynamic change based on what is selected from combox1.  Combox1
is based on Table/Query of a table called "classes" and combox2 is based on
a Table/Query of a table called "instructors".

I am trying to do a few things and feel really stupid because they seem easy.
I think I just don't have enough knowledge on coding.
Anyway, I am trying to have a field automatically populate the time and date
of the modification to the notes field. I also want the notes field to

Hi, I'm experiencing some problems with a unbound form with ~150 controls
(Access 2003 generates "Can't open any more tables" error after a few
minutes of use)
10 of the combobox controls use the same data source so I've implemented the