Selecting a product from a combo box assigns a filename and path as a string
value to the .picture attribute of an image frame.
How would I go about programatically getting the dimensions of the image
file and re-sizing the frame to fit the image?

I'm screwing up some basic programming, and need some help. I have a
control on a report. "[RefPIN]", which is an eight digit number.
Because I must put these eight digits into particular spaces on a
preprinted form, I am trying to loop through the digits, and place the

I'm using an append query to add data to a tables primary key field.
I would like to give the user a different message than the regular Yes/
NO/Help message.  I'm looking to have a message telling the user that
the record already exists and prompt to create a new one.

Hi Groupies:
I am tracking inventory and need to keep a record of where a piece of
equipment has been and where it is now.
I have a query, qryInventoryTracking, that allows me to select a piece of

Hey guys,
Posted this to the reports news group yesterday, and got no response, so
thought I would try here.
I have a couple of custom menus, one on a form that hides the form and opens

I created a macro that looks like this
SetWarning = No
Hourglass  = Yes
OpenQuery

I have a table named tblMinutes, it has 2 field in it, "Number-Books",
TypeMeeting"  The field "TypeMeeting" has 4 or 5 types of Meetings in it and
I'm trying to sum the number of books for the type meeting named "Council".  
I'm using this code - CBooks:

Hello,
I have made a form which has the ability to make an automated word document.
I want to be able to force quit the writing to the word document if the user
chooses since it takes a minute or two to write to the larger documents. The

I have some code and what i want it to do is not allow the procedure to
proceed if the value is -1, otherwise it can proceed.
I have attached what i want to do, can someone point me what i need to do
Private Sub JobnumbersID_Exit(Cancel As Integer)

I inherited an application that has lots of duplicate code in it.  
The code below is for two separate buttons on a form, each one opens a
different form.  Is there a way to have one module that could pass in the
form?  Do you pass in the form as a string, an object or as  a form? ...

My question runs fine to check if there are any rows.  But it does check if
it's a new record and no rows exist yet.  Here's my code:
Dim intX As Integer
Dim rs As DAO.Recordset

I'm trying to calculate total income and expenses from 5 fields each
on a form and then eventually calculate an income - expenses total.
I have the fields txtIncome1, txtIncome2, txtIncome3, txtIncome4,
txtIncome5 and txtExpense1,  txtExpense2, txtExpense3, txtExpense4,

How do I handle the condition where a child record does not exist for
a parent in a Form/ Linked Sub Form situation? The sub form disappears.

Can someone help me out with the syntax for how to do this. I've never tried
this before and I just can't seem to crack it.
I click a button which takes a selected item from one combo box and puts it
in another combo box.

In our little application we are using the generic record nav buttons.
What event fires when the user selects the "star" to add a new record?
The goal is to lock down certain fields (through the front end only)
after a record is appended.