Is there a tool in Access that creates a report showing the record
source for my reports and forms? Or is there a way to generate a
report that shows if a query is being used in a report or form?
Thanks in advance for your advice.

When I'm placing a command button over an image control and set the
Trasparent property to "Yes", I can e.g. click the image (button) and let
the click_event do it's work. Why doesn't this work with a DBPix control? It
looks like it is impossible to place the Command Button on ...

I have a switchboard with buttons to open other forms.  Here is an example of
On Click code...
   DoCmd.OpenForm ("frmCustomers")
   Forms.Item("frmSwitchB").Visible = False

Hi: Can any one please tell me how to i change 00032 value in the
string without disturbing the original size of the string?
the second curly bracket upto the starting character "O"is always same
in the string

I am trying to set up tables, and forms for easy use for Maintenance dept.
for the cleaning of areas of the factory. There is a set required schedule
for each location in the plant. some areas are daily some weekly, some twice
a week, etc. When they click on the location( on the ...

I'm sure this question has been asked before; but I couldn't find any recent
posts.
I have a tabbed form and I want to refer to a value contained within another
field that resides on another tab; the current frm that is doing the

      How can I get my database to organize my contacts into alphabetical
order using a field I have named "company name" ?

Use TabControl:
1) Remove all pages except 0.
2) TabControl.Style = 2 (None or Nothing)
Need many containers in one form but don't like A97...A2002 TabControl look?

      How can I rename a file I have in table view that is linked to a file
that I have in form view so that they are the same ......My current form view
filename is "courier contacts" and the file that is linked to it in table
view is called "test".... but when I try to rename ...

we have created an access database with names address etc; the input screen
works ok for these fields BUT we want to be able to input the required data
then have extra buttons that will allow the printing of a personalized letter
for the data just input/onscreen and save it at ...

      How can I change the colour of the text in all of my labels from a
form, without doing each label individually ?

I'm not sure this is the right group to ask this question...
I would like to build a form acting like a resource usage sheet. Let's
say we have n different items, and I'd like to display the hourly
utilisation for a few items, for 7 days in a form.

Hi all, i have a combo box on a form that needs to have a name entered from
the drop down list that is already there. Currently i can simply tab through
this field without entering a value. The form has several fields that are
filled in and then a close form button is pressed ...

I use a dialog form to bring up a report and I'd like to close the form
automatically once the report is brought up.
The below code doesn't work. What's the solution?
TIA

I'm testing Office 2007. I want to turn on the mouse scroll wheel in forms so
it will scroll the records, NOT the page.