I have two fields:
Material
LoadAt
I want the LoadAt field to print if Material = "Haul Only".  If there is any

I have a form whose record source is a query used simply to retrieve data
from 2 related tables.  Table 1 is the main data table.  Table 2 is more of a
reference table for an item on Table 1.  Table 1 has a code that represents
state and county, Table 2 is the translation for ...

I'm looking for a little help here. I've got one table and a form that
automatically enters information into the table as I enter info on the form.
There is one section of the form where a ranking system is assigned to a
University such as:

Hi there im finding truth tables a little ahrd to understand, i
manged
to crack them,but now am having issues with query statements.
I ahve an exam at the end of the month and this has a chance of

I have a form that I am trying to change the background color for the
controls on that form if the name of the control (text or combo boxes) exist
in a query called "qryauditFieldNames" I am getting an error message on the
dlookup statment. It seems that I have the --- ("" & txt ...

I have a select query with a parameter that I'm using as my data source for a
form.  The function of the form is to search a data source.  As expected,
when I open the form, I get a message box with a parameter request.   I would
like to do two things:

I have a continuous form that is a subform who's record source is a query
based on 3 Oracle linked tables.
I have the record set type as Dynaset inconsistant updates. It will not
allow me to insert or

I may have posted this question earlier in the wrong place under the macro
discussions, so forgive me for trying again since I've not seen any responses:
This should be fairly simple, but never for me. All I want to do is have my
MsgBox macro to pop up and say "No data for this ...

I am looking for a way to supress leading zero.
I found ltrim or rtrim to supress leading and trailing spaces.
Are there similar functions to supress leading zeros?
Your information is great appreciated,

I am using Access 2003. I would like to use vba code so that when a user
clicks in an empty text box, a bullet (Alt-0149) is inserted first and then
the user can enter text. When the user then hits the enter key, another
bullet is inserted and they can type more text. If there is ...

is there a snippet such as
    me.textbox.backcolor = transparent
?
cheers

I have a Combobox on a MainForm, and i want to filter the records on a
subform based on the selection from the combobox.
How would i do this using VBA?
Thanks

I am having a problem coding events on a form which has one combo box that
references a different query with a parameter.  Everything works fine except
that When the form opens, a dialog box from the parameter query pops up.  I
would like to be able to use information contained ...

I have a datasheet which contains a combobox. The combobox is filled with
values via a function. Is there any way I get can get the list to refill for
each row in the datasheet? The function only seems to refill the list each
time the form is opened even if I put the code in the ...

Two questions -
1.  How do I change the alignment for a column in a listbox?  Right now
everything is left justified and I would like some columns to reflect
different justifications (right, center, etc.).