REQ: any utilities for designing front-ends for databases

I am searching for a way to create multiple records in Access 2000 from
a worksheet created in Excel. I'm pretty much self-taught with Visual
Basic so forgive me if this poorly described. Basically what happens
is, from Access, while in Form1, I click a button that opens Excel and

Is it possible to somehow jump to the approximate middle record on a form
via code?
Thanks
Regards

HI All, I'm a nubie to access but have been asked to put together a
database none the less!
I have had to create a report that shows: Company, Area, employees
skill set, and Employee Name. I have done this OK, but am having a

In my current database, I have a single table which contains order
information such as product, unit price and payment.  The payment for
each product is entered in and subtotals and totals are calculated
fields on reports.  With this setup our customers pay for each product

I have a form that tracks problem issues. On that form I would like to
have 2 subforms with 1-to-many notes associated with each problem. On
the first subform I'd like to show a datasheet view of the associated
notes, with datecreated and notesubject. On the 2nd subform I'd like to

I need to copy the tables orders and orderdetails containng only the
last order.I am copying them to another database using the formula
DoCmd.CopyObject db.Name, "orders", acTable, "orders"
DoCmd.CopyObject db.Name, "orderdetails", acTable, "orderdetails"

I skimmed the MS spiel at http://msdn.microsoft.com/sql/express, and noted the
part about "all inside the Visual Studio 2005 environment".
Do the older SQL server tools for security and stored procedure editing work
too?

How do i subtract the first value from the second value without
multiple queries? (query example below)
SELECT Sum(tbl_Area_PropLend.Amount) AS Default_FinCharge
FROM tbl_Area_PropLend

I have an Append Query that worked fine in Access97 but now fails to
work in Access 2000. The error that occurs is that it puts null values
in a field due to a "Type Conversion Failure".
The field in question is set up as a Long Integer in the target table.

I have data on air pollution coming from sources across the country,
and control options for reducing pollution from each source.  The
example below shows data for:
- 2 sources (plant_ID "001" and "008")

i have a films table and form. i have a txt field in teh form called
txtSearch , and i;ve created a query with all the film table fields in it.
how can i get the query to load up, wth the required film infromation in
it??

I have a list box that is generated on a form by way of a
Parameter Query. Problem is whenever I try to refer to the list
box, i.e., to update the underlying table, I am getting a "null"
value from any row or field I refer to. Have tried using "after

Anyone know where the record navigation icons are stored?
.dll (I can extract using Icon Extractor)
.gif in some folder?
Using Office 11

aut_id    txt_head mem_body yon_approved
1                                               y
2                                               n
3                                               y