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...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" <email@example.com> 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 to set Page Layout View as default when composing new eMail message?
I'm using Outlook 2003 (German) with MS Office Word as my E-Mail Editor.
When composing a new eMail message, default view is always "Normal". I would
like it to be "Page Layout" (or "Print Layout" in some Word version, I
I tried serveral things, from changing different templates (email.dot,
normal.dot, mail.oft) to changing the Form for messages. But I didn't find a
way to change the view here, because it's in Outlook style, not Word.
And I didn't find any setting in Word for it.
How can I change the default View?
And which templ...Assign a Tax Category to a Transfer
How do I assign a tax category to a TRANSFER transaction
Specifically, my paycheck is set-up as a split
transaction with tax withholding properly assigned to
various categories. However, my 401K contribution is
actually a TRANSFER to another account and should be
reflected as a reduction against my taxable salary. But,
this (transfer) contribution is not showing up in any of
my tax reports.
1) Categorizing a transfer is an oxymoron.
2) IF you have the transfer to 401k coming off the Before Tax tab of your
paycheck entries, I believe you will find that it *is* being ...converting tabular structures in a Word document into an actual table or reading data from the tabular structures using VBA code
I have a macro which can read the last cell/column of all tables in a
Word 2003/2007 document and store the data in an MS-Access table. But,
some Word documents have the data in structures like a table format
but are not actually tables. The structure looks like a table, but the
table borders are actually line connectors. These documents were
created by a software(VeryPDF PDF to Word converter) which converted
the PDF documents(the original format these documents were) into Word
1. Is there a way I can convert/replace the tabular structures with
actual tables in Word so t...Twist Data?...
I've got the following in a dataset:
19 30 1200 FI FI 20030906 36
19 30 1324 FI FI 20030906 36
and I want the following result:
19 30 1200, 1324 FI FI 20030906 26
Any guess on how to do this?
Not quite clear:
The data is arranged in columns, I assume
It looks as if both items in the same column are the same, you want just one
item, otherwise the one in the top row first, then the one from the bottom row.
But what about the last 36s that should yield 26? Typo?
Does the dataset have more columns or more rows or both? And how big is it?...moving payables data from open to history
A client says that someone imported data about a year or two ago into Great
Plains from their AS400.
Many payables documents that were imported should have been coded during the
import as open, instead of history. The client knows that she can take care
of this herself within two hours, by simply turning off the posting to the GL
and entering and posting the payables documents to move them to history.
But, she is wondering if there is a quick and easy way to do this on the
I'm familiar with the open and history payables tables within GP. And, I
know through a T...automaticly create graph
what i would like to do is create a spread sheet where by i entered the fixed
and variable costs as well as the selling price. i would then like a graph to
automaicly change and display the this info.
Does anyone know how to do this.
Decide which cells on the spreadsheet you wish to include in the chart.
Select those cells. Follow the menu option: Insert/ Chart, and answer the
questions in the wizard.
Have you looked in Excel help at the topics concerned with charts, starting
with "Create a chart"?
Have you looked at the training material under
http://office.microsoft.com/...merging 2 cells without losing data?
How can I merge 2 cells without losing data from the other cell?
Not possible I'm afraid. Try placing the dat from both cells into one
and use "Center across selection" under Format>Cells>Alignment
Merge cells always end up causing grief. they are best avoided.
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
"bob" <firstname.lastname@example.org> wrote in message
> How can I merge 2 cells without losing data from the other...disable Review toolbar which came up automatically when opening a.
How can I disable the Review Toolbar which comes up automatically when
opening a file?
In the Workbook VBA actions.
The top left hand corner there is an Excel logo, not the one in th
blue program bar, but in the menu bar.
Right Click and select "View Code"
There will be two drop down boxes one that will probably say General
if this has never been entered previously.
Change the box on the right to Workbook.
Then Change the right hand box to "Activate"
Insert the following code
Application.CommandBars("Reviewing").Visible = False
exit the VBA screen and t...Problems Converting Data from Quicken 2001 Deluxe to MS Money
I have a relatively new Compaq Desktop (2.5 GHz Celeron with 512 MB RAM).
I have a Viewsonic Pocket PC and I wanted to use it to track my financial
data so I purchased Money 2003 Standard.
I tried several times to convert my Qucken Data (it's a big file--I've
been using Quicken since 1995). My Quicken program is Quicken 2001
Anyway, the MS Money program started to convert and after a few minutes
"Your Quicken file could not be converted. Money could not convert your
Quicken file. You might have run out of disk space or system memory. Try
closing othe...Transformation of data into columns
I have the data from a flattened spreadsheet in a table in the
f1 f2 f3
period to: Scheme1 Scheme2
31/01/2005 Net Gross
28/02/2005 Net Gross
31/03/2005 Net Gross
30/04/2005 Net Gross
31/05/2005 Net Gross
30/06/2005 Net Gross
31/0...Smartlist Export to CSV
I've notice when I try to save a file as tab or comma delimited, it still
just comes out as a regular text file with no formatting. Only thing I can
do is export to excel and then save to CSV. Is there a problem with this in
Try exporting to Excel and then saving in whatever format you want.
David Musgrave [MSFT]
Senior Development Consultant
MBS Support - Asia Pacific
Microsoft Business Solutions
Any views contained within are my personal views and
not necessarily Microsoft...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
>...Trying to create an Update query based on HR data to find upline V
Hi All, looking for some advice. I have an HR table that contains employee
information but does not contain management chain info. Basically i am trying
to determine who the employees upline VP is. The fields i have to work with
are [Employee Name], [Manager Name] and [Job Title]. I figure the logic would
be to check the employees' manager and if the manager is a VP (based on job
title), return the manager's name to a field called [VP]. If the manager is
not a VP then check that manager's manager, so on and so forth until a VP is
Any ideas would be much appr...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...Filling Web Form
Dear freinds Hello,
I have written code in vc++ using MFC to fill the Webform using HTTP post
method and I'm able to fill the form but I'm facing a problem that I'm
unable to fill login name and password. So any one amongst you have any Idea
or help then please help me
...Data Validation List not showing
I'm using Excel 2003. My data validation lists have stopped working on one
sheet in my workbook. It is working on all other sheets.
I have googled the problem and found the following advice:
1. Make sure freeze panes is off.... check.
2. Select "Show All" under Tools->Options->View->Objects ... check.
The problem remains. Any ideas?
"Stopped working" doesn't do much to describe your problem. When you select
one of the "stopped working" Data Validation cells, do you see the drop-down
arrow to the right of the cell? When you select t...Add new record through Form view
I have a table which is linked to a form, i would like to have a command
button which will add a new record to my table.
On the click of command button it should view the last empty row of my table
in a form.
On Sat, 26 Dec 2009 11:11:01 -0800, Ranjith Kurian
>I have a table which is linked to a form, i would like to have a command
>button which will add a new record to my table.
>On the click of command button it should view the last empty row of my table
>in a form.
The Click event should show [Event Proced...Page up and Page down
Is there any way the you can use Code to cause a form to do page up and page
down. I have a Long form that some of the information that is at the bottom
of the form is out of view and only use by certain people.
How can I have a botton on click go page down to the bottom and another
button that will return the form to the top of the form.
I know that you can use the keys to accomplish this but for appearance value
I would rather use a button on the form to accomplish this.
You can put a Page Break control on your form.
Then, code on the Click event of your button...Investment Summary on Home Page
This is a multi-part message in MIME format.
Okay, I have had investments that I have sold completely within an =
account and purchased other investments. When I go to "My Money" home =
page, it will still show the old investment under the "Investment =
Summary", "Investment Performance" and "Best and Worst Performance" =
sections, along with the new investments. How can I clear out the old =
investments from...Set default address book automatically (registry)
I know I have done this before a few years back in another site - but
I cant remember how.
We need to set the default lookup address book for all our 2000+ OL2k3
users and to use a specific lookup order. I know they could each do
this manually but we have 2000+ users and the support overhead would
be huge. We dont want to users to use the GAL as their default lookup
(which it is out of the box) because it contains lost of confusing
system addresses and duplicate names for the same person in different
security level networks; which the users find VERY confusing to
We wan...Turn off automatic dialing
I recently reloaded Office 97 on my XP computer. Now the
computer is automatically dialing into the internet to
download email. I only want to dial manually.
I've run into this problem before but can not remember how
to set it to manual dialing only. Any ideas?
Check your mail profile - under the General tab: the
default connection state might be online and might be
checking for dialup networking. Set this to manual.
>I recently reloaded Office 97 on my XP computer. Now
>computer is automatically dialing into the internet to
>down...How do I freeze or lock cells to show up on each page without typ.
I have a 4 page sheet. I have a header already. But I want to freeze the
cells that head up the first page. I've done it before in school but can't
remember what it is called or how to do it...that's why I'm doing this.
Anyway, I want these cells to print off on each new page without having to
type them on each page. I hope that makes sense and I hope that someone can
If you mean for printing do file>page setup>sheet and select rows to repeat
otherwise for viewing you can select a2 if the headers start in row 1 and do
window> freeze panes
...Adding extra data options
Is there a way to customize CRM to allow for adding another heading? I would
like to add a second field similar to topic and would like to call it type.
Can you add extra data fileds and types in CRM 3.0?
You can add extra data fields to an entity. Go to entities customization at
> Is there a way to customize CRM to allow for adding another heading? I would
> like to add a second field similar to topic and would like to call it type.
> Can you add extra data ...