Round up a decimal in a query field
Hopefully this is an easy question. How do you round up a number in a query
field? Excel has the ROUNDUP function, but I can't find anything similar in
Access. Can anyone help?
Function:round([tablename!fieldname,2]) I think. It may be
> Hopefully this is an easy question. How do you round up a number in a query
> field? Excel has the ROUNDUP function, but I can't find anything similar in
> Access. Can anyone help?
Thanks Golfinray, but that only rounds to the nearest decimal place. What I
want is the numb...Displaying Counts when Filtering
Usually when using the filter function, the total records
in the spreadsheet and the number of records that match
the filter criteria are displayed on the lower left of
the window (I guess it's the status bar). However, for
certain files that I have, no counts are displayed when I
filter. Does anyone know if there is a setting in the
file that causes this or something else that needs to be
changed? I do notice this happens frequently with files
created by exporting from Access, but not always. It
also happens with other files, but I can't find a common
Hi To...Display text in Excel Bubble chart. #2
I have an Excel spreadsheet which contains X-coordinates,
Y-Cordinates, Well name and Cumulative Oil/Gas/Water
production. I have created bubble map using X,Y and Z(Cum
production). I need to show the well name on each Bubble,
which I am unable to do.
Kindly sugest method to display the well name on the
Rob Bovey's Chart Labeler (http://appspro.com) is a free addin that adds
text from the worksheet to data labels on a chart series. I just tested
it on a bubble chart and it works fine.
Jon Peltier, Microsoft Excel MVP
...Multiple instances of a property sheet
I have two windows as part of my application, say W1 and W2. They are
both derived from CFrameWnd. I have a class derived from
CPropertySheet that is instantiated/displayed by both windows. When I
create an instance of my property sheet (let's call it P1) from W1
(the property sheet is modal to W1) and then create another instance
of my property sheet (P2) from W2 (modal to W2), I cannot close P1 by
clicking OK or Cancel. Clicking OK or Cancel is completely
ineffective; the dialog remains open. Then, if I close P2 by clicking
OK or Cancel, both property sheets are closed.
I augment CProp...Required fields
I need to set up some VB code to alert the inputter that they need to
complete a couple of required fields depending on the value of a third field.
At present I have some code (below) attached to the BeforeUpdate event of the
form that checks for one of the fields but I need to extend it to the 2nd
field and I don't know how to.
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.[NYSPA Received] And IsNull(Me.Date_NYSPA_Received) And
Me.New_Cease = "New" Then
MsgBox "Date NYSPA Received is required" & vbCrLf & "Record will not be
saved&q...Outlook Multiple Profiles at the Same Time
I have two separate icons set up on my desktop to call
Outlook using /profiles switch for profiles A & B. I can
double click one for A, and it opens my POP3 account for
profile A. Then I close it and double click one for B,
then it opens my Exchange Server account for profile B.
The problem is if I don't close the one for profile A and
try to open the one for B, then even if the switch is set
to open profile B, it just opens profile A again. Can
someone tell me how I can have two separate Outlook for
two separate profiles open at the same time?
Adding POP3 to my Exchange S...Unable to display the folder error.
I get the following message when using Outlook. If I
close Outlook then reopen it, it will work until I switch
icons (calendar to contacts).
"Unable to display the folder. Microsoft Outlook could not
access the specified folder location. An error occurred
that prevented the file M:\Outlook\cij.pst from being
saved. Close and then restart all mail-enabled
Can anyone help me with this problem?
...Display Discount on POS screen
I've figured out how to remove REP from the main POS screen. I'd really like
to add Discount to the screen, so we can accurately display for the cashier
which discounts are being applied to which individual items. Any ideas?
Anyone got a third-party recommendation?
...How do I format a field based on the value
I have a form that is populated from a query using several tables. In the
detail section I have the following fields:
Category Code qty PO number ... .... ...
The qty is populated in the query based on whether or not a PO number is
available. If the PO number is not available then it comes from table a, if
it is available then it comes from table b.
On the form, I have my fields color-coded for easy reading. I would like to
be able to color the border and column heading based on where this value
comes from. If table A, then it is blue, if table b then it...Keep Added Custom Fields on New Projects
We are importing information from our bidding software. The export is
created in XML file. We know the custom fields that are created. How do I
make MS Project use the same "look" everytime? I want it to remember the
custom fields I created and use that as my default blank project. I don't
care about the tasks because those could be different every time. I just
want to be able to create each project with the same columns every time.
Create or update a view/table with the custom fields and layout you are
wanting. Then change the Tools-->Options--View tab to ...double display in the Watch view with VC++6 sp6
Since the install of Visual Studio service pack 6 the double display
in the Watch window of example before (with vc++ sp5) -7701.7701 give
in the window -7701.7701 now (with the sp6) in obtain -7701.7700999999997
Why is this an issue? It strikes me as a bit of concern over an irrelevancy. Floating
point isn't accurate anyway, so there is no particular reason to be concerned about
trivial differences like this.
On Wed, 30 Jun 2004 09:39:11 +0200, "Olivier" <firstname.lastname@example.org> wrote:
>Since the install of Visual Studio service ...how to retrieve varbinary field through ADO inVC++?
...delay in displaying cell contents
Is there a simple function that can delay the display of the contents
of a cell by a few seconds. I know that it can be done as VBA code
but I dont know how to do it.
Thanks in advance for any help.
have a look at the Wait method in the VBA help
"Dave" <email@example.com> schrieb im Newsbeitrag
> Is there a simple function that can delay the display of the contents
> of a cell by a few seconds. I know that it can be done as VBA code
> but I dont know how...Linked cells in Multiple Workbooks
I am tracking dates and have linked cells from another workbook so as t
not have to duplicate the data entry of dates. The dates are linked t
projects that are listed in rows and there is information in m
workbook that is additional information within the row. So if someon
changes the order of the other workbook, the information that is in m
workbook does not get sorted with the order. Is there a way to link m
cells to the linked cells?
Project ID Start Date Milestone
EndDate Person Assigned
1234 (linked) 11/15/04 11/20/04(lin...Enterprise server with multiple organizations
Organization has CRM 4.0 Enterprise version with three diffrent organizations.
When CRM user goes to meeting with their client, they want "the big picture"
of the customer data from all of three CRM environmets.
Is it possible to build report, that gathers data from multiple CRM
organizations within one Enterprise server? If so, how many licenses/user is
If you are creating a report using SQL Reporting Services I can see no reason
why you could not connect to the 3 database and get data from each. Not sure
how you would know which records ar...Multiple messages
I am receiving the same messages a number of times to my outlook express
mail box. Sometimes I have 5 or 6 of the same message.
Does anyone know why this is, or how I can stop it?
Thanks very much
Try posting this in an Outlook Express news group - this is not one of them.
Outlook is a part of Microsoft Office and is what this group supports.
Outlook Express is a part of Internet Explorer and has its own news groups.
You can also find some good Outlook Express information here:
Milly Staples [MVP - Outlook]
Post all replies to the group...Inbox display problem
My 4 year old got on my computer and now my email is only
showing the received column. I would like to have the
From and Subject put back in there. Don't know and can't
figure out how he did it. Anyone?
Frank <firstname.lastname@example.org> wrote:
> My 4 year old got on my computer and now my email is only
> showing the received column. I would like to have the
> From and Subject put back in there. Don't know and can't
> figure out how he did it. Anyone?
In addition to what Milly said, you can also reset the current view to its
Is there a way to use an IF or SUMIF function in a
calculated field in a pivot table? When I try, I get all
0s as the result.
Can you type a small sample of the pivot table layout and data, and
explain what you'd like to calculate with a SUMIF formula?
Jim C. wrote:
> Is there a way to use an IF or SUMIF function in a
> calculated field in a pivot table? When I try, I get all
> 0s as the result.
Excel FAQ, Tips & Book List
> Is there a way to use an IF or SUMIF function in a
> calculated f...Populating an IMAP "To:" field
I let this bug me for almost 2 years, but it *IS* Possible, as the
following points out (contrary to the lack of responses and denial
posted elsewhere in these microsoft misinformation forums):
For Outlook 2000/XP/2002:
For Outlook 2003:
1) Select the IMAP mail folder with the broken/empty "To:" field.
2) Go to the "Tools" menu and select "Rules and Alerts..."
3) Select the IMAP account for this folder (should be pre-selected)
4) Click the "New Rule..." button
5) Select the "Start from a blank rule" r...multiple selection
How can I select multiple records into a list box?
I want that for append identical records (for select records)
in another table.
Use a subform instead of a list box.
In a subform bound to a related table, you can append as many rows as
It is possible (but not simple) to use an unbound multi-select list box that
is populated in the Current event of the form, and executes Append, Delete,
and Update query statements based on the ItemsSelected if they are changed.
You will also have to find a way to respond to the user "undoing" changes.
Al...Xpath with multiple values..
Is is possible to use XPath with multiple values like in SQL Queries (AND
If I have xml:
Now I want only to select rows 1,2,3 an 100
XPath("rows/row[@code='1' and @code='2' and @code='3' or @code='100']").
I tryed like this above, but I got nothing.
Try using ORs all the way. An AND situation is impossible here...auto populating account id field
Does anyone know of any 3rd parties that already have this
customization? I'm wanting my account to automatically be
assigned an account ID when I transfer my lead to an
account and then have this ID be sent to Great Plains to
create the account in GP. I know CRM doesn't have this
function right out of the box, but I can't let my users
type in their own ID.
...Merging Multiple documents having different headers and footers ma
I am trying to merge a several word/rtf documents into a single word
documents with the below macro, the problem is now each document is having a
different header and footer and some fields,
Can anyone suggest me a macro code for merging multiple word documents into
a single document without disturbing the headers and footers of each document?
Dim rng As Range
Dim MainDoc As Document
Dim strFile As String
Const strFolder = "c:\tes\" 'change to suit
Set MainDoc = Documents.Add
strFile = Dir$(strFolder & &quo...Creating a list of info in A1 cell in multiple worksheets
How can I create a list of the info/contents in the A1 cell in multiple
worksheets? I am trying to create a summary worksheet of the data from 90
worksheets and would like to be able to list the headers in the A1 cell
'Right click on the summary sheet tab, and paste in this macro.
'Edit where appropriate:
'Starting row for summary:
i = 1
For Each Sheet In ThisWorkbook.Sheets
If Sheet.Name <> Me.Name Then
'Control What column to place data in
Me.Cells(i, "A").Value = Sheet.Range("A1").Value
i = i + 1...Possible to call Linux machine from MFC?
I've been searching for some answers to this online but it's really outside
my experience, which is mostly with MFC.
I'm trying to figure out if it's possible to call an executable that resides
on a machine running linux and pass both input arguments and get return
values from the linux executable. ( The hardware we want to interact with
is only accessible from the linux machine.)
TIA for any help or pointers.
> I've been searching for some answers to this online but it's really
> my experience, which is mostly...