Clistctrl on NT4 throws out of memory error
My App is developed with MS VC++ 6.0 and it works fine almost
I access an mdb database to fill some listboxes (used as a search
engine) and a list (CListCtrl). I found a machine running NT4 that
fills the listboxes but it does not fill the clistctrl. I get an "out
of memory" error when trying to fill the list with data. Can it be
some flag (for example LVS_FULLROWSELECTED) or the one for displaying
the grid, or the imagelist connected to the list, or the LVITEM that I
add every row. It seems that some operation is not supported on that
system. What can it be?
Pleas...Crystal Reports-totalling a Summary
Have a question on totalling a summary field in Crystal Reports, I am using
the Minimum, Maximum and average functions to summarize purchase order line
items for a bill of materials. I would also like to total these min, max
and averages for all the items on a bill of materials but I cant figure out
how to make crystal do this.
maybe it isnt possible? I get the message that I cant total on a running
total field or summary field.
Doug you may want to go on over to
http://www.tek-tips.com/threadminder.cfm?pid=149 I go to this forum and
others on tek-tips....calculated total in query
I have 2 fields in query. Qty1 and Qty 2. I added Total:qty1+qty2.
However, if qty1 has some number but qty2 is blank, my total is blank,
instead of just show the sum.
You need to use the NZ function to force a ZERO. Or use an IIF clause.
Total: Nz(Qty1,0) + Nz(Qty2,0)
Total: IIF(Qty1 is Null,0,Qty1) + IIF(Qty2 is Null,0,Qty2)
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
> I have 2 fields in query. Qty1 and Qty 2. I added Total:qty1+qty2.
> However, if qty1 has some number b...Time Sheet
I have a time sheet with four fields:
Time In (C2), Lunch Out (D2), Lunch In (E2), Time Out (F2)
I'm trying to create a formula in cell G2 to calculate the regular hours and
another formula in H2 for the overtime hours, but have been unsuccessful.
Current fields are formatted as Number | Custom | h:mm AM/PM for C2 thru F2
and are formatted as Number | Custom | h:mm for G2 and H2.
Can anyone help me.
Look into CPearson Web it has all the working with overtime Hs
> I have a time sheet wi...Quick Print issue
We are having an issue when using the Quick Print Setup. In general we
have three main sites (which are named X, Y, and Z) with a printer
defined for each site (using the Named Printers utility). When
printing the pick tickets we specify to print separate picking ticket
per site (each site has its own printer).
If we do this printing process manually we get each picking ticket in
its corresponding printer (per site). To make things easier we decided
to use the Quick Print in this process. When using the Quick Print,
only the pick ticket associated to the X site is being printed in the
X site ...Printing Labels using Access 2007
I am trying to print address labels on an Avery sheet (3 columns by 7 rows),
but all I can get is 1 label per A4 page. Can anyone suggest a solution
Have you tried the Label Wizard in the Reports?
Reports | New | Label Wizard
It lets you select from among the various Avery label types and
automatically configures your columns correctly. Once the wizard has done
its thing, you can go in and tweak the format of the labels.
"Robert" <email@example.com> wrote in message
>I am trying to...print copies at printer instead of sending multi-copies to printer
Does anyone know how to send 1 copy of the page to a hp color laser and have
the printer itself make the copies to save time / bandwidth. I noticed that
it was sending a new copy of the page for each copy.
...Different Total for end of day sales report
I am currently using RMS 1.2 on a Windows XP/SP2 computer. My problem is
when i run various reports at the end of the day like Tender Summary and
Detailed Sales report to see the total sales for the day, neither one matches
my physical count. Can someone explain to me why i am getting this kind of
result? And what i can do to correct it or get the right information? Or
maybe i need a custom report to get an accurate total?
Thank you in advance.
Tender summary and detailed sales reports will have different totals since
one (tender summary) includes all monies taken in, including taxes,...Two types of crash in XP?
I'm trying to track down a very intermittent bug in an MFC application.
When the error occurs it says something about a memory address and
there's an OK/cancel button (not seen the error for a while so I don't
recall exactly - possibly "unhandled exception"). Yet when I put code
like this in the app -
char *p = 0;
*p = '1';
I get the "product.exe has encountered a problem and needs to close.
We are sorry for the inconvenience." dialogue and get the option to
send something to Microsoft.
Why do I get that dialogue for my simple test code and so...How to display the TOTAL of a sub form on the parent Form?
on my sub form (subDetails) I have a totals column.
I then Total the totals column in the footer of the subform in a field named
I want to display that total on the Parent form (frmOrders)
(I do not want to just show the footer of the sub form due to placment
So on my parrent form I have a text box with this code in the control source
BUT all I get is "#NAME?!"
I have doubled checked my spelling.
Am I going about this wrong?
Any help here will be appreciated.
Thanks in advance
On Fri, 24 Aug 2007 10:38:35 -0700...Force Report Footing to print at bottom of page
I'm using Access on Office XP Pro.
Is there anyway to force the Report Footing (not page footing) to print at
the bottom of the current page.
Currently, the report ends 10 lines into a new page, so the report footing
start printing on line 11.
I would like it to print at the bottom of the page. Is there anyway to do
On Tue, 2 Feb 2010 12:38:03 -0800, Dennis wrote:
> I'm using Access on Office XP Pro.
> Is there anyway to force the Report Footing (not page footing) to print at
> the bottom of the cu...How to include the Grand Total Column in a pivot table chart?
Hi, I have a simple pivot table with two columns A and B against several rows
of responses. The pivot table also shows the Grand Total Column.
I can graph the pivot table quickly and simply with the chart wizard (a bar
chart in this instance) and it will display a bar for column A and a bar for
B grouped per row response. Great.
I want to add what is effectively the third column in the pivot - Grand
total column, so I would have 3 bars per row response; A, B and Grand Total.
I can then compare A and B to the total bar.
How do I add/show the grand total in the pivot chart?
Yo...Binding two table into one Crecordset
I am trying to bind two tables in a database into one recordset.
I have added all the Column and Binded them with Class wizard
and have added the Games table to the GetDefaultSQL() method and
the filter to the set object.
When I run the program it tells me that I have:
Attemped to scroll past the end or before beginning of the data.
This the section of my code that I added the filter to. it is in my
OnInitialUpdate for my recordview
m_pSet = &GetDocument()->m_leagueManagerDBSet;
m_pSet->m_strFilter = "Teams.Teams_ID = Games.ID";
G...How do I split a column of information into two?
I have a column of information that I would like to split into two columns.
Mr John Smith (firstname.lastname@example.org)
Mrs Katie Brown (email@example.com)
I need to put everything in the bracket into a new column!
Can anyone help?
One way, assuming data as posted in A2 down
In B2: =LEFT(A2,SEARCH("(",A2)-1)
In C2: =RIGHT(A2,LEN(A2)-SEARCH("(",A2)+1)
Select B2:C2, copy down as far as required
"Nigel" <Nigel@discussions.microsoft.com> wrote in message
I want to convert a booklet to a pdf for online viewing. I want it in
numeric sequence instead of the sequence needed to be published by a
PTA Mom <PTA Mom@discussions.microsoft.com> was very recently heard to
> I want to convert a booklet to a pdf for online viewing. I want it in
> numeric sequence instead of the sequence needed to be published by a
> commericial printer
Change the paper size in your PDF application to the size of one individual
page, then set the Page Setup to Full Page.
Ed Bennett - MVP Microsoft Publisher
Thanks. T...Print preview look different than the page I am creating
I created a poster on a page 8.5 x 11. I use a background gray that fills the
entire page. When I select Print Preview, there is a white border around the
page. Why is this and how do I get rid of it? Is this just to frame my poster
and doesn't it print on the page? I'd like to know before I print because
this will use up a lot of ink that I don't wish to waste.
"DTravz" <DTravz@discussions.microsoft.com> wrote in message
> I created a poster on a page 8.5 x 11. I use a background gray that fills
Formula to count if two conditions. I want to count column b when = "CAS"
and if the number in column J is a negative number.
I have tried =COUNTIF(B7:B21,"=CAS")=SUM(J7:J21,""<0)
but it returns a "false" read.
Column "b" are all words and Column "J" is numbers, but sometimes a negative
number and I only want it to count if it is "0" or Less (negative)
Gary''s Student - gsnu201002
> Formula to count i...Postscript Printing Problem
Until yesterday I was able to print all my Publisher documents just fine on
my Okidata 5151N printer. Now for reasons unknown to me I keep getting a
($*)#& message saying my printer doesn't support the version of Postscript
required by the program.
What I've attempted to far:
- Uninstall and reinstall the print driver.
- Checked settings in printer preferences (there are no Postscript options
- Experimented with different printing and color settings in Publisher.
- Printing a new, blank document from Publisher.
- Downloaded/installed latest Office updates...Print Outlook Calendar with an Excel form on back of same sheet
I work for a large company where all employees print two forms everyday. One
is their Outlook calendar and the other is an Excel Form used to collect data
during the completion of a daily process throughout the day.
I would like to automate the printing of these two forms by combining them
into a single print function with the output resulting in their Outlook
Calendar Daily View on the front and the data collection Form on the back of
a single sheet.
I've tried exporting my calendar data into a sheet in the Excel workbook,
but formatting the schedule data to look graphi...Printing right to the edge of the page without borders???
I have an image that I need to print to the exact page size (A5). I have
changed the image dimensions to match the page dimensions but when I print it
keeps cutting part of the iamge off?? Does anyone know how I can fix this??
> I have an image that I need to print to the exact page size (A5). I
> have changed the image dimensions to match the page dimensions but
> when I print it keeps cutting part of the iamge off?? Does anyone
> know how I can fix this??
Maybe your printer doesn't print
full bleed (edge to edge)?
"How to find ...How to pause or resume a new print job on print server?
I need to write an app to take control of the printing process to enforce
some security policy.
My app running on network printer server needs to be actived as soon as a
new print job comes in. It checks the ip address where the new job is from
and blocks some special users.
Can I call OpenPrintProcessor and ControlPrintProcessor for the default
processor: WinPrint? How to trap a new print job?
Any ideas or code samples?
Thank you very much in advance.
...Payable not match to total vendor ballance
What is possible reason account payable does not match to total of vendors
1. a gl batch was deleted before it was posted.
2. someone posted directly to the gl account and not through payables.
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
> What is possible reason account payable does not match to total of vendors
As Richard stated, there are a num...passing data between two databases
I want to pass a value from one database system to a text box field of a form
in a seperate database system. Is it possible and how would I do it? Any
help will be appreciated. Thanks
Are you asking if it is possible to reference one form to another form in
seperate DB's? I don't think that's a desirable solution.
1. Why not use a linked table where you can reference from
2. Export the value by passing it through via Append Query which references
the other DB. You could create an empty table in that referenced DB and place
the values there.
"Justin" wr...Two Reports into one pdf file
Is it possible to output two different reports into one pdf file, and
if so, how
Thanks in adavance.
I cannot believe that GP10 does not allow the user to reprint a range of
invoices. This should be basic functionality. Many times invoices get lost
and the customer wants you to reprint them. We are in the process reprinting
over 200 invoices and we have to do this an invoice at a time. You should
be able to pull up a form that lists all of the invoices and you should be
able to check or toggle each invoice you want to reprint. Its not that hard.
I hear you, however, if you can actually use the Sales Order Processing
Document Inquiry window or the Sales Inquiry R...