Error Running Inventory Site Combiner 7.5
I am trying to run the Inventory Site Combiner in
Great Plains Version 7.5 SP5. I am receiving the
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation
of PRIMARY KEY constraint 'PKPOP40800'. Cannot insert
duplicate key in object 'POP40800'.
I checked the ODBC connection setup and is correct.
...rent received/balance owed/running balance spreadsheet
I am looking for a spreadsheet?? that shows me the rent owed then paid by the
renter and balance if any per month, but do not know how to build one!
A very simple balance sheet assuming a monthly rent:
A1:D1 column headings:
D1: Under/Over Paid
Then in cell A3 enter the formula:
and copy down as far as you need. All cells should remain with a blank
display until a date (more then a month old) is entered in A2 then
automaticall...Erroring Openeing Subform
I have a mainform / subform which when the user double clicks on the
subform, it opens a pop up form which displays the record slected in the
subform so the user can edit data.
I use the following to open the pop up form:
DoCmd.OpenForm "frm_BkpExec_Ntepad", , , "id = " & me!id
This works fine, except if there are no records in the subform, and the user
still double clicks in that window, then an error gets returned.
How can I have this so that when the user double clicks in this window and
there are no records in the subform, the double click is just ignor...sum calculation in subform based off of a query
I have a Main form that has date at the link to the subform. each record is a
given DAY then the cleaning jobs are scheduled in the subform. Each cleaning
job has an est. time. In the subform many people are scheduled to do many
jobs. and same person is usually scheduled to do many jobs.
Worked hard and this is the way the form subform - we want layed out.
I would like to get a running total as each job is scheduled in the subform
- sum of est. time by person(clockid). Have the subform sorted by person so
they are all grouped together- tried putting sum of est time in footer. Many ...Executing code in the background
Is there workaround or atleast a future possibility in Microsoft CRM
of executing some code in the background without the opening of a
ie I have a requirement that I need to do some background processing
when a button is clicked and the user does not need a message.Since I
link the button to a URL (an aspx page) it opens a window, executes
some code and closes the window.The end result is an ugly but quick
flashing of the screen.
You will actually be able to invoke script directly on the buttons you add
via ISV.config in the next version without having to pop a window...Conditional format to determine if last character in a cell is a number or a letter
I have a spreadsheet where I enter weights. The weights can be any
whole number 1-99999. I would like to be able to flag suspicious
weights using conditional formatting by putting a letter as the last
character, such as 123a, or 57b, 4471c, etc.What conditional
formatting formula can I use to accomplish this?
Assuming your weights are in column A, starting with A2, highlight the
cells in that column with A2 as the active cell, and use this formula
in the CF dialogue box:
Then click on the Format button a...Smarlist Totals
GP V. 10 - when in a smarlist that has columns with numbers I used to have a
section on the bottom of the GoTo window called Smarlist Totals - it would
open a seperate window that showed totals for any column with a number in it.
All of a sudden it is no longer there and I am not sure how to get it back.
I am logged in as a Poweruser.
I don't recall this ever being a functionality available in SmartList or
SmartList Builder, but hey, I may be wrong.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximu...Help with cell totals
My problem is that I have two rows, one contains the manufacturers
name, and the other the amount that manufacturer supplies. What I need
to do is get the sum of the amount supplies for each manufacturer.
Company 1 8
Company 2 5
Company 2 7
Company 1 2
Company 1 10
Company 2 12
blackie's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15223
View this thread: http://www.excelforum.com/showthread.php?thre...Total daily e-mail count?
This might seem like an odd question, but my CIO is asking
for a total e-mail count for messages both sent and/or
received by our organization on any given day. I'm
currently using Exchange Server 2003. Can this
information be found within System Manager, or will a
third party utility be needed to accumulate such
Perfmon will give you some basic metrics. Otherwise have a look at
MessageStats from http://quest.com/messagestats. Fully-functional 30-day
eval on the site.
David Sengupta M.T.S., B.Sc., MVP, MCSE, MCSE 2000, CCA Ottawa, Canada
Exchange Rep...how 2 create and run a macro
i want to try record a new macro. can you teach me the way to create and run
i am facing the problem
a good introduction to macros can be found at:
Lee Sok Har wrote:
> i want to try record a new macro. can you teach me the way to create
> and run it.
> i am facing the problem
...Will my Office OS X updated to 10.1.9 run on my new Intel nased Mac
Operating System: Mac OS X 10.5 (Leopard)
I have Office for Mac OS X, uppdated to 10.1.9., on my old 10.3.9 G4. I am taking delivery of an Intel based Macbook Pro running 10.5 Will my old Office run on Leopard? If not, is the Home/Student Version equivalent, or do I have to buy the much more expensive Office 2008? Can you get rebates?
You've actually raised several issues here, so see the in-line responses:
On 6/28/09 12:27 PM, in article firstname.lastname@example.orgR9absDaxw,
"Sparkswj72@email@example.com" <Sparkswj72@aol.com@officeform...Ability to create formula to calculate benefit or deduction code
Would like to use a benefit or deduction based on a formula to calculate the
amount instead of choosing only a flat amount or % as it is currently set up
in GP version 9.
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 message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Commun...Why does code Loop
When I click on a command button to show a report I have a break point on the
command_click. Upon clicking the command button it opens a report.
DoCmd.OpenReport stDocName, acPreview
As I step through the code I noticed that as I come to the end sub I expect
the code to stop. But It starts back at the report_activate event and loops
through the code again then opens the form.
Thanks in advance for you help
If I had to take a guess, opening a report causes more than one event to
fire, and one of those events calls another...
Does this sound like what's happening?...Why doesn't the code create a column stacked chart?
Hi again...im sorry to ask for help so much, but charts vba is tricky
I try to create a column stacked chart of three bars containing each
three different values, much like Andy Pope's
The CHT_21QSBA_S, CHT_21QSBA_B and CHT_21QSBA_A ranges are each three
different cells (name CHT_21QSBA_S = A1,B5,Q3) and I thought this
together with stating charttype=xlcolumnstacked should create a stacked
chart - but it make 9 bars instead...
Set cht = ActiveSheet.ChartObjects("R_Q_" &
Sheet1.Range("RAPP_TILLF").Value ...need to total occurances of Long distance Phone Number
I have created a filter, and I need to determine if a call
was a long distance phone number, the column name is
ToPhoneNumber. If the phone number starts with a 1 and has
more than 5 digits its a long distance phone number. I
need to exclude 800 and 877 non toll calls in my
Once I am able to perform the above, I will then be able
to calculate the duration of the long distance phone calls.
try using a helper column for filtering this. enter the following
formula (if col. A stores your phone numbers):
=IF(AND(LEN(A1)>5,LEFT(A1,1)="1"),"Long Distance&quo...multi criteria code
hello every one
I have this code from Northwind sample.
Private Sub ReviewProducts_Click()
' This code created in part by Command Button Wizard.
On Error GoTo Err_ReviewProducts_Click
Dim strMsg As String, strTitle As String
Dim intStyle As Integer
Dim strDocName As String, strLinkCriteria As String
' If CompanyName control is blank, display a message.
If IsNull(Me![CompanyName]) Then
strMsg = "Move to the supplier record whose products you want to
see, then press the Review Products button again."
intStyle = vbOKOnly
strTitle ...xsd.exe and code generation
I have three xml schemas, one schema contains types that the other two
referance. When generate code for each of the schemas, all three cs files
contain the types that are part of the common schema.
Currently I am going through the auto generated code and removing the common
types, with the help of the compiler since they are all in the same
Aside from listing all the types I want generated in each of the other two
schemas, as I may add more in the future and don't want to forget to add to
the list, is there a way to get XSD to not generate the common types for the
other two ...Can someone tell me what is wrong with this code?
.Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
You have a bad line break:
.Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
.Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
> With Sheets("Sheet1")
> .Sele...There must be a better way to code this
I am no VBA pro but I do write several semi complicated macro.
Here is that I wrote to check for two errors using if then else
statements. It works perfectly but I wonder I it could be written more
If error1 <> 0 Then 'error 1 check
If error2 <> 0 Then 'error 1 & 2 found
MsgBox error1 & " data input are missing and highlighted in
yellow. " _
& error2 & " entries are a missmatch and highlighted in blue."
Else 'error 1 only found
MsgBox error1 & &qu...error code 80248009
I have a 32-based system and get this error when looking for updates. I
followed all the instructions posted in thread dated 1/22/10 regarding this
error (running multiple scans), except for the readiness tool as it won't
work on my system. I still can't get updates and can't find anything on
Microsofts website regarding this error. I searched for a readiness tool for
32 bit systems, but couldn't find anything. Any other suggestions?
2145091575 WU E DS MISSINGREF
The data store is in an invalid state because data that should be present is
missing....totals do not display unless user clicks on text box
I am relatively new to access. I am using access 2007 to create a
report that contains subtotals. When the report is displayed on the
screen the subtotals are blank. When the user clicks on the subtotal
text box then the value appears. The user has to click on each
subtotal in order to make the value appear.
Has anyone experience this problem? Is there a workaround or
Normally a sub-total in a report is achieved by means of an unbound text box
in a group footer with a ControlSource property which is an expression
summing a set of values from the detail sect...can i create formula giving totals based on financial & text info
Am i able to create a formula that gives me monetray totals for expenditure
on hotels, split into totals for 6 varying business sectors?
...If, say, =SUM(I2:I10) totals "0", how to change formula to put a "0" in I11?
I know this is going to be simple but everything I've not got anything to
work. How can we change formula, pls, to have "=SUM(I2:I10)" show up as "0"
in I11 if there aren't any values anywhere in I2 to I10?
If there are no values to sum the formula should already be returning 0.
What result are you getting?
"StargateFanFromWork" <NoSpam@NoJunk.com> wrote in message
>I know this is going to be simple but everything I've not got anything to
>work. How can we change f...VBA coding to retrieve data from Access to Excel :S
This is what i have so far. I have an excel workbook with 3
worksheets, SETUP, DATA and DISPLAY. I have been using a pre-coded
program to bring data from a database where the program using the SETUP
sheet from the excel workbook as its critaria and then populates the
DATA sheet. I then can use the DATA sheet to display data in the
DISPLAY sheet in which ever way i want.
Complication is that this pre-coded program is limited to the amount of
tables it can hit at a time. Basically its programmed to read up to 3
I now need data from 5 tables all together. The first t...Is RAID1 good enough for a local office database/file server (running Windows 2008 Server)? Or RAID5? Options
Our IT suppliers are telling us that hard disks are now so reliable,
that RAID1 good enough for a local office database/file server
(running Windows 2008 Server)? Or should we go for RAID5 ?
All feedback gratefully appreciated.
RAID 1 is at least equally reilable as RAID 5.
Both configurations tolerate losing one disk.
However, if you calculate statistically, chances are bigger that one drive
will fail out of three (RAID 5) than one out of two (RAID 1). The same is
statistically true that two drives will fai...