I have a large grahic image (.jpg) that I want to turn into an icon file to
be used in my treeview control. What is the best way to do that ??

I designed the form, but when I go to open it, the bottom of it will not
display.  What do I do to see the complete form as it is in the Design
Form????
Thanks,

After I copy text from a word document onto a memo field of a form in Access,
then when I move to a different record it looks like the same text that I
just pasted onto the other record is also showing on the new record.  So I
would have to close the form and reopen it so it ...

I am not a computer expert, so bare with me....
I want to open a form, double click in a list box, and have the selection I
clicked on set the parameter value for a query.  Little beyond my abilities,
but probably simple if one of you can help.  I am using Access 2002.

I'm having a problem copying and pasting records in a subform.  
Here's the context -- I have a Purchase Order form with a subform
containing line items. The PurchaseOrder table's primary key is PO.
The LineItem table's primary key is PO+LineNo.

I have a field that contains a number, whenever I add another record I
want the number to go to 1A then 1B, 1C...etc.  Them 1AA, 1AB etc,
Anyone know how to do this?
Thanks

1) I'm looking for code that I can stick behind a button on a form to create
a report and export it into Excel or Word (need code for each).
Then I'm trying to have the appropriate application (Excel or Word) open
with the new spreadsheet/document in it.

Access 2003
1) I have a form with the fields IYD, RevIYD, NeedDt and a chkbox named
"NonSupport".
I need for the check box to autofill to true when both the IYD and RevDt

I have a command button on the bottom of a form and I need to be able to
modify the code in it to reference a combo in the forms subform. The trouble
is, the main form is itself a subform on a Tab Control and I can't get it to
work. Here's the detail - sorry it's a bit ...

I am trying to run an action query called "qryDeleteBlankPayableTo" using
VBA. I see I need to do it with the DoCmd.RunSQL.
My problem is that I know very little (almost none) SQL.
So I could use help on the proper format and text to do this.

I have an append query that won't work because it is causing referential
integrity problems.  I have since found out that the reason it is causing
those problems is because Access is adding a space in front of the values.
This is the code:

I have a main form and I have a data element, children ages, which can have
more than one value.  Is a subform the only method of recording multiple
values for age? If so, is there a way to bring up that subform based on
another element which contains the number of children?

I would like to create an input mask for ssn's, but also have it hidden.  I
know how to do these separately, but is their a way to have it look like this
***-**-****
Thank You

Here is my dilemma, I need a user to be allowed to edit a record, but they
will only be able to edit said record one time.
They will be doing this in a continous form based off a query (which is
based off of 3 tables).  There will be between 5 and 20 records that will be

I have a treeview control and am using an associated image control to assign
icons to the parent and child nodes as I add them...  In the image control,
you can give each picture a "name". What is the syntax to assign this actual
image "name" to the treeview node instead of the ...