Form Creation To Track Investments
Firstly, can I say I have been through the forum looking for an answe
and have came up with nothing but VBA solutions. For someone wit
absolutely no VBA experience, this is daunting!!
I'm attempting to create a workbook which will contain 9 worksheets o
separate investment portfolios, from which I will use excel to analys
the data. However, my problem lies in getting the data in there in th
Ideally I would like another worksheet to contain nothing but a for
which would allow me to choose the portfolio, the investment, date o
valuation and value. Data from this form w...How can I know which SP has been put on the exchange2K
Where can I see this msg?
Open exchange manager, organization, right pane.
"Geoffrey" <firstname.lastname@example.org> wrote in message
> Where can I see this msg?
check for the answer on the 10th(9th from ur posting)thread on this
site,that is named"finding on version of sp installed"
...how do I change the table from which a form obtains data
I have a form that I have set up, but I would like to re-create it several
times and change the table that each copy gets data from.
EG Table 1 feeds Form A. I want to copy this form to create form B but it
currently gets data from table 1, so I need to change it so that it now gets
data from table 2.
That's probably clear as mud but hopefully someone can help me!
If all the tables have exactly the same fields, you just need to change
the Form's RecordSource.
Copy the form to another name, and change the RecordSource table, or
more usually, a query against the...Use Form to prompt for report criteria
I have a form that I am using to prompt for report criteria. When I run the
query outside of the form, it works fine - prompting me for both criteria.
However when I run from the form, I get #Error#. Can you see what I am doing
wrong? Thanks in advance.
I have two combo boxes that I have put in my underlying query. In the
fields of the query are:
[Forms]![frmSelection Criteria Form]![OfficeNumber]
[Forms]![frmSelection Criteria Form]![Manager]
On the OnClick event is the following:
Private Sub Command6_Click()
On Error GoTo Err_command6_Click
Dim stDocName As String
st...Public information store
Exchange 2K-Under the Properties for a new public folder I have created, the
Directory Rights tab is grayed out.
Any input would be appreciated
On Tue, 12 Jul 2005 12:01:03 -0700, "Joe M"
>Exchange 2K-Under the Properties for a new public folder I have created, the
>Directory Rights tab is grayed out.
>Any input would be appreciated
Its grayed out until you mail-enable it.
...How can I print just the flip side of a booklet?
How can I print just the flip side of a booklet? I printed the first side
just fine and then my computer went funny and I had to shut down and start
back up again. I have 25 copies of the first side that need to be printed on
the back side.
Pub 2000 user here:
There may be a better way but I think you will have to print a page at a
time i.e., File, Print Page 2 of 2; then 3 of 3 and so on.
"pqc18" <email@example.com> wrote in message
> How can I print just the flip side ...3.0 Customization
Is it possible in 3.0 to have one set of screens appear for one group of
users and another set for another group. For instance, could our
service people only see the service screens while our sales people only
see the sales screens? I know I can restrict access to different areas,
but we want to have a totally different look and feel for each group...
Sorry - I dont believe this can be done
"Matt Harvey" <firstname.lastname@example.org> wrote in message
> Is it possible in 3.0 to have one set of screens appear for one group of
>...is there anyway to access funcion written in c by vc++
Is this is possible to access ,a function written in C by VC++.
>Is this is possible to access ,a function written in C by VC++.
Yes. I suspect you need to know about using extern "C" to tell the
compiler that your function is 'C' rather than C++. For example:
extern "C" int MyFn( int p1 );
You often use it like this:
MVP VC++ FAQ: http://www.mvps.org/vcfaq
who put that g key in the wa...How to sort calendar entries on "size"
I would like to remove large size calendar entries by
being able to sort on "size". I am able to sort Inbox
items on size but not calendar. My company's exchange
server has email account size quota and a 3rd of that
quota is being held up by calendar entries on the server
side, so I would like to get rid of the unwanted past
celndar entries that occupy portion of my account quota.
Any help is appreciated.
On 11/18/03 9:21 PM, in article email@example.com,
"Umesh" <firstname.lastname@example.org> wrote:
> I would...Insert,Update Data in sage (MS Access Linked tables) using Vb.net form
I am developing application using vb.net which requires integration with SAGE
LINE 50 (Accounting software ) V11... The data which SAGE is using is MC
ACCESS 2003 database... with linked tables in it... Now I Have developed the
Sage connection using ODBC which works fine when reading the record but
cannot Add or Update record into the Linked tables.... When i debug the
program the error is at the line where it has...
Can anybody Help ?????
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/acce...outlook can't receive exe files
A guy here at work can't get exe files through his outlook. Is there a check
to uncheck somewhere to allow it to do this? He can receive normal
...Accessing MIcrosoft Outlook
Yesterday, when I tried to access Outlook in my home pC, I received
the following message:
Cannot open MIcrosoft Office Outlook. Cannot open the Outlook
window. The set of folders cannot be opened. The file C:|Users
\jillandgordon\AppData\Local\Microsoft\Outlook\Outlook.pst is not a
personal folders file.
Does anyone have any ideas as to how I can fix this?
Gordon in TX
Try this first
"Gordon McDougall" <email@example.com> wrote in message
news:d0e17ac8-0215-431c-971f-bd862b58a245@y17g2000yqd....How Can I Control When Messages are Downloaded from Server
I have the box "Check for messages every ___ minutes" unchecked
Yet seemingly randomly, messages get downloaded a couple of times a day
without my clicking "Sync." This is problematic due to the way I share the
Is there another setting I need to keep this spontaneous downloading from
"Gripper" <Gripper@discussions.microsoft.com> wrote in message
> I have the box "Check for messages every ___ minutes" unchecked
> (too...How can I sort duplicate text data in excel?
I have a large list of noames that I need to make sure that none of them are
duplicated. Is there a way to have excel check it quisker than me reading
every name until I find a duplicate?
After selecting your data go to filter Advanced filter and check "Unique
You can even copy it to another area all uniques entries if you want to ...
"TinaScheu" <TinaScheu@discussions.microsoft.com> wrote in message
>I have a large list of noames that I need to make sure that none of them
>...I do not have access to the D: drive from Publisher, why?
I do not have access to the D: drive from Publisher, why? It keeps saying
khaganman <firstname.lastname@example.org> was very recently heard
> I do not have access to the D: drive from Publisher, why? It keeps
> saying "incorrect function"
Is the D: drive your CD drive?
Ed Bennett - MVP Microsoft Publisher
...Accessing my information offline
I have updated my Outlook to 2002 on my notebook computer
and when it is connected on the Lan at my office(new
ethernet connection) I can see my calendar, addressbook, e-
mails etc. However, when I disconnect and bring my
notebook home, and try to access calendar, etc, it says I
must sychronize while I am still connected to the Lan.
My previous version of outlook didn't have this problem. I
synched it on the Lan and it worked. This one won't.
How do you have your folders marked for Offline use under
Milly Staples [MVP - Outlo..."x" button enables deletion.... can we put a focus trigger there?
on three forms, I put focus triggers on the "delete" button because I need
to validate some additional data before allowing the user to delete.
However, if the user clicks on the corner "x" button to close the form and
gets the dialogue box saying they have changes, do they want to "Save",
"Delete" or "Cancel", they can delete the record anyways. Is there any way
to put a focus trigger on the button of the dialogue box, or on the "x"
Thanks in advance.
I assume you are working with Dexterity.
To work with an add...too many "inherited" custome headers and footers
It seems that somehow I have "inherited" custom headers
and footers from someone else's workbook. They have
filled up almost all the allocated spaces in the drop-down
selection list and pre-empt me from adding more than two
custom headers/footers of my own. I need to add at least
four new custom headers to the list.
Is there some way to delete all the "inherited" custom
headers and footers?
...CRM 4.0 Custom Report Filter Problem
I am using the Report Wizard to create a simple report.
Report is using Quotes and Quote Products
I have a custom field in Quote Products which is a bit field Yes-No
When I use that field as a filter for report output, I get all records. The
filter criteria appears to be ignored
Is this an inherent problem with Report Wizard or Am I doing something
depends on your business logic and what you want to see.
If you have three quotes:
Quote-1 has three products, all with the custom field set to Yes
Q2 has three products, two set to Yes, 1 to No
Q3 has three products, all set...Customizing Excel's Border Defaults
I'm working with Excel 2000 and use Borders frequently.
The preset default border is a thin line, yet I prefer
and always change it to the thick line. How can I change
the Excel default to the thick line rather than the thin
line? I know it's a small problem, but it's driving me
crazy changing it all the time. In WORD, I know how to
easily "add style default to template", but can't figure
it out in Excel. Any help is greatly appreciated!
...Can't upgrade companies to SP4
R [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error: Column name or
number of supplied values does not match table definition.I had a base
installation of GP 9.0, no patches. Decided to download SP4 and install.
Install of the MSI went fine and upgrading the master databases worked, but
going company by company, I get the following error:
The following SQL statement produced an error:
CREATE Procedure SVC_POP_Make_PO( @PromisedDate datetime, @OrderedBy
char(15), @BatchNum char(15), @ItemNumber char(30), @VendorItemNumber
char(30), @LocationCode char(10), @Uo...Can't receive EMail #5
Keep getting this pop up along with 'server did not
connect within 60 seconfs, do I want to wait
A time-out occurred while communicating with the server.
Account: 'Richard', Server: 'pop.east.cox.net', Protocol:
POP3, Port: 110, Secure(SSL): No, Error Number: 0x800CCC19
Please reply using email@example.com
please read this information from Microsoft
Ich habe nichts gemacht, gestern gings noch!
Bitte in den Newsgroup antworten damit jeder etwas davon hat.
Bravestar@Datenschutzminis...Program Trying to Access Email Addresses #3
Outlook 2002. When I try to create new mail, forward, or
reply I get a dialog box telling me:
A program is trying to access e-mail addresses you have
stored in Outlook. Do you want to allow this?
If this is unexpected, it may be a virus and you should
How do I determine what program is trying to access the
Outlook addresses? I have up to date Norton Anti-virus
definitions and have done a system scan, with nothing
Thanks for the help.
...Can you create custom activities? MSCRM 3.0
Is there a way to create a new custom activity instead of customising an
existing one? I have created a custom entity called 'Chat' utilising an
IFRAME. All works well but this entity really should be an activity
considering it's properties.
In fact I've just been introduced to MS-CRM 3.0 and don't really understand
what the difference is between an entity and activity. Would anyone shed the
light for me?
BTW, I think 3.0 looks great. Gotta admit it's improved.
In my experience, you cannot create custom activities. In fact, I have been
dire...Office 2004 issue with documents NOT BEING ABLE TO OPEN APPLICATION, but application can open documents.
Just migrated all my files and apps from a G4-400 to a new Mac Mini
1.87ghz Intel running pre-installed OSX10.4.10.
Used CD to install 'normal' version of Office 2004 Mac on the new Mac
Mini. In fact its the same disk that I used originally to install Office
on the G4-400.
Neither old .xls and .doc documents (made on old Mac, nor new .xls and
..doc documents (made on new Mac)will not open their respective
applications, when clicked upon.
However, when I use either of the the application's "Open" feature,
theres is no pr...