I have a tab control on a form where the pages have buttons. I've changed
the back style of the pages to transparent so that it is the colour of the
detail section of my form but the buttons wont change to the colour of the
page. Anyone any ideas? I can't find a property for the ...

I have the following in the Row Source of my combo box.
SELECT tblStaffCode.* FROM tblStaffCode WHERE (((tblStaffCode.Active)=True));
It works fine and when the checkbox is False the name doesn't appear in the
drop down list which is great, HOWEVER when tblStaffCode.Active is False ...

I have a customers field on a form that has customer names in a combo box
that is coming from a select query.  I would like to be able to enter new
customer names directly into the form and have those names saved in the combo
box, so next time it would be available to select on ...

I try to use the type property of field object for finding data type of each
field in my table.
It seems to be fine but its return value is not correct e.g. my field in
Table store the data type as a number(Double) but fld.type return value as

I have a table whose data I would like to sort based on the sorting of
another table.
In one table I have a column of IDs.  There is also a column of dates
used to sort the data by the date on which it was recorded.

Hi there lads n lasses,
I would like to display all details from one contractor on a form once i
have selected that particular contractors name from a combo box.
So...

I have converted from 97 to 2000. The VBA compiles and everything run okay
EXCEPT
I have a form with subforms. On occasion (this does not happen consistently)
when the user close the form, the application shuts down instead of retruning

What causes a form recordset to be not updateable?
I've created a form that is based on 4 tables that worked very well until
recently. The form is not associated with any queries and has two subforms
that collect items and a button to add the sum of the items and update field

I have a main form (frmAdd_Mod) where my client enters details on a customer.
On the next window I show the information entered from the previous window
(all these fields are locked and cannot be edited), along with a sub-form
(sfAdd_Mod_1) where the client can enter additional ...

I have a field called splitorder that if it is NOT checked off I want truck2#
field to not be enabled for tab stop.  If it is checked off I would like it
to be enabled for input.  It works for the first record but it enables it for
ALL of the records even if splitorder is or is ...

I need help to get started.  I have created a form with a combo box to
select a record from a query.  What I would like to do is once record is
selected be able to open another form to show the details from the same
query.  How do I open the 2nd form based on record selected?  ...

I have a form with a single subform on it.  I have the subform's DataEntry
property set to 'Yes'.  However, any time I navigate to another record on the
main form, it resets the subform's DataEntry property to No, showing all
previous records.

Main Form has a control box that gets a running total from the subform but
if you navigate to a unit in the Main Form that contains no data the
Subform, the control box reads #Error, I have tried to make the default
value 0 in both boxes but still get the error.

I am pretty sure that this is something that can be done.  I can almost
remember doing this a few years ago, but its been that long since I've
done access programming.
Here is what I am looking to do:

How do I print the current form record in report form with the touch of one
button? I have it currently set to request a parameter, but that is not the
way my boss wants it to be done.  I can't seem to find a macro that will work
for me because I cannot find another way to ...