Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cannot previous post - email via access to excel template
How do I see previous post from last week?
|
#2
|
|||
|
|||
Cannot previous post - email via access to excel template
I don't know how you are accessing the forum
I use an off-line reader (Virtual Access) so I have local copies of all messages. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
Cannot previous post - email via access to excel template
I had sent you the sql for my access query and now I see nothing. Did you
receive access query? "Bill Manville" wrote in message ... I don't know how you are accessing the forum I use an off-line reader (Virtual Access) so I have local copies of all messages. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#4
|
|||
|
|||
Cannot previous post - email via access to excel template
Yes, and I replied.
I have since had second thoughts and my reply is now modified to: Quite a big query to redefine in MSQuery from scratch. What I suggest you do is define a new query in Access, which is the same as the current one but without the WHERE clause (ie remove the conditions). I will assume it is named "MyQuery". In Excel use Data / Import External Data / New Database Query to retrieve all fields from MyQuery. On the last dialog of the query wizard, elect to edit the query in MS Query. Click the SQL button. You should see "SELECT * FROM MyQuery" Add " WHERE ControlNum=[First Control Number?] And ControlNum<=[Last Control Number?]" If you now try to run the query by clicking the ! button it will prompt you for the 2 parameters (First Control Number and Last Control Number). File / Return results to Excel. Then when you refresh the query in Excel it should prompt you again for the parameters. As mentioned before you can link the parameters to cells if you wish. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#5
|
|||
|
|||
Cannot previous post - email via access to excel template
Hi Joy,
From looking at your headers we can see you are using Outlook Express. The easiest way to find you previous posts and read the entire thread is to use a Google Groups Advanced search, put your email address into the author field for the search, you can limit groups to *excel* with the asterisks and further limit by date if you want. http://www.mvps.org/dmcritchie/excel/xlnews.htm You might want to sign up at Google so that you can reply directly from the thread rather than finding your thread again on OE. But I would continue to use OE for using newsgroups. Google Advanced Groups Search -- http://groups.google.com/advanced_gr...=group:*Excel* Newsgroup: *excel* (optional was specified in url above) Author: __ (place your email address here)___ You can find and look at the thread in Outlook Express. as long as you have the threaded view View, Current View, Group messages ... then sort on username and look for your name as jwr if you type in a k you will start at k which should be a short distance down from your name. More information on using Outlook Express in http://www.mvps.org/dmcritchie/ie/ie6.htm In newsgroups you should be above to change to a view Watched under View or even better if you put the dropdown on your toolbar for Views. They the RED subject titles would indicate your postings and replies under your postings. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "jwr" wrote in message .. . How do I see previous post from last week? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Financial modelling from Excel to Access | Excel Discussion (Misc queries) | |||
Excel template and access questions | Excel Discussion (Misc queries) | |||
Send Excel data to Access through button | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Error message in Excel after exporting Access query to Excel | Excel Discussion (Misc queries) |