I'm having a problem with a combo box.  I have it pulling values from a
table, but my problem is that it pulls from a table for the customer names.  
It works but there are multiple entries with the same names.  How do I stop
the combo box from showing duplicate entries?

I have two combo boxes. On the main form (Form 1) is a Category combo box.
On the subform (Form 2) is a Product combo box. Using a where query I have
set it up so the Product 2 combo box is based on the category combo box. This
works fine for the first choice. I.e. the first ...

i wish to deposit certain values in certain controls, basically this is a
form where a refund value is to be split up into its indivudal numbers (which
ive already got) and converted to english (which ive already done) and then
deposited into certain boxes, so that units are ...

I have a table with the following fields:
Site, Week, Product, Weight.
I am trying to get a Form to allow easy data/editing by product.
I have a site which produces a number of products each week. I am getting

Access 97 question
I have a continuous subform.  Multiple records with multiple fields for each
record all nicely retrieved from a query.  I want to set the forecolor
property for each record to different colors depending upon the value in one

Could someone please tell me should this code work?
If DE.Value = No Then
KeyDE.Enabled = False And DEAddress.Enabled = False And DETel.Enabled =
False And DEEmail.Enabled = False And DEP_Subform.Enabled = False And

I want to display a label on my main form only when certain fields on my
subform are not null. I know my code is incorrect, but I need help making it
right. Thanks in advance.
Sub ShowIssueComplete()

I have a need to click on a hyperlink in a powerpoint to open a simple
employee names form in access.  I have it set up to work now, but it opens
all of Access and then the form (through startup) in the new record format.  
What I would really like is for just the form to open ...

Hi!
I have a multiple tables with one to many relationships.  I would like to
have a main form with multiple subform in tab Control (3 tabs, 3 subforms).
Main form, tbl1

I'm trying to export to an XLS but it doesn't seem to be working, any
help appreciated.
Thanks
DS

I'm working with a continuous form in Access 2002.  The form's recordsource
has date/time fields named StartTime and EndTime, which store complete
date/time information. I would like to format my textboxes to show date only
(m/d/yyyy) if the date is before today and time only (h ...

Is there a way to make a button open up a browser and go to a website
specified in code?

Is it possible to make a Listbox background transparent like with Combo
boxes?
I have a really nice background on my form that I want to be visible so that
only text in the Listbox is visible. My Listbox is so big it covers much of

I am trying to move a file from one drive to another and need to make the
moved file a read only version. How do I do this?
This is where I am at the moment:
Name ("T:\Users\" & CurrentUser() & "\" & Me.lstImportFiles) As (strnewroot

The procedure below allows me to bypass "The Data has changed" error I get.
It seems silly, but it works, and all my data is correct every.  My
procedure
is updating data in a "SubForm2".