I just tried to open an old mdb. I get the first form up but can't bypass
this with F11. At some time in the past I must have turned off special keys
so F11 for the Database window doesn't work. There is a custom menu and no
toolbar.

I want to link several worksheets of a workbook as linked tables.
This is the vba-code I use, which don't work
Any suggestions are welcome
sub LinkExcel(strWorkBook)

I have a table titled ''Addresses' containing a list of addresses with
fields of 'Addressee', 'Address Line 1' and 'Address Line 2'.
I have a form to enter data into another table and want to use a combo
box where I can select the 'Addressee' from the drop down list and have

I am using an Access 2003 project as a front-end to a SQL Server 2000
database.
When I am calling a report, I use this line in the VBA code:
DoCmd.OpenReport "rptBilling_Details_Specific", acViewPreview, , ,

I have an Access 2000 MDB file with a SQL 7 back end. I have a main table
with 50,000 records; and I have a selections table with 50,000 records for
each machine that uses the database (about 25-50). This allows each user to
have their own set of selections.

I'm making a database to record training that employees have recieved.
For each training excercise, they recieve a mark between 1 and 3.
Initially, when there weren't so many training elements, I had put the
employee first name, last name, section, First Aid, Forklift

I have a form (frmDogs) that is invisible while a subsequent form
(frmPeople) is visible.  The visible form sets a value for a combobox
(cboOwner) in the hidden form, makes the invisible form visible and then
closes.  When the newly visible form (frmDogs) appears the combo box

I am a relatively new user.  My position is to maintain an Access DB
that is running in a multi user enviornment and split on a network
running Front(2K and 97) and BE(97).  The DB has been used for a number
of years and has grown tremendously.  I have been asked to normalize a

I have a main form and multiple child form linked to one main form
I am using a tab control with multiple pages, each page of tab control
has one child form
Example

I have a form/subform with the common one-to-many relationship.
The form allows user to display records and move to other records
via the selector, to add,delete, and edit them, with the related
records displayed in the subform going along for the ride.

Hi, I am tyring to write some generic code that will send the source SQL for
a mailmerge to a Word template.  I am trying to use DLookup to insert the
query name that is the record source for the mailmerge with Word.  The code
I am working with is as follows.

I would like to set the value of the Y axes on my graph at runtime. I
created the graph my opening a form and placing an unbound object frame
on it then placed the MS Graph control into this.  Next I copied /
pasted this object into a report.  How can I do this?   I can't fiqure

I have a report with an OLE bound frame.
A bitmap has been pasted into the bound field.
The bitmap displays and prints differently on different computers. In
particular, the alignment is different. Both computers are using the same

I'm trying to use IIF and having hasseles.
The statement below is a generic example of what I am trying to achieve
but of course it will not work!
IIf([CountofSurname]>=13,"1") Or IIf([CountofSurname] Between 1 And

I get error 3315 when attempting to enter ZLS into
a text-type table field whose allow zls property is set
to false. The error says "Field MyTable.MyField can't
be a zero-length string"