I'm trying to export data from Access into an existing Excel file with a push
of a button.  These are the steps that I need to perform and would like to do
it all from Access, meaning all macors or coding.  I'm using MS Office 2003.
-Run & export access query to a specific folder ...

I'm looking for some suggestions on how I can get my query to populate data
by day.  
My data is as such;
Weekstart      mon    tue    wed    thu    fri     sat    sun

I originally used a button on a from created via the button wizard to run my
report which was based on a query.
Since I wanted to add some validation I removed the button and added my own
code (as below):-

It must be late at night as I cant seem to do the most simplest of
activities, a form is used to enter new records.
It displays details and at the bottom is summary information, a text box has
a control source of the following :-

I have an Access DB with a text field that can contain one of 4 words:
Daily, Periodic, Seasonal, Other. I want to sort on this field so the
query result is in the same order: Daily, Periodic, Seasonal, Other
(not alphabetical). Is there a way to make this happen without

Have several forms where I have removed the navigation bar and use four
buttons to navigate and add records :-
Next Record
Previous Record

Got a TreeView.
Top node is the name of a company concatonated with some numbers about
the company.
Users want company name on the left and the numbers on the right.

I have a subform based on a query that select data using aggregiate
functions i.e. min, max, average and standard deviation.
Some of these will return results with many decimal places.
The textboxes on the form have zero decimal places specified but it doesnt

Okay, I have looked at the Inventory Templates for Access and also for Excel
and haven't found anything that quite meets my needs -- and not smart enough
to mess with what templates are there to make them work the way I want.
So this is what I am looking to do and maybe someone can ...

I have TWO subforms on a main form based on saved query.
Both the same size and both have scroll bars as there are too many fields to
be displayed at one.
One form displayed the column heads whilst the other appears to determine

I have a piece of software that was written in Access 97.  It allowed the user to enter a phone number via a form and was stored in a table with an input mask.
Fast forward to version 2003.  The phone numbers are displayed in a report and are formatted correctly, except for the ...

What is the best way of reordering records in a form? This would be across
multiple columns in the table vs a single column on the form that I could hit
the Sort Descending/Ascending button on the main menu.

Current form only allows 22 inched in width. How can I expand/increase this
length?

I'm building a database to track steps of a root cause analysis tool. There
are 7 steps to the process; I'd like to have a specific form for each step
that all feeds one primary table. I'm able to make each separate form, but
I'm not sure how to ensure that each form is updating ...

I am trying to set up my forms with tabs.  I have customer information on the
1st tab and another form with customer follow-up correspondence logged in on
the 2nd tab.  I am trying to link the 2 tabs so that when on the initial
customer information form, i can click on the next ...