Move to standalone components
what is a procedure to move to standalone components from sbs 2008. In
version 2003 there was a transition pack but I cant seem to find one for
__________ Information from ESET NOD32 Antivirus, version of virus signature database 4788 (20100120) __________
The message was checked by ESET NOD32 Antivirus.
There is no transition pack for SBS 2008. You can migrate to EBS, or migrate
to standalone. But there's no special way to do it.
"Namik" <email@example.com>...transactions without saved payee missing from report
I am a treasurer for a charity and have been using money to track the
accounts (because I foolishly believed that it was better than paper)
I have a customised money cashflow report that I need to show all
transactions, so I do the following:
1. select all categories (click on select all button) - this is on the
2. select all payees (click on select all button) on the payee tab
But I have just discovered that for a transaction where I chose not to
add the payee to my list of payees that it is missing from the report.
In otherwords I can only report on transactions for which I c...Calculated Journal Entries
Is there anyway that in GP 7.50 you are able to do a calculated journal
entry-this means that every month I want a journal entry calculated at 3% of
our sales? Is this possible in any way?
Would I need to just enter it in Excel and use Integration Mgr to import it??
Any help would be appreciated!!
You can set up a fixed allocation account to automatically allocate 3% to a
specified distribution account in "real time" as individual transactions are
Fixed allocation accounts are used to distribute fixed percentages of a
single transaction among several acco...Filter lines with Pivot table and non pivot table columns
I have created a pivot table. Next to the pivot table are columns to enter
data and then additional clolumns to add the pivot table and not pivot table
data. I am running a filter on a column in the pivot table, and the non
pivot table data entered does not hold with the pivot table line. (For
example, I have an line in the pivot table (say line 20) call "item 1". I
enter a value in a Column outside the pivot table to correspond to item 1 on
line 20. When I filter on "item 1" - it now moves to line 5; however, the
amount I manually added to line 20 outside the pivot ...Component Gallery
How do I add a component from the component gallery (if it exists in version
7.0!?) like we did in version 6.0?
...Component / Sub-component
I want to model the concept "Component / Sub-component" with
rectangles for example.
If I have component A with it's sub-components A1 and A2, then I have
3 rectangles with A containing A1 and A2.
Is it possible to constraints A1 and A2 moving out of rectangle A?
Then the relation between them is lost.
(In Flowcharter (used years ago) this was easily done).
Thanks in advance...
On Wed, 2 Apr 2008 03:55:31 -0700 (PDT), Qi <firstname.lastname@example.org>
>I want to model the concept "Component / Sub-component" with
>rectangles for example.
>If I have compon...Access
Hi, i have a on going database for my employees and i would like to add
another column employee ID number. On the existing table the column employee
ID is there but no number associated to the employee. I want to import from
excel. the excel file has all employees name and employee number. EE name
is the primary key and i only want to import the EE ID number only, the rest
of the column in the table leave as is. can someone help me with this?
On Tue, 18 May 2010 00:44:55 GMT, "accessnote" <u60148@uwe> wrote:
>Hi, i have a on going database for my ...update selected table values
table 1 col a item name, col b sales price
table 2 has new prices for just selected items
how do I automatically replace the old prices in table 1 with new from table
Near table 1, col C:
Then do a copy, paste special - values
"BlackBayou" <BlackBayou@discussions.microsoft.com> wrote in message
> table 1 col a item name, col b sales price
> table 2 has new prices for just selected items
> h...Registry Entries
Can someone cut and past some code that allows me to write and modify the
I want to work in the HKEY_LOCAL_MACHINE\SOFTWARE\.... area.
Also, I want to put the code in a dialog (if that makes a difference).
Take a look at my Registry classes on my MVP Tips site.
On Thu, 21 Aug 2003 19:12:41 GMT, " JCO" <J.Oliviero@verizon.net> wrote:
>Can someone cut and past some code that allows me to write and modify the
>I want to work in the HKEY_LOCAL_MACHINE\SOFTWARE\.... area.
>Also, I want to put the code in a dialog (if that ...Importing share prices and transactions into money
Is there a way of importing share or unit trust prices into Money? I would
like to update the historical value of some investments which are not
available online. My only alternative at this stage is to manually enter it
for each investment.
I was thinking if I can create a file with the month end dates and prices,
and download it into money.
Four strikes, you're out. No.
"John D." <JohnD@discussions.microsoft.com> wrote in message
> Is there a way of importing share or unit trust prices i...timeout error with activeX component
I'm using an ActiveX interface to a 3rd party application from within my
MFC application. 90% of the functions available from the 3rd party app work
great, but the other ones, typically those which display a dialog asking for
input, cause a "server busy - This action cannot be completed because the
application is busy" error to be displayed after 10s or so if the user
respond to them quickly enough.
I have searched MSDN, but all the references I can find relate to VB. In a
VB application there is a parameter OLERequestPendingTimeout which y...Table functions
I would like to know your advice about two solutions I have to do the
The context :
- an aspnet web application connects to the database with
NetwsorkService Windows credentials.
- I pass some informations about the user connected to the web app
using the Application key of the connection string.
- Other applications, like SSMS, can connect to the database.
So, to retrieve informations about the connection, I wrote two table
functions returning a single row.
If I write a multi-statement TVF, I can use variables to store such
informations as : APP_NAME()...Pivot Table Suppression of Zeros
I was hoping to have some help in suppressing data that do not contain any
values. I have a cost center as the column heading then actual information
and budget information as my data that contain over 90 accounts. I know this
is an option with the TM1 software, which I use that sits on top of Excel,
however I've been tasked with building a pivot table that's user friendly.
Hello everyone, here is my problem.
I have two tables. I am trying to get a field in one populated from a
field in another....I'll try and clarify this a bit.
Table_1 contains the fields:
Table_2 contains the fields:
Project Number (key)
When an entry in Table 2 is made, the 'Resource' field is populated
from a lookup from 'Table_1 Resource Name'
What I want is for the 'Tower' field in table_2 to auto-populate from
the 'Tower' field in table_1 based on the selection of 'Resource' in...Diary entry
We have a company diary setup in Outlook Public folders, I have added a
diary entry to book a resource for a meeting but it has not shown up on
When I try to rebook the resource it says it has already been booked.
Can anyone help me please? I am using Outlook 2003 - Exchange Server
I just installed SBS2008 Premium in migration mode (existing SBS2003
environment). I have done this several times but this is thefirst time that
SBS2008 was Premium Edition.
We are going to install MS SQL on a different server.
Well, it looks like I did indeed install MS SQL on the SBS2008 box (which
was a mistake).
How do I avoid doing that in the future?
Cary Shultz wrote:
> Good afternoon!
> I just installed SBS2008 Premium in migration mode (existing SBS2003
> environment). I have done this several times but t...data entry
I have 4 controls on a form which are used for data entry. How can I make
sure they point to a new record when I open the form? At present, each of
the controls displays the data from the last record
Set the Data Entry property to Yes. It will open to a new record but you
will not be able to edit existing records using this form.
Alternative you can have On Open event to call a macro. Have that marco
action go to new record. This means there will be a new record, even if you
do not want one each time the form is opened.
Build a little - Test a little
"Rafi&q...Web component not responding to SetAddress
I have an odd problem. I added a web browser ActiveX component
to a dialog-based program in VC++, assuming that I could just set its
address and leave it to begin operating as a web browser embedded
in my GUI. Apparently this does not work at all. I tried calling
other methods but none has any effect.
Anybody know why this isn't working?
...Count number of entries each day
I have a table:
I want to count how many trades occur in each day
------------------------------------------------...Pivot Table comments
In a pivot table database I have a column that contains text that we use for
comments or expatiations. Can this information be transferred to a pivot
table like the data can? If so can you help me to configure it properly?
You could add that field to the row area of the pivot table, but it
might result in a very large pivot table.
> In a pivot table database I have a column that contains text that we use for
> comments or expatiations. Can this information be transferred to a pivot
> table like the data can? If so can you help me to configure it pro...Reference temporary table twice
I'm trying to temporary table inside a stored procedure, which might
be constructed in two entirely different ways, according to the
parameters passed to the procedure.
Using Northwind, my problem is illustrated by this:
create procedure prTest
if @type in ('A', 'B','C')
select LastName into #MyTable from Employees
if @type in ('D','E','F')
select CompanyName into #MyTable from Suppliers
select * from #MyTable
drop table #MyTable
...Progress bar for Pivot table
Do anyone know how to create a progress bar while the pivot table refreshing on opening of the excel spreadsheet?
your help is much appreciated!
...cannot install Dexterity Shared components
I am havng problems installing GP on my XP client because I cannot install
the Dexterity Shared Components. The Event Log is telling me that "Product:
Dexterity Shared Components -- .NET Framework 2.0 is not installed. The
installation cannot continue."
This is incorrect, I have 1.1, 2.0, 3.0, and 3.5 installed on this
particular machine. I suspect that the installer is looking for 2.0 and is
finding 3.0 and is therefore saying that 2.0 isn't installed. I cannot
uninstall 3.0 or 3.5 as I have other apps that rely upon those versions of
How can I g...How do you turn off pivot table auto format in Excel?
I want to know how to return to the original/default pivot table format after
I have already applied an auto format report style.
In the list of AutoFormats, select PivotTable Classic, which is at the
bottom of the AutoFormat list.
> I want to know how to return to the original/default pivot table format after
> I have already applied an auto format report style.
Excel FAQ, Tips & Book List
I have tried this and it does not get me back to the original format. I want
to return to the format with the da...Show quantity for different table
Below are my table:
So, I need to have a query to show all the quantity as below structure. If
the part number quantity exists in incoming but not in kanban, it will show
kanban quantity 0
PartNumber Incoming Loan
1111-1111 10 12
2222-2222 10 5
3333-3333 10 0
Message posted via AccessMonster.com