I am working on a browser based application, currently using ShAutoComplete
in order to provide Auto complete facility for combo box used to enter the
address of page that you want to browser. Used ShAutoComplete with
SHACF_URLALL to show list of recently browsed web pages and webpage in
Now how can I add address of web page browsed through my application into
that list ? Means If I browser http://msn.com in my application, then it
should go in the recently browsed page list that ShAutoComplete uses.
Awaiting for your comments.
The interface you are looking for ...Select Query acting like an Update Query
I am having trouble with my database where my select queries are acting as
update queries. If a user happens to accidentally or otherwise adjust the
results provided by the query, it is updating the information on the
table(s). I need to find out why it is doing this and how to prevent this
from occurring and altering the data.
On Dec 17, 9:34 am, Tboartz <Tboa...@discussions.microsoft.com> wrote:
> I am having trouble with my database where my select queries are acting as
> update queries. If a user happens to accidentally or otherwise adjust the
> res...Check query shows voided checks too!
I am running this query but its also showing voided checks! How can I make it
now show voided checks?
SELECT VCHRNMBR AS PaymentNumber, VENDORID, DOCDATE AS CheckDate,
DOCNUMBR AS CheckNumber, DOCAMNT AS CheckAmount
WHERE (DOCTYPE = 6) AND (DOCAMNT > 25000)
Add this to the end of the WHERE clause
AND (VOIDED = 0)
Microsoft GP/SBF Specialist
"Michael@nyresume.com" <Michaelnyresumecom@discussions.microsoft.com> wrote
in message news:7163A485-9E90-48C7-B931-C989827039D6@micros...Running Access Query Returns Incorrect Number of Records
I am running some code which loops through and runs the queries in an
Access Database. The count of the records is then stored in a
For most of the queries, the figure stored in the Worksheet matches
the number of records if you run the query in Access. But for certain
queries, the count of the records does not match the number of records
when the query is run in Access.
If I change the query to a make table query and then base another
query on that table, the results are correct.
Can anybody suggest running the query from Excel would results in a
different number of records bein...Outlook 2003: Email address in 'From' column of Inbox.
Anyone know how to get the full email address to display in the 'from'
column of the inbox in Outlook 2003? I have about half a dozen "Dave"s
that all have different email address but they're indistinguishable in
the inbox. Plus,
I'm sick of just seeing someone's name when I really need to know the
company name more than anything else. At least with a proper email
address, I can easily work out if it's a legit email from a known
company or spam. I don't want to have to read the post to see if it's
I have a table "Rates" with the following data:
StartDate: 5/15/08 End Date: 6/23/08 Rate: $53
StartDate: 6/24/08 End Date: 7/15/08 Rate: $86
StartDate: 7/16/08 EndDate: 9/19/08 Rate: $99
I have another table "Transactions". I want to create an append query such
that if I supply the StartDate and EndDate, the query will populate the
"Transactons" table with date and rate data from the "Rates" table for each
and every day within the date range. Example: If I supply the StartDate of
6/23/08 and the EndDate of 6/25/08, the query would pop...Traspose Column data into Row
I want to transpose column data in to row. I have seen many posts (using
INDEX or OFFSET functions) but all these solution assume a fixed block of
data to be transposed, My problem is that the data i have not only has
variable blocks to be transposed but also has some duplicate
headings(headings are duplicate but the data in front of each heading has
different value. Below is the example of data
Col A Col B Col C
PRODUCT COST COMPONENT COST$
A Raw Mat 10
A D L ...Use list options to hide columns
I was wondering if the following is possible in excel:
<big deep breath>
I have 4 separate worksheets for data entry and results calculation for
radiation detection, each is a separate type of test.
These worksheets/tests share a lot of common Fields for data input and
calculations, what I want to do is combine the worksheets and show/hide
only the columns relevant to each test.
In column A, I have added a drop down list of 4 different types of
Depending on the type of test I select; call them A, B, C & D
Can I use a List to control which columns are sho...List of SNMP MIBs for Exchange
Does anyone know if there is a list of SNMP MIBs available for Exchange
2003 anywhere? I'd like to get some basic statics via SNMP.
On Tue, 14 Feb 2006 09:17:40 -0500, Irwin Fletcher
>Does anyone know if there is a list of SNMP MIBs available for Exchange
>2003 anywhere? I'd like to get some basic statics via SNMP.
I think you should be looking at WMI instead.
...How do I eliminate duplicate addresses from multiple lists?
Just moved to Exchange from GroupWise. I maintain seperate address lists in
excel and access and some of the addresses are in both lists. In GroupWise I
could copy an entire column of addresses from an Excel spreadsheet into the
To: box and blanks would be eliminated, then I could copy a column of
addresses from an access database into the To: box and both blanks and
duplicate email addresses are eliminated. How can I configure Outlook to do
Nichol1947 <Nichol1947@discussions.microsoft.com> wrote:
> Just moved to Exchange from GroupWise. I maintain seperate address
...Make Excel Database from HTML
Hello. Im new here and I kinda know some about Excel but I have a
problem. I need to make an Excel Database from an HTML file and I dont
know how to get about doing it. The website is simple w/ one graphic at
the top and just links going down...
I dont know if Im posting in the right place but...
NTL1991's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29081
View this thread: http://www.excelforum.com/showthread.php?threadid=488078
---...SQL Query to transform/group data by Date
I have a large Access table with data organised as follows:
There are seveal different codes and therefore duplicate dates. I'd like to
run a query to bring back each code grouped by date and so put the codes
along the top as feilds. For example the query below brings back the
following data for two codes.
SELECT field2, field1, field3
WHERE field1 In ('LLOY','RSA');
21/01/05, LLOY, 12454
22/01/05, LLOY, 31541
21/01/05, RSA, 21241
22/01/05, RSA, 12414
Instead I want the data to look like this:
...Drawing a selection box using CRectTracker
I have an MFC SDI CView application and I want to draw an selection box
when the user left clicks and move the mouse. I have found the CRectTracker
class but I can't get it to work
I have this code:
void CSCMLaserView2::OnLButtonDown(UINT nFlags, CPoint point)
m_startPt = point;
void CSCMLaserView2::OnLButtonUp(UINT nFlags, CPoint point)
//Release the capture on the mouse
CSCMLaserDoc* pDoc = GetDocument();
ASSERT(pDoc != NULL);
// Co...IF ISNUMBER FIND in query design expression
I use the following formula in Excel and it works...I now want to do this in
a query. Can I add it as an expression in the design grid in a seperate
column and how does the syntax change? I will also want to use TRUE/FALSE
for the result.
Try this --
My_Output: IIF(InStr([YourFieldName],"TRANSF")>0,"*", "")
Build a little, test a little.
> I use the following formula in Excel and it works...I now want to do this in
> a query. C...list links in new worksheet
I want to get a listing of all links in a new worksheet within th
workbook - alternately I would like to get a list of all linked cells
is there a way to do this? Thank
Message posted from http://www.ExcelForum.com
Something like this post:
And no matter what you're doing with the links, get a copy of Bill Manville's
"txbjones <" wrote:
> I want to get a listing of all links in a new worksheet within the
> workbook - alternately...Converting MS query from Excel 2003 to Excel 2007
I have a master spreadsheet that I want to convert to xlsm format. However,
I have two other spreadsheets that utilize MS Query to pull data from my
master spreadsheet. How can I convert my master spreadsheet without losing
the MS queries I have built in the other two spreadsheets? Is there a simple
conversion process? I have tried to update the individual ms queries but I
keep on getting error messages when I point to my master spreadsheet with the
xlsm extension. Thanks.
The "problem" with MS-Query and Excel 2007 is that instead of downloading the query to a data...Adding an address to a Contact List
The client is using Outlook 2003 SP2.
I know you can click on an email address in an email and add it as a contact
to my main Contacts list.
Is there a way to do the same task but add it to my other Contact Lists
already setup as an addressbook...?
Tom Karpowski wrote:
> The client is using Outlook 2003 SP2.
> I know you can click on an email address in an email and add it as a
> to my main Contacts list.
> Is there a way to do the same task but add it to my other Contact Lists
> already setup as an addressbook...?
>...Random Number in Query
Hi. I am trying to get a Random number between 0 and 5 to appear on each row
of a query. I can get the same number on each row (it changes every time I
run the query) but cannot get a different random number for each row.
Basically, I want to create some Test data by adding the Random number to a
Received Date and then saving this new date as a Completed Date.
I have created a Module to generate a Random number:
Function Random_Number() As Integer
Random_Number = Int(Rnd * 6)
Then, I call the function from a query:
Field = Number: Random_Number()
Ca...Select tab to import from excel spreadsheet in Macro
I have one excel file that contains multiple tabs. Is it possible to
select a specific tab to import in a Macro? I have static labels on
these tabs that can be referenced. If so, which function would that
Your help is appreciated!
Just to clarify, I just need to import one tab at a time, but when i
specify the worksheet name in the range field as WORKSHEET!, it
wouldn't take it.
On Oct 30, 11:29 am, KT <kan...@rocketmail.com> wrote:
> I have one excel file that contains multiple tabs. Is it possible to
> select a specific tab to import in a Mac...word freezes at the template selection screen at startup
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC
My whole machine went down about a month ago. Finally got to installing office today and word freezes. I've uninstalled and reinstalled to no effect.
Download and install the latest Office 2004 updates, which are the Office
2004 11.5.0 & 11.51 updates.
In Office 2004, use Microsoft AutoUpdate to get the latest updates. From
any Office application, go to Help > Check for Updates (or manually launch
Microsoft AutoUpdate from the Applications folder). If any updates are
needed, they will display in a sheet...Linking columns for auto fill
Can I link two columns to auto fill Column A when corresponding data is
entered in Column B?
In A1 enter =IF(B1="","",B1)
Copy down column A as far as you wish.
Gord Dibben MS Excel MVP
On Thu, 25 Mar 2010 09:11:01 -0700, Daisy <Daisy@discussions.microsoft.com>
>Can I link two columns to auto fill Column A when corresponding data is
>entered in Column B?
...Dlookup in query
I have a query in which i want to use a dlookup which i have embedded in a
function. Strange thing is that the first record returns the correct value
and after that i get a invalid use of null.. ??
scenario (for testing purposes)
MyDate (set to date time)
MyAmount (set to currency - standard - two decimals)
Dummy (text field)
FutureDate (Set to date time)
Created a query with the two fields from table2
both fields added to the querygrid. Third field added as follows: Amount:
function GetPrice(FutureDate) as d...Lists
I have a user who is importing an excel spreadsheet into a Sharepoint List,
but some of the column types that SP is selecting is incorrect. I can't find
any place to change the type of these columns (like from text to text with
Is this possible?
Yes, you can change the column type after importing. Just go to the list
settings page and choose the column you would like to update. The very first
section of the column settings page will be for the data type of the column.
"J. Belcher" wrote:
> I have a user who is importing an excel sprea...Selecting Cells with Shift Key
When I am selecting cells in Excell, I use the shift key and the arrows on my
keyboard. If I pause at all, the selection is lost when I continue with the
selection. Why? Can anyone help me?
If you have removed your finger from the shift key then Windows will think
you are starting a new selection. Just be sure that you don't touch the
arrows without the shift being held down.
"Jaymndad" <Jaymndad@discussions.microsoft.com> wrote in message
> When I am selecting cells in Excell, I use the shift key...open excel 2007 refresh query from batch file
I have a simple script saved as "C:\refresh_excel.vbs" that opens an
Excel file, and does a refresh for a query on Sheet 1. I created a
scheduled task to run this every day.
It worked fine for previous versions of Excel, but since I have
upgraded to Excel 2007 it doesn't work. Any help it helping me figure
this out would be appreciated.
/*contents of refresh_excel.vbs*/
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkBook = objExcel.Workbooks.Open("C:\reports\UPS.xls")