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.).

Is there a method or property that can be manipulated with VBA to switch a
form from Single form view to Continuous forms view (and vice versa) without
first switching to design veiw?

i am looking for the number of records that satisfy 2 criteria:
(both Manufacturer and CatalogNumber are text fields)
this line of code works:
   x = DCount("[Manufacturer]", "FixtureCataloges", "[CatalogNumber]= '" &

I am attempting to lock a transaction record after i key in the first value
in this case the length of a wire recieved into the inventory.  The following
are the details of my database.
I have a table Rawmaterial_Items and Rawmaterial_Tran

Help:
I have a replicated databse that is used in both 2003 and 2007. Most
development is done in 2003. I have stability problems with
replicated/synchronised databases when running in 2007. The database normally

Using Access XP.
I am creating a student survey. A form, [TeacherNSubjects],  shows all the
student's teachers. They click on a teacher's name and the form,
[TeacherSurvey], is displayed, a [Return] button takes the student back to

I have a form that pulls the values of text boxes into a table - pretty
standard.  My trouble is that it won't pull the zero values into the table.  
I have the text boxes set to display a "0" value when nothing is entered in,
but those aren't making it to the table.  Null values ...

Currently I have a form that takes a user input and runs a parameter query
returning only one record at a time. When it returns the record I would like
it to display the results on the search form and not in a pop up window. What
would be the best way to go about it? I tried to ...

I'd like to keep the color of the detail section to
"-2147483633" (grey) until a field is updated in the header section,
throwing the focus in the Form Open action to the particular header
section's field.  After update of this field, the detail section color

Access97
I am using the following to transfer the contents of a table into an
existing spreadsheet (as a new worksheet).
This has worked for me previously.

Using the On Current event of a datasheet I can lock controls within a
datasheet based on values of controls within the row however I've encountered
two problems: (a) each time I click on a row the Got Focus event fires and I
get an error that I can't change a control that has ...