Is there away to change the control sources of all the items on a form
use the same querie rather than having to change each of them
individually?
Colin

I display a form with several large size text boxes on them.  I prepopulate
the objects with data from my database.  As you would expect only so much of
the text can be visible.  This is fine.  However, my users are sometimes
unaware that the scrollbar exists until they actual ...

I have a subform that lists contacts, where the primary key field is
ContactID.  The user adds new contacts to the subform by making a selection
in the ContactID combo box.
The compound primary key in the table underlying the subform recordset will

Good morning,
I have a database front end used by mulitple users that contains a
continuous form. On this form is a drop down box and when a user selects an
option out of this drop down box, some times they get a "The data has been

I have a form on it that has 2 textboxes.  Each txtbox is for the user to put
in notes or a listing of items, etc.  There may be times when they are in
txtbox 1 and want to see a corresponding item in txtbox 2.  The text boxes do
not hold there position when on the other.

I have a subform that has two fields:  ActionItems and Owner.
I want to have a button that when you click it it shows all the ActionItems
and Owner from the previous week.
On the Main form there is a start date and end date. For this week it was

I have an Access 2003 database with three main tables: Managers (primary key
= managersID), Projects (primary key = projectsID), and Tasks (primary key =
tasksID). There is a one-to-many relationship between Managers and Projects,
and between Projects and Tasks.

Hi Everyone,
I am new to access. I am wondering if Access can be linked to Excel so that
the tables from Access can be updated constantly with a table in Excel? If
that is possible can you please show me? If not, is there a better way?

Here's my code so far.  Seems simple enough.  But I cannot figure out why,
even though I'm defining lngoper up front, the code is asking me for it in
another input box WITHOUT any text other than the name of the variable.
Private Sub DoStuff_Click()

Access 2007
I have 2 cascading comboboxes on a continuous sub form.
If I change Combobox1 on record 1
and click on combox2 on a different record( the form is continuous)

I have a form that has a combobox that allows the user to select an existing
customer. The afterupdate code sets the rowsource for a second combobox,
makes it visible & sets the focus to said 2nd combobox, BUT, without an error
the focus disappears from any control on the form ...

Building form based on tables and queries to record cruise travel reservation
information. Need to have list box that displays based on selection in
previous field selection; i.e. if Carnival Cruise Lines is selected in
previous box then the list of carnival ships would appear for ...

I want to create a hidden form that loads when any user starts up my
database.
Done!
On the form I want to run code that checks to see if a particular user

Hi, is there a way to change the color of the text in a message box.  For
Instance, I have a message that states: User must fill in where the field is
Yellow.  How can I make the word "Yellow" actually yellow in the message box?
Thanks.

I would like to have a form to give user multi choice records.
I used to add a check box on the continues form and read the check box
on the form to do some action after user click OK.
i just wonder is it possible to be done using datasheet form?