Setting random number range based on query, not table
I have a "quiz" form that randomly pulls up questions from my table. It
works fine, and I don't mind that it repeats questions. This allows me to
sit and review for as long as I want.
The problem is, that I want to use criteria in a query to limit the
available questions. If I base this form on a query and limit the number of
questions, the code I am using is still setting the maximum number as the
number of records in my table.
In the past, I had a similar database (which I have lost) that would open
the form, set the selector to the last record available to the form,...Unable to get DxgkDdiRecommendFunctionalVidPn call in windows 7
I am trying to add an initial vidpn topology by implementing the
DxgkDdiRecommendFunctionalVidPn call in the WDDM miniport driver.
But starting from windows 7 i am unable to get the
DxgkDdiRecommendFunctionalVidPn function call from dxgkrnl.After
searching through the MSDN documentation i found out that the function
is deprecated starting from windows 7.
msdn link: http://msdn.microsoft.com/en-us/library/ee220395.aspx
According to msdn
"On a computer running Windows 7, the display mode manager (DMM)
determines an appropriate VidPN topology to apply using VidPN history
d...Conditional Formatting #18
I am attempting to use the conditional formatting to color
code some cells, I want to say,
If C1 = 0 then highlight A1 in red, how would I do that.
1st: select "Formula Is" instead of "Cell Value Is" in
the left dropdown. The rest of the line changes to one
long textbox. Enter "=$C$1=0" (no quotes) then select
your format style from "format" button and "color"
dropdown. that should do it.
>I am attempting to use the conditional formatting to
>code some cells, I wan...Conditional formating #7
Need help figuring out a formula please.
If "date entered" in cell exceedes todays date by 4 days, then format
the cell background "Red".
Thanks so much for any help you can give.
Unplugged's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36751
View this thread: http://www.excelforum.com/showthread.php?threadid=564685
Use a formula of
where A2 is assumed as the first cell with CF
"Unplugged" <Unplugged.2bi5mq_1153833004...AutoFormat not working in Word 2007 in Windows 7
I have just installed the Office 2007 suite on Windows 7 Professional, 64-bit
edition. Almost everything works well, but I noticed that when I type
quotes, Word 2007 is not automatically converting them from straight quotes
to curly quotes.
I have went into the Word Options and tried the setting both ways, but it
makes no difference.
I have made absolutely no changes to this installation, and this problem
does not occur on my Windows Vista and Windows XP machines. The computer is
virus-free (I have an antivirus solution running, I don't go to shady sites
to begin with...Complicated conditional formatting
Here's a breakdown of what I'm trying to do...Employee scheduling
worksheet that is easy to read and follow. There are 5 functions
employees can have, each given a specific color via conditional
formatting. Each column represents a period of time during the work
day, each row a different employee. As it stands now, for the
duration that the employee will work, I simply enter a 1, 2, 3, 4, or
5 corresponding to their function, and it will color each cell with
The problem I run into, is in a separate sheet, I'm wanting to use
conditional formatting to apply the same c...Printing odd pages in booklet format
I used to be able to do this easily in PageMaker, but I can't figure it out
for the life of me in Publisher...
I am creating a booklet. Each page is 8.5 w and 5.5 tall (ie, half-letter,
landscape orientation). I'd like to print this booklet two pages to one
peice of paper, so I can cut in the middle and punch for a ring binder. I'd
like the target paper to be letter (8.5 x 11).
However, when I try to set it up as a book, I get a weird page that's
17x5.5. How can I change how the page is set up, so I can get both 8.5 x 5.5
pages to print in the correct orientation on the...How to keep display format when exporting XML?
First thank you for taking the time to read about my problem.
My problem is this.
When exporting my xml data, the time/date values loose their display
format. A time of 01:30 am, for example, becomes something like
0.001353 when exported..
What do I need to do to keep the same format as is displayed in Excel?
sure be great if you could help.
...Mail Rules #7
I have recently been deluged with emails marked "Delivery Status
Notification" or similar (maybe 20-30 a day).
Is it possible to create a rule in outlook which deletes all mails apart
from those addressed to specific addresses (e.g. abc@..com and zyx@..com)?
Also can this same rule be used in OE as I use that at home?
Tony <email@example.com> typed:
> I have recently been deluged with emails marked "Delivery Status
> Notification" or similar (maybe 20-30 a day).
Are these DSNs for messages yo...XP mode in windows 7
This is really a windows 7 question, but I could not find a windows 7
newsgroup...If there is one please tell me where to find it.
If windows 7 comes with XP mode, is there any reason to buy a computer with
"windows 7 downgrade XP" option (this means the PC comes with windows XP,
and an install disk for windows 7).
I may have some medical software that runs only in XP, or maybe not. Won't
know until I try.
Only certain versions of Windows 7 with supported hardware can use XP Mode,
the hardware must support virtualization. Also Win 7 doesn't come with XP
...Moving OE msgs to win 7 WLM?
Moving msgs and multiple subfolders from OE (current) to new Win 7 Home
Premium machine. Had to do this once before and had bigtime troubles! Want
to do it right this time. Can someone point me in the right direction?
Thanks for viewing...
Transferring data from Outlook Express to Windows Live Mail:
Copy the *ENTIRE* OE message store folder to a flash drive. (Folders.dbx
must be included). Place this on the Desktop or other location on the
machine using WLMail. Open WLMail and: File | Import | Messages |
Microsoft Outlook Express 6 and point to where you ...Date format of 0 and if statements
I have an is statment as such:
=IF('Raw Data'!A5=0,,'Raw Data'!A5)
This issue I have is when I format fields as "date" and the
reference cell = 0 excel formates the cell as 01/00/00.
I have also used the formula:
=IF('Raw Data'!A5=0,"",'Raw Data'!A5)
The issue I have is I want to create graphs of this data in
a dynamic fashion, but when the data range of the graph
encounters either "" or 1/00/00 as a date, it plots it as a
data point. I need a way to make my IF statment to produce
a BLANK or EMPTY cell. Is there a key word in...How to convert US date format to European
My computer is set up to use the European style dates (ddmmyyyy), not the
USA-style dates (mmddyyyy format). So if I enter "01/06/05" I get a date of
01-June-2005. However when I download some information in CSV format at
times that same date is formatted like this: "06/01/05". However this is
interpreted as 06-January-2005 in the spreadsheet. How can I convert the US
formatted values to European, in effect swapping the first two numbers?
1025 Osborne Rd.,
New Germany, NS, Canada
Rename the .csv file to .txt
File|open that .txt file...conditional formating in Access
how to use Max funciton for conditional formating in Access form
On Fri, 7 Mar 2008 01:43:00 -0800, sudyl wrote:
> how to use Max funciton for conditional formating in Access form
Max of What?
Select the control.
Click on Format + Conditional Formatting.
Select Expression Is
As the expression write:
[ThisControlName] = Max([ThisControlName])
Select the colors wanted.
Save the change
Please respond only to this newsgroup.
I do not reply to personal e-mail
...too many different formatting cells
I can't open an excel document because whem I try to open it says that too
many different formatting cells.
How to resolve this and open this document?
XL: Error Message: Too Many Different Cell Formats
A few people have said that OpenOffice.Org has been able to open the file. Then
they clean it up and save it there. Then excel can open that cleaned up
http://www.openoffice.org, a 60-104 meg download or a CD
> I can't open an excel document because whem I try to open it says that too
>...2 Formatting Questions
Can we, in the CRM forms, format dates to read into the “15 Aug 2005”
format? This is possible in reports, but by default, the forms use only
numbers for dates, but in any format.
Any ideas of how to track multiple currencies in the same application -
specifically USD and Canadian? I know a Microsoft CRM installation currently
supports one language. But aside from using a picklist to specify "USD",
"CAN", "MEX", or other I'm concerned about how their forecasting.
www.visalign.c...Conditional Formatting 12-16-09
with a text entry containing 2 different fonts, like "?" (Font Symbol), then
"Customers" (Font Arial), Conditional Formatting seems to apply only to the
first font element (?) whereas the second element remains untouched by CF.
Is there a workaround (so that the entry "? Customers" as a whole undergoes
Thank you in advance.
I have a spreadsheet with 79,000 cells of information in rows and
columns. On a separate worksheet I have 5,000 cells of information.
I would like any information in the first sheet that is in the second
sheet to turn to red.
Sheet1, column A
Sheet2, column A
I would like the two strings in sheet one which appear in sheet 2 to
turn red, leaving the middle string black.
Is there a way to do a lookup to compare the cell value to a range
using conditional formatting?
Thanks for any help.
-----...Using IF for conditional formatting?
Need help with displaying blank cells when formulas are
inside. The formulas would display a value if the
contents of a source cell is filled in. I'm attempting to
use in the formula cells(like B2):
If A2 is null, then display blank in B2, else calculate A2
Is this the best approach to keeping formula cells clear
until data is entered?
For everyone's benefit keep the discussion in the newsgroup.
"Barb" <firstname.lastname@example.org> wrote in message
news:fd0201c4...Conditional formating #20
I need help with conditional formating.
I need Row 30 to change colour when D30 is equal to a certain value. A
the moment i can only get the one cell to change colour :rolleyes
smith.james0's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1623
View this thread: http://www.excelforum.com/showthread.php?threadid=39022
Select the row. Enter:
CF1: Formula is =$D30 = "certain value"
Format1: Patterns/<changed color>
In article <smith.james0.1ssb2d...Text box and formatting?
I am working on class schedule and have one text box which spans a few
pages. Pages are double columns. I have a header for each class and
paragraph given for class description. On the last page, last column, one
description appears at the top with empty space for the rest of the column.
I would like to change the formatting of the text in the whole text-box so
that most of the last column is used.
I can select the text in the text box which expands over the few pages and
play with the font size, but that would mean that all the text would be the
same size. Is there a way that text...Formatting Chart Category Labels
I'm creating a fairly complex chart - a spider graph "dashboard" report that
addresses 4 major areas of an organization's performance - finance, quality,
efficiency and customer satisfaction. Each category has 4-7 data elements,
so that there are a total of 22 data elements on the chart. There will be 2
sections of the report, a chart showing YTD, LYTD and Goal values for the
data elements and the graph itself. I envision this as a relatively easy way
for management or board to get a snapshot of comparative key performance
indicators. So far so good - input form, c...conditional formating: ifs and highlighting rows
my spreadsheet documents error incidents, with each row showing the date the
incident was discovered (column A) and the date it was resolved (column I).
it also calculates networkdays (column J) -- unless column I=0 -- and
references an array of holiday dates on another sheet.
i would like to create a conditional format that will identify rows with an
incident, but no resolution date, then highlight the row and possibly even
show "unresolved" in column J cell of that row.
Well, you have to decide which way you want to go with this.
If you leave column J ...Which 'event' to run pivot chart formatting code on file open?
I have code to change my pivot chart type to a mix of line and column
also to refomat colours
I need to run the code so that the user sees the changes when the file is
opened Ive tried the 'workbook open' event and the chart activate event but
noy joy so far.
(Once the file is open, manualy triggering the code works perfectly)
I don't know why workbook_open doesn't work. You could use
Application.OnTime to run your code a short time (like 2 sec) after the
Jon Peltier, Peltier Technical Services, Inc.
http://Peltier...when I type a long number it shows up as smaller number and +
when converting from xls to csv format, some of my longer mortgage numbers
get condensed into a smaller number with a letter, a plus sign and another
number. example: 100020013120 turns into 1.0002E+11. Any way to get rid
of this? Thanks,
Yes, just specify the format that you want.
Format Cells...>Number>0 decimal places
"SandyC" <SandyC@discussions.microsoft.com> wrote in message
> when converting from xls to csv format, some of my longer mortgage numbers
> get conde...