auto number index snafu
I have a 2003 DB I've been adding to for 2 years. It's at 423 records =
I export to a PDF for simpler searching and viewing.
Using the search the other day, I went to grab DVD 186, on carousel tower=
And what came up didn't match the record.
The index was totally screwed.
I went thru all 423 records and created a numeric index by hand. The auto
number field is useless.
But I would still prefer an auto number field.
Trouble is when I create the auto number field, it's still off the actual
numbers of the records..
ie: 99-100 is actually 99-186,187, 188, 189 100-385,...Update MSN Services with Money 2007
How can I update the Portfoglio and Accounts on MSN with MS Money 2007
Deluxe version ???
Thank you. Bye.
In microsoft.public.money, Paolo B. wrote:
>How can I update the Portfoglio and Accounts on MSN with MS Money 2007
>Deluxe version ???
Transactions that you enter yourself into Microsoft Money 2007 would
not be forwarded out to MSN Money. This keeps that info on your own
For institutions with their own OFX servers, you would have to set
up those accounts to download into MSN Money also.
Accounts where the data comes in via "third party" ...Auto complete in Excel (Office) 2003
Is it possible to increase the *memory* of autocomplete?? I notice in the
columns that excel will attempt to autocomplete if the text has been used in
the last 100 or so cells (i think). What I would like is it to attempt to
remember , say, 500 cells back. Is this possible?? Have I explained myself
well enough? :-)
Check http://www.excelforum.com/showthread.php?s=&threadid=219730 fo
Message posted from http://www.ExcelForum.com
...Outlook 2003 Imap Auto Purge wish list
I hope someone at Microsoft can code in a auto purge Imap
deleted email function into there next Service Pack. I
can see a problem rolling this out to our employees.
There going to delete messages and those messages are
going to stay on the Email server until they do a Purge.
I'm afraid they just won't do this.
We use Imap.
No auto purge means emails staying on the server which
over time just takes up hard drive space and makes tape
backups take longer.
You should send suggestions to email@example.com as the newsgroups are
not monitored for feature request...Auto Forward mail to a group of External addresses
Can someone please tell me how I create an Auto Forward
to a group of external email addresses.
I want to setup an auto forward on my exchange so that
all mail sent to firstname.lastname@example.org is then forwarded
to a group of email accounts such as email@example.com,
Can someone please tell me how I set this up on an
exchange server. I know how to do it for an individual
but I can't work out how I create an auto forward for a
group of people.
Thanks for any advice!
what version Exchange? only the terminology is different...create custom
recipients/contacts ...Automating Auditing of Directory Service Objects
Hi. Is there a way to automate the deployment of Auditing settings to
the OU's in AD? I only have a handful so it doesn't have to be TOO
efficient. These have to be deployed automatically (via script,
command line or whatever) if at all possible.
Is this possible? If so, where can I start looking?
On Wed, 19 May 2010 06:42:49 -0700 (PDT), Neil
>Hi. Is there a way to automate the deployment of Auditing settings to
>the OU's in AD? I only have a handful so it doesn't have to be TOO
>efficient. These ...Sql to find record in a hierarchical chain
Hi, lets say I have a table with 2 fields:
Field 1 - ref
Field 2 - parentRef
Now in the structure there could be numerous chains until you get to
the top of the hieratchy (where the ref field = parentRef field).
so in this 444 is top of the chain (there will be many other records
as well that are nothing to with 444 and are part of their own
hierarchy). So how do I easily relate 111 to 444. Ie how do i find
the ultimate top parent for a given 'ref' field.
Hope anyone can give me some pointers ...Excel / VBA / SQL DB
Anybody done any work with Excel / VBA / SQL DB?
Can you give me some pointers on how I could do the following all in one VBA
1) From a cell variable value (ie, user enters a customer code), I query
table A and put the data into a worksheet starting from say cell A1.
2) A blank row is created after the last data line in point 1 above.
3) Using the same cell variable, query table B and put the data into the
worksheet starting from the row after the blank row in point 2 above.
and so on.
Like I've said before I work with ASP all day and know about ADO
connections, commands and...Error 1606 Money Service Pack 2002
I have tried all of the suggested fixes that I've seen on these boards for
the error 1606. I now have no money program, I can not reinstall the money
program and the error still pops up in my Turbo Tax and it is driving me
crazy! I can not delete the service pack from the add or remove programs
applet. I would very much like to finish the taxes before the 15Th. Does
someone know what is going on? I've deleted registry keys, done clean boots,
tried to eliminate every vestige of the program that can be found yet, when I
try to reinstall from the disk, I'm stymied by Error...Inserting Excel into Access Reports
Have a great Access application that produces a nice template (headers &
footers) report into which I'd like a spreadsheet inserted before going to
the printer. In the past, I'd just print the Access reports, then reload
them into the inkjet printer and run the Excel spreadsheets as needed. The
heat of the new color laserjet turns the paper grey if it runs through too
often, so it's time to get the reports printing on one pass.
Any suggestions would be welcome. I've of course also got Word XP, MS
Publisher XP, as well as Adobe Acrobat, if anyone thinks it m...email address on Service Call Entry window
Add an email address field to the Service Call Entry window for the customer
contact on the service call. Even if it is not pulled from the email address
of the address id on the service call, at least the dispatcher could enter an
email address on the service call in order to communicate with the customer
regarding the call. It is common to take email address as part of contact
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the m...Auto forward incoming mails.
How to configure such that all incoming mails to exchange will auto forward
to my personnal email address?
You can create a rule for that; Tools-> Rules and Alerts
Note that automatic forwarding is disabled by (secure) default on the
Exchange server. To enable see;
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Emyeu" <firstname.lastname@example.org> wrote in message
news:uNQsdGAkEHA....Can I set SQL mirroring across WAN?
We have a 100 Mb dedicated DR link to another data center. Want to set up a
SQL 2008 database to use mirroring from primary to a standby server at the
remote data center. I did a ping test and here is the result.
ping -n 100 -l 5120 <target IP>
Ping statistics for <target IP>
Packets: Sent = 100, Received = 99, Lost = 1 (1% loss),
Approximate round trip times in milli-seconds:
Minimum = 8ms, Maximum = 19ms, Average = 11ms
is the network latency good enough for database mirroring? Does anyone know
the min. requirement? Field experience will be fine too....how to insert borders on flyer within Microsoft publisher?
Please help, I'm trying to insert a border around a flyer...I'm using
Is it a clipart border, Borderart or a simple rectangle? What problems are you
having? What version Publisher? Any border you insert should be sent to the back
so it does not interfere with your main design.
Mary Sauer MSFT MVP
"Harriet" <Harriet@discussions.microsoft.com> wrote in message
> Please help, I'm ...Upgrade GP 9.0 SP2 to GP 10.0 Advice
We are planning our upgrade of GP9.0 SP2 to GP10.0. We are running SQL 2000
and would like to also upgrade to SQL 2005.
I am using the following url (and read some threads on this forum):
(page: Updating to Microsoft Dynamics GP 10.0)
The chart Microsoft provides says I can go from 9.00.0281 (which is SP2) to
10.0 or any patch install.
What does "any patch install" mean?
Does this mean I can't go directly to 10.0 Feature Pack 1?
Would i...Need Help With GP Item Pricing
GP ITEM PRICING
I need to use “Bucket Pricing” for items in GP. For example below is the
pricing schedule that I need to use.
First 20 …………….$ 1.75
Next 280 ……………… 1.36
Next 700 ……………… 1.23
Next 2,000 ……………… 1.09
Over 3,000 ……………… .82
So if I had a Qty. of 350 it would be as follows
20 * 1.75 = 35
280 * 1.36 = 380.80
50 * 1.23 = 61.50
Total : $477.30
In GP I can only set it up to do a “Quantity Range” in the Item Price List
Maintenance window. Problem is if I set it up that way and enter a quantity
of 350 it will default to the $1.23 ...Auto Fill a Textbox in Form
What is the simplest way to auto fill a textbox (in a form) with the maximum
values of more than one field in the last record entered, in the same table?
Can the =DMax function be used for this?
I have tried =DMax(“[field_1]”, “[field_2]”, “[field_3]” , “table_1”)+1, but
this doesn’t work.
Is something like this possible with two or more feilds with DMax?
Message posted via http://www.accessmonster.com
See MinOfList() and MaxOfList() here:
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allen...SQL 2008 x64 SP1 SSRS
I've installed SQL Server 2008 x64 SP1 SSRS on a server running
Windows Server 2008 x64 Standard and am having major issues. I
installed and configured SSRS using documentation provided by our CRM
application (ConnectWise). They appeared to be pretty standard
options. For SSL I chose the certificate for mydomain.com. Inside the
Reporting Services Configuration Manager it shows the following URLs:
Web Service URL:
Report Manager URL:
...Web service error
When I Call the CRM webservice from an aspx page the first time I get this
System.Net.WebException: The request failed with HTTP status 401:
message, WebResponse response, Stream responseStream, Boolean asyncCall) at
methodName, Object parameters)
If I click refresh it gets me the correct data.
Could this be the solution ? Anyone tried it
-----------------------------...Posting a Journal Entry directly Into SQL?
Currently, we using Integration Assistant 8.0 for Excel to import about 6
Simple Journal Entries per day. This was fairly easy for the first few
weeks, but now it's just getting boring.
Our process goes something like this: Run a custom SQL Query (that operates
on both Great Plains and other data sources) that produces a result set that
is cut and pasted as a formatted Journal Entry into Excel. Then, from Excel,
we just run our already-built integration package which imports the batch
into Great Plains.
We've already figured out how to get some basic transaction data out of
Gr...VBA and SQL Query
i use GP 8.0 and i want to make a custom form for a specific need. i cannot
use Dexterity for this change so i really need to use VBA.
however in the vba form i want to make a few sql select queries to pull
client names, and call a table view, and eventually run a few update queries.
is that possible to do with VBA in GP 8.0 ?
Yes. You need to create an ADO connection and execute through that.
Go to Customersource and search for ADO and VBA. Somewhere, I think in one
of the demo links, is a file containing sample code that show you how to do
this, including use of the retrievegl...chart auto
i am studying statistics and i have something to do but i don't know. i want
to make a work book which i entry a value every month, i want every month the
bar chart which i have created to auto add the value of the new month. how
can i set the properties in the bar chart like, every month of every year to
have the same color (auto)?
Thank you for your time
...Add Item to GP Menu
Does anyone have instructions on how to add items to the GP menu? I believe
it can be done with Dexterity, but I have no idea what file to modify or how
to use Dexterity.
> Does anyone have instructions on how to add items to the GP menu? I believe
> it can be done with Dexterity, but I have no idea what file to modify or how
> to use Dexterity.
Please look at the Integration Guide PDF manual installed with Dexterity.
Part 5 explains the navigation model and how to work with command forms,
commands and menus.
T...Equation Numbers, inserting field
I have a list of equations in a word document that I need to add a reference
(the first equation in the document will be equation A, the second will be
equation B, etc. When I get to equation 27 it needs to be AA, then 28 will
be AB...) next to. However, I will be adding other equations randomly
throughout the document and referring to the equation reference in text
paragraphs. I would like to have both the equation reference and the text
paragraphs to update if I add an equation to the middle of the document. I
know I should use a field code and cross reference it in the tex...MS Query
This is a multi-part message in MIME format.
Currently I have a number of MS Queries connected to an Oracle DB =
through the ODBC. We have had to change the user name and password for =
accessing the database so I need to change the queries.
The ODBC setup on the PC has been changed but each of the queries still =
access via the original id, is there a way in the query editor to change =