I have a Main form with 2 subs.  One sub has a list of items.  When I click
an item I want the second sub to change its recordsource to relect that items
components.  How do I reference that second subs recordsource?  Both subs are
on top of the main.

I was running Access 2007 just fine and today I start it up and it
has:
You don't have the license required to use this ActiveX Control
You tried to open a form containing an OLE object or an ActiveX

This shold be very easy but I cnat get it to work. I have a CBO with 4
selections. My control source and name is INSURANCE CONSULTANT, My Default is
blank and I want to set it to the 3rd selection in the CBO which is "Pending"
and the ID field associated with Pending is 9 in my ...

I've developed C++ applications where I can change the Caption of the
SELECTED pull-tab to a bold-font.  The other captions are regular font.  Goal
was to HAVE the active pull-tab [tab control] stand out.
Is there a way to do this using latest version of Access, 2007.

I have a subform witin a subform.
In that subform are two comboboxes.
I would like to know how to get the list in combobox 2 to be dependent
on combobox 1.

I have created a form that enters incomes and expenditure for events.
I have added fields that now calculate the totals and and final profit and
loss.
Access doesn't automatically add the calculated data in the field to the

I'm calling a form from a form and passing the value of Route to limit the
inputs to the next form which is bound to a table with the key RouteX:
MsgBox (Me.Route)
   DoCmd.OpenForm "VansIII", , , "[RouteX]=" & Me.Route

I have an Access 2000 application I am trying to run in 2007.  I even tried
converting it to 2007 but have a problem that will not go away.
One form has a number of tabs.  Each tab has an unbound subform to update
reference data like drop down lists.  When I try to open it in 2007 ...

i have 4 currency fields on my form. field1 acccepts a value and control
passes to field2. in field2 when the left arrow and up arrow are pressed the
vba passes the control to field1 thats ok. now if the down arrow or the right
arrow are pressed then the conrol passes to field3.. ...

I have an Access 2000 split database I am trying to run on Access 2007.  Even
tried converting it to Access 2007 without success.  Everything is fine in
Access 2000 and 2003 but not 2007.
I have an administration form with a number of tabs.  On each tab is an

I am trying to run an Access 2000 database in 2007.  I even tried converting
it but struck the same problem.  I
have a form with a number of tabs.  It is used to configure an application
- things like the content of drop down lists.  The form does not have a data

How do i format a number field on a form  to  the numberof decimals palce
indicated by a second field.
Ie, if the number is 2.0437, and the second field contains the number 5,
then i want to see 2.04370  (5 decimal places), conversely, if the number in

Hi, I am doing a favor for a nonprofit organization and building a db for
them in MS Access 2003.
I am clear on the table relationships:
1st  one-to-many (1:M) Level:  Each [client] has zero or more [questions];

I have a main form and two subforms.  Everything seems to work fine except
for a field that is in the main form and same field in subform.  When I type
in this text field it should show up on my second subform.  It does display
on the first and second records.  But if there are ...

Hi...  I just joined the newsgroup.  I'm helping a friend out with a project
in Access 2007 that I'm having some problems with...  He asked me because he
knows I had experience with databases in the past, though I haven't used
Access since the late 1990s and most of my experience ...