1. I would like to have a form with a dropdown box listing all the tables in
my database.
2. When a new table is created, it will automatically be added to the list
box.

I have a combo box which is to display records not in another table.
tblEDLog has 180,000 records and will continue to grow
tblProcesses tracks processes on each record in tblEDLog
I'd like the combo box to display records from tblEDLog that aren't in

Afternoon,
Apologies if this topic has been covered but i struggled to find it if
it has. I'm a bit of a novice in Access so i was hoping someone could
help me.

Hello. Can anyone help with this problem, please?
I am building a library database and I created the table «tbl_keywords».
This table has only one field named «Keywords» and I inserted some records on
this table such as «Fictional», «Romance» and «Technical», for example.

My terminology is probably wrong but I'm working with a simple form that
lets user enter data about customer invoices (errors etc).
I have 3 tables (customer info, invoice info, invoice error log).
Now, in one field I want to enter customer Id (from "customer table") and

I am working on the data from 4 provinces and 3 districts in each province,
each district I work with 10 communes. I want to make a form with 3 boxes (
province, district, commune) and when enter province A, all district in
province A appered in box district for selection and in ...

I'm having a problem with a text box in a form whose Control Source is a
table field that has a Hyperlink data type.  The Hyperlink addresses are
paths to folders on our network drive.  When you click on one of the
hyperlink records directly in a table or query, they work as ...

I want,  
1. disable any type of navigation (PageUp PageDown, Enter, Tab Button Etc.)
on my Access form
2.when I open the form its open in add mode i.e. all the feilds of form

I created a form based on the Blueprint template.  I want the entire
background of the form to be specific color.
I goto into the Heading Property and set the backcolor - nothing happens...
Same with detail and footer...

I have a subform that lets me edit existing records with no problem. When I
attempt to type the first character in a new record (any field) I get the
message "the object doesn't contain the automation object 'Project.'"  
Project is a table used in the subform.

I am using a template to develop a database - contact management one I
downloaded - but whenever I try and change the fields that are displayed in
the last tabbed page they show up on the first two tabbed pages - all three
tabbed paged existed I simply changed the fields.

This is really silly but I have searched everywhere (starting with my "Form
and report design for Access 2007" book) for an explanation on how I make a
form with:
Field A (text box) is INPUT value (customer number), and

I have a form setup and what I would like to do is from my switchboard that
I've created look for a student in the database and open that in form view so
that we can edit the record if needed.
Monique

This is probably going to be pretty elementary stuff, but I don't think I've
done this myself before, so I'm having trouble figuring out how to get
started. What I want to do is to be able to let my users see a form that will
allow them to enter information and click a button ...

I would like to give the user the option of changing the report heading
names, I can do this with the Docmd.openreport, stdocname,
acviewdesign,,,achidden and then grab the current heading and display that
heading and allow the user to change it.  I then do a docmd.close acreport ...