I am using VBA to export a report from Access into Excel, reformatting
it so it looks something like the original report, and leaving the
Excel file open so that the user can email it.
My code goes something like:

I am trying to insert a CHART into a Report but the labels always come up
with East, West, etc.  The data appears to be fine but I don't understand why
the labels do not reflect what I want to see.  The query that this chart is
based on looks fine.  The Query is based on two ...

HOWTO add a carriage return at the end of a text in a text field?
TIA
Mike

Everytime i use a switchboard to open a form it opens the form n single form
view even though I have set the defualt view on the form to datasheet view.
Any solutions?

I need a command button on form1  to open a form2 in datasheet view & add a
new record with data filled in based on data on form1, allowing the user to
either tweak the data in form2 at this point and/or accept the transaction.  
I need all the records to show in form2, which is ...

How do I change the ruler on a form in design view to display inches rather
than cms?
Thanks
Tony

Access 2000.  I have an employee db.  I need a way to perform a search of
the employee id # and a specific date and have that date show up on my form
for editing.  Thanks...Randy

Is there a way to open a Main Menu form without showing the Access window
behind it and make it appear as a standalone application?  I know you can
hide the database on open but I only want the Main Menu form to open and not
dislpay that it is sitting inside the Access window.

im new to Access 2003 so this question might sound simple to some users
In a form i have a text box and the control source is a calculation done
with expression builder. the problem is im having trouble transferring the
calculated value into a feild on a table. Any ideas how???

I have a be/fe application, everything works great but have one issue.  When
one user is in a recordset (same form) that another user pulls up, the
original user's data shows #deleted.  My users have their front ends on their
individual desktops and the backend is on the server.  ...

I have a form that has dropdown boxes as well as regular text boxes. I am
trying to figure out how to make a couple of my text boxes "Not editable."
Under the form properties I can only find this for the entire form.
Any help?

I have successfully used the method at:
http://www.mvps.org/access/api/api0001.htm
to create a browse function for my form.
All I need to do is get the name of the file the user selects into a text

I have a form with customer information.  (Cust ID, Name, Address, Phone)
I have a sub-form that has specific order information, with a few basic
fields (Order ID#, Date, Order $ Amount, CustomerID{hidden/not visible}), and
a "Details" button next to the order line item that takes ...

I have posted an earlier post today, far too complicated by the looks of it,
so I have re-written a simplified version.
I am new to this and I really need some help, I have looked and read lots of
posts, but I still cannot get it!

I am looking for a way to display a pdf on an access form.
I have a directory full of order forms that are numbered and a list of them
in a table.  I need to display the order form that corresponds wiuth the
record that is being viewed.  Any advice on how to do this would be much ...