Using Access Queries in Excel
I have a lot of data in access, and I have built a sample query to get the
data summary that I want.
I also have a chart in Excel that charts the data.
What I would like to do, is allow the user to select a data range, for
example and have the query be changed to select the dates chosen.
How do I do that from Excel? Can someone point me to information on this?
Why not do the charting in Access?
It's much simpler to do all the work in one application.
"Give someone a fish and they eat for a day; teach someone to fish and they
eat f...How can I push Access Data into Excel from Access 2007?
I have written macros in Access and Excel to extract data from multiple
spreadsheets, manipulate the data, then import it into tables in Access 2007
to run reports, etc. The data is replaced on a monthly basis. This part
Now I would like to take this data from Access, run queries and push the
data back into an Excel template with 101 worksheets, the first sheet being
a summary, the rest numbered from 001 to 100.
I would like to control this from Access, even if it means running Excel VBA
code from Access (which I do for the importing).
I tried one example that ...Formatting Combined Cells
Below is what I have in Cells A1 thru A3. I can't seem to get cell A3 to
give me AMKD000415. Instead I keep getting AMKD415. I've tried various
cell formatting with no luck. I would really appreciate any suggestions you
may have. Thanks!
Please keep all correspondence within the Group, so all may benefit!
"Betty Csehi" <Betty_Csehi@Andersonsinc.com> wrote in message
news:uA...VLOOKUP formula displays in cell, will not return data
I had an older version of Excel (97 maybe?) and our office updated to 2007.
Now my vlookup will not return data. The vlookup formula appears in the
cell or I get the NA#. I've formatted my lookup cells and table to General
but still get the same result.
After formatting the cell as General, re-enter it (F2/Enter) - if you're
still seeing the formula, press Ctrl/~ -- you're looking at the formula layer
instead of the value layer.
> I had an older version of Excel (97 maybe?) and our office updated to 2007.
> Now my vloo...Access 2003 in access 2007
I have an application in access 2003, and it inports and exports the data to
excel 2003. Now users are switching to the windows 2007 and office 2007. My
app can be opened in access 2007, but when I start my macros for export, it
reports a problem, something with formats. More and more users are using
office 2007, and my app is becoming unusable. Please help!
Message posted via AccessMonster.com
if you post here details of your code of macro and error message you get -
then we can try to hel...Access 2003 OLE communication error
MS Access is totally broken on my machine, whenever I attempt to open an
existing database or just open the bare program I always get the error
"A problem occurred while MS Office Access was communicating with the OLE
server or ActiveX control"
It is impossible to regain control of Access, whenever we close the message
box, it just immediately reopens again, and we cannot do anything at all in
including closing down the program. We have to kill it in Task manager.
We have tried repairing Office, we have totally uninstalled Office and
reinstalled it, we hav...Highlighting cells
When I select cells to copy or paste I can't really see which cells are
highlighted because I probably have something set wrong. I would like the
cells I highlight to have a light background color so I can see what is
Any help would be appreciated!!
In MacXL, the highlight color is set in system preferences. Choose
System Preferences/Appearance pane, and change the highlight color to
something more contrasting.
Otherwise, you'll need to use VBA, e.g.:
Though a better way is via Chip Pearson...Problem with copied report in Access 2007
I need to create several reports that are exactly the same but get info from
different queries. I can do this with no problem ... just change the source
for the report ... but the copied report still shows the original report name
in the tab when opened. How do I get it to reflect the new report name
Example - the original report is Employees at CC. I copy/paste and name the
copy Employees at NEC. I then open the report in design view and change the
source and the report displays the correct information. But the tab is still
titled Employees at CC. This will be a problem...Access denied error
We have a series of Word 2003 templates. These templates sit on a network
folder with security permissions of Read & Execute, List Folder Contents,
Read, and Write. Not Modify. A user can open these templates, make a change
and save the changes using Word 2003. The same user using an Office 2007
installation receives an error message of "Access denied. Contact your
administrator". Does anyone know why?
...How do I unrestrict access to files Information Rights Mgmnt?
Yesterday I was working on an excel spreadsheet and could not do "print
preview" without being questioned about Information rights Management in MS
I could not get past this so I went ahead and set up a couple email
addresses of people who could access this file.
Now the software will not properly authorize my opening this file as it
cannot verify my email address. I do not know how to unrestrict the file so
that I can continue working on it.
...How to change color of cell B1 based on value in cell A1
How do I get the background color of cell B1 to change when a value i
entered into cell A1? I'd like for the color of the background to var
depending on the value. Any ideas
dougmcc1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=8
View this thread: http://www.excelforum.com/showthread.php?threadid=48441
This will help.
With A1 the active cell (and red fill color), select Format>Conditiona
Set Condition 1 to 'Cell Value Is' Greater Than B1 cl...Help
When I open or create a database the only menu option avaialbe is help. The
others are greyed out. How can I resolve. thanks for any input.
If you post your question in one of the Access newsgroups, someone may
be able to help you. This newsgroup is for Excel questions.
> When I open or create a database the only menu option avaialbe is help. The
> others are greyed out. How can I resolve. thanks for any input.
Excel FAQ, Tips & Book List
..."Error Access SQL Data" When Printing Invoice
When I go to try and print an Invoice from Inquiry->Sales->Transaction By
Customer->Selecting the Customer and Selecting the Invoice, then clicking on
the Printer icon in the upper right corner of the window, and sending to
either the screen or printer, I get a box with the message "Error Accessing
SQL Data" in it.
Any ideas on how to fix it?
Can't fix if you can't tell what's happening. First some troubleshooting:
1) Exit GP
2) Open Windows Explorer and locate the DEX.INI file. It will be under your
GP installation f...Access 97 to Access 2000 string functions
I'm having problems converting my Access 97 programs to
Access 2000. String functions such as right(), date(), and
chr(13)&chr(10)used in queries won't convert. I get a
message undefined function. Is there a defect in my
installation? If not, can I define the function or what
is the workaround?
Not a problem with your installation, but likely with the References in your
References problems can be caused by differences in either the location or
file version of certain files between the machine where the application was
developed, and where it's being run (or...Access 97 Gurus?
Anyone have a good grasp of a 15 year old program?
One of my customers is having an issue with Access 97.
4 different mdf files live on Server 2003, which is also a TS.
All 4 are opened and used directly on the TS by RDP clients, over the LAN
and over VPN from remote locations.
All are opened and used by same or different workstations on the LAN over
the wire in the traditional way without RDP.
Some Access is 97 SR1
Some Access is 97 SR2
Some databases seem OK
Some throw errors from SR2 but not SR1 versions.
Originally, It was only one database that had...Read Korean in Access
How do I enable the Korean characters to show up MS Access?
...deny access to public folders
i'm kind of confused as to wear all these would be located on my server and
how to deny some users to there access? please help
On Tue, 20 Mar 2007 11:44:08 -0700, tmolaee
>i'm kind of confused as to wear all these would be located on my server and
>how to deny some users to there access? please help
Can you define the goal? Are you trying to deny access to all the
public folders or just a few?
i'm trying deny access to some of them not all but it would be useful to know
how to deny all as well for the future
"And...Show header in cell
I want to be able to show my header in a cell of the associated spreadsheet?
How about turning things around and having a value in a cell (or cells)
on your worksheet that then forms the header for your report.
I'm not sure myself but this thread seemed to work OK for someone else
Hope this helps
tonywig's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18985
...OUTLOOK WEB ACCESS #17
I recently applied the most current patches and fixes to
my Exchange 2000 server. Since then, some of the users
are getting attachments in only HTML format when accessing
the server from off site through OUTLOOK WEB ACCESS. They
need to be able to open them in word or at least notepad.
What made the change and how do I get it back?
...Delete all cell comments in workbook
We are a small cpa firm, it is tax season... We frequently copy last
year's workbook to set-up the current year. I'm trying to select and
delete all cell comments as part of this set-up process.
I've tried goto special and the comments section of the Review ribbon,
but I seemed to be stumped in trying to select all cells in the
workbook that contain a comment and then to delete these comments
without cycling through the next comment for each comment on the
As always, help is much appreciated,
I had no problem selecti...Formula cell references
When you double click on a formula that references other cells you usually
see the referenced cells outlined in a color with reference to that same
color in the formula. What is this called and is this something you can
turn on and off? Where?
It's called "Edit In Cell".
You get exactly the same results when you click in the formula bar.
If you turn this off, double clicking in a cell containing a formula will
then make the focus move to the cell(s) referenced in the formula.
<Tools> <Options> <Edit> tab,
Check or uncheck "Edit Directly I...Cell filter deletion
I have about 1400 cells that i need to delete the information AFTER a certain
word. My issue is anything after, in the cell, X400 needs to get deleted. For
example, i have a cell that says X400:c=us\;a= \;p=First
Organizati\;o=Exchange\;s=Little\;g=Cindy\; but in 1400 cells and its every
cell is different. Any suggestions?
please provide an example
before it looks like..........?
After you want it to look like......?
> I have about 1400 cells that i need to delete the information AFTER a certain
> word. My issue is anything after, in the cell, X400 need...Excell Cells: Auto Formatting
I have protected a workesheet and unfortunately when the people submit
information on the cells and it is too long than the actual height of the row
and it wont extend. What can I do?
When protecting the sheet allow users to format cells and rows.
Gord Dibben MS Excel MVP
On Tue, 9 Feb 2010 13:14:01 -0800, Sophie <Sophie@discussions.microsoft.com>
>I have protected a workesheet and unfortunately when the people submit
>information on the cells and it is too long than the actual height of the row
> and it wont extend. What can I do?
How do I jus...Internal VS External Access to Exchange Server
Internal Domain Name of domain.local
External Domain Name of domain.com
Exchange server named server.domain.local
and RPC port published on mail.domain.com
How do you publish DNS data for laptop users who wish to move seamlessly
between internal connectitivy to the server.domain.local and external
connectivity to the published RPC port on mail.domain.com???
(Pls without using hosts file as this is a bit of an issue with senior
On Thu, 12 May 2005 13:13:23 +0100, "Jason Fitzpatrick"
<email@example.com> wrote...How to set a range of cells
I recorded a macro and changed it as follow:
If I want to set a range from the last selected cell to B4, how should I go
on with the above?
G Lam <No_spam@anywhere.com> wrote in message
> I recorded a macro and changed it as follow:
> Selection.End(xlDown).Offset(0, 1).Select
> If I want to set a range from the last selecte...