Query as Pop Up, is it possible?
Is there an option, or how can I run a Query as Pop up mode?
What I want is that the user can see the results in Crosstab query but I
want they do not have access to see the query in design mode neither make
I would like a pop up query but not a maximized window and the only option
that the user can see is the Close Botton, and another button to print the
query, is it possible?
Note: using sub-form does not work since in the crosstab appear some main
field that when the sub-form was built they were not there, and this cause
the sub-form show an error because th...Query Question
Please see the sql code below. What I am after is Sum of [RiskCount].
But due to the join, I get double counting and consequently wrong SUM.
Is this an inherent limitaion of Sql? Can be it solved without
breaking up the sql into two parts? Thanks for reading this post.
CREATE TABLE #Location (
CREATE TABLE #Coverage (
INSERT INTO #Location VALUES (1,1)
INSERT INTO #Location VALUES (2,1)
INSERT INTO #Location VALUES (3,1)
INSERT...Help Me Convert Fraction
I'm trying to customize a worksheet to read the fractions such as 14/16 as
7/8, 4/16 as 1/4, 8/16 as 1/2 etc. Can this be done and if so, does anyone
out there explain to me how to do this? I'm using Excel2000. Thanks!! CB
Take a look here:
In article <firstname.lastname@example.org>,
"Charlie Brandon" <email@example.com> wrote:
> I'm trying to customize a worksheet to read the fractions such as 14/16 as
> 7/8, 4/16 as 1/4, 8/16 as 1/2 etc. Can this be done and if so, does anyone
> ...Query runs faster with fewer parameters
I have this query I'm running for a client. I changed the select to select *
to make things clearer. The problem is the last line in the where clause -
down at the bottom:
FROM ihs_charge_accession_key ak
join IHS_Charge_Accession_File a on ak.Billing_Enc_ID = a.Billing_Enc_ID
LEFT OUTER JOIN IHS_Charge_Demo_MSH m ON ak.Billing_Enc_ID = m.Billing_Enc_ID
LEFT OUTER JOIN IHS_Charge_RTF_Stage r ON a.accession_number = r.
LEFT OUTER JOIN IHS_Charge_Header ch ON ak.Billing_Enc_ID = ch.Billing_Enc_ID
and a.accession_number = ch.accession_number a...saving a converted lotus file
When I take a Lotus 123 file and save it as an Excel file
and then open the file in Excel, Excel opens the file
twice. In the title bar is says name.1 and name.2. Why
There are two windows open of the file.
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
"Pam" <firstname.lastname@example.org> wrote in message
> When I take a Lotus 123 file and save it as an Excel file
> and then open the file in Excel, Excel opens the...Does excel 2008 support color text in headers and footers?
Operating System: Mac OS X 10.6 (Snow Leopard)
I'm trying to apply text colors in a footer in excel 2008 and there doesn't seem to be an option to do so. I don't believe i've ever attempted this before, so it's possible that it's the expected behavior. Thanks, <br>
No, character formatting in all versions of Excel � Windows or Mac � has
always been very restrictive. I believe Excel 2007 offers more options, but
that is the only version which does.
On 1/13/10 2:48 ...convert concencated field to date
Concencate a number of imported fields into a date - Is is not possible to
import the fields as a number. Basically these are the date field from on on
I have tried a number of things
DOB: (TableName!Day & TbaleName!Month & TableName!Year)
DOB: Val((TableName!Day) & Val(TbaleName!Month) & Val(TableName!Year))
DOB: #Val((TableName!Day) & Val(TbaleName!Month) & Val(TableName!Year))#
DOB: ((TableName!Day) &"/"& Val(TbaleName!Month) &"/"& Val(TableName!Y...convert
Is it possible to convert an excel file into a word file?
> Is it possible to convert an excel file into a word file?
You can imbed an excel file into a word document, otherwise no not as
such. You could save the Excel file as text and then open in Word. Why
would you want to? Excel is not a word processor and Word is not a
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
to email me remove the obvious!
...How create Autonumber field in code?
With help from this group, I recently got this code to work:
sqlStr = "CREATE TABLE tbl_urgencies (" & _
"urgencyID INTEGER NOT NULL, " & _
"urgencyDescription VARCHAR(31), " & _
"urgencyPriority INTEGER, " & _
"PRIMARY KEY (urgencyID))"
I then opened the database which I had just created from code. I
opened the table in design view and noticed that field urgencyID is
type "Number", not Autonumber. Isn't it preferable for this to be
Autonumber? Wha...format a formula to general (not text)
I am importing a text (.csv) file into excel and formatting it via a Macro.
in one column I have to insert a formula but when I do so, the formula is
showing, i.e. "=TRIM(Z4)". I have tried to format to "general" but it
doesn't work unless I click inside the cell and press enter. How do I apply
the "General" formatting without have to manually click inside the cell? I
want to do it in my macro.
Here is my code:
ActiveCell.Formula = "=TRIM(Z4)"
Selection.NumberFormat = "General"
Tempe, A...Query to Count "0" in Row
I am trying to create an expression in a query that says if
CONTRIBUTION BEGIN year is less then 2006 and the AUTE2 = 00/00/00
then count the number of "0" in the rown and multiply that by 58.
This is what I had thought up so far, but I know it isn't right.
CONTRIBUTION DUE: IIF([CONTRIBUTION BEGIN], 'yyyy' <2006, AND AUTE2 =
00/00/00, Count "0" And Multiply by 58
Any input is greatly appreciated.
What kind of data type is being stored in your [AUTE2] field? If that is
supposed to be a date, I don't think Access considers #00/00/00...Graffic converters
Hi i have scanned in some photos using canon D1250u2f
scanner and have saved them as jpeg. When i am in
publisher and use the insert picture from file it tells
Publisher cannot convert this picture.This is because
either publisher does not recognise the format, or there
was an error loading the graffic converter.So on and so
on..... I have reloaded all graffics filters and am still
unable to insert this picture into publisher. Any ideas
whats going wrong? I have downloaded the latest drivers
for the scanner but do not want to spend hours downloading
all the office updates. Is th...field Null but not Null
Don't really know how to explain this, but here goes. Have a table
with fields [BLOCK], [NUMBER], and [ALPHA]. [ALPHA] can be null.
These are concantenated together to form Acct# (block & "-" & number &
alpha). Example, 9-152 is different account from 9-152G.
I append block billing charges to a temp table for review, and then
post (append) those charges to transaction table. But, here is
strange thing. When I run a totals query, sometimes there are two
records instead of one.
For example; acct# 9-152 might show as:
9-152 ...convert HICON to HBITMAP
I am trying to convert an icon (already loaded by LoadImage), I have its HICON to a bitmap (HBITMAP), but I don't how. I CAN'T use GDI+( tried do with Bitmap class with the constructor and there was no problem), but I must use GDI.
Thanks to all.
HDC hdcScreen, hdcBitmap;
int x, y;
x = GetSystemMetrics(SM_CXICON);
y = GetSystemMetrics(SM_CYICON);
hdcScreen = ::GetDC( m_hWnd );
hdcBitmap = ::CreateCompatibleDC(hdcScreen);
hbmpBitmap = CreateCompatibleBitmap(hdcScreen, x, y);
Re...Convert uppercase to lowercase
Does anyone have a bit of code to convert a file of conatcts all in
UPPERCASE to Lower Case?
Mervyn Thomas;593677 Wrote:
> Does anyone have a bit of code to convert a file of conatcts all in
> UPPERCASE to Lower Case?
For each cll in selection.cells
cll.value = lcase(cll.value)' either this line or the next
'cll.Value = Application.WorksheetFunction.Proper(cll.Value)
p45cal's Profile: ...Limit on length of predecessor field issue
We are using MS Project 2003 (but this happens in 2007 also) and are using
the master/consolidated project function. We have inserted about 13 sub
projects and there are many (thousands) of links between the plans. Because
we're linking between plans, the predecessors & sucessors fields show the
path of the subproject being linked to/from. The plans reside on a shared
drive on a server and so the paths are long. Therefore after 2-3 links on
one task, the field doesn't show all of the predecessors (or sucessors), it
just inserts a "..." for each additiona...Sort order on Calculated query field
I tried to change the sort order on my report but now it prompts for a
parameter. It is because the field I am trying to sort on is a calculated
field. If I try putting the sort order in the query on this field it errors
with 'This expression is typed incorrectly or too complex to be
evaluated...'. I know it is because I am using aliases in the query instead
of the full calculation (nested queries) but it is quite complicated and I
am not sure how I can produce the correct data in a different way so the
sort order works? I didn't design the database, I have ...How do I convert cc's to a distribution list group?
I have received email as part of a 40 person cc and want to create my
own distribution list of those other cc's so I can originate messages to the
group (and not just use the 'reply all' key). Is there a way to move the
cc's from the header of an incoming email directly into a new distribution
group with out having to first make each of them a separate contact and then
move the contact into the distribution group?
Any help would be GREATLY appreciated.
Howard M. Rensin <email@example.com> wrote:
> I have received email as part ...Sorting by number in a non-numeric field
Hi guys.. so question..
Say I have a row with example:
Desired result from a sort..
Now how do I get there? :P
kronik's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31541
View this thread: http://www.excelforum.com/s...Convert DST to STD Time on the Fly?
For a database in the U.S. that sees a lot of analysis, I've
decided that a little reduncancy is a good thing.
Our field crews record DST when it is in effect, but our
analysts would usually like to use Standard Time. So I've
decided that it's better to have a field for each, and have
the form code do the conversion at data-entry time.
But I've taken several runs at coding this, and always get
to a point where I realize my approach isn't going to work.
I'm guessing others have preceded me.
Anyone care to throw something in here?
Instead of saving...Field Privacy
I have a database that I need the SSN number for employees as the key. I
want to make it so I can input the SSN number when I add an employee but make
it so others that need to veiw the database can not see the number.
How can I do this?
It's going to be pretty much work if the SSN must be hidden from all other
Also you won't be able to use it as the primary key field. Note: using a SSN
as the PK is a bad idea anyway. What happens if you have an employee who is
not a US citizen and therefore doesn't have a SSN?
1. You'll need to implement user...graph displayed in ascending order of value?
I would like my graph to shows values in ascending order
on the x-axis. I know how to do this manually however as
the values change on a weekly basis I would like the
graph to autoimatically do this for.
You can do this on an XY chart. On the format axis menu, you can change
the scale to display the values in reverse order. If you are using
something besides an XY chart, please let us know.
"firstname.lastname@example.org" <email@example.com> wrote in
> I would like my graph to shows ...Not able to find pdf converter option in Outlook meny
Have installed Adobe Acrobat standard ver. 8 but still not able to find the
PDF converter option in Outlook meny
If it causes a problem with Outlook, it will be disabled. You will have
to re-enable it in Add-ins.
> Have installed Adobe Acrobat standard ver. 8 but still not able to find the
> PDF converter option in Outlook meny
...sum a field value in all querys
How do i sum a value with another field (always the same one) in all my
Later, i would like to change that value to see the result in all querys.
How do i do that?
Please explain me best you can do cose i'm not an expert on access.
Tks in advance
What is the data type of the other field (always the same one)?
The value you wish to sum it with - what data type is it?
For example: if you had a query where one field was called rating and it was
a long integer, if you wanted to add the value 4 to this you could create a
calculated field in the que...Filtering a Crosstab Query from Combo Boxes on Unbound Form
I have a crosstab query in my database that I would like to filter based upon
user selections from combo boxes on an unbound form. I would like for the
users to be able to make a selection from four combo boxes (cboSelectWeek,
cboSelectMonth, cboSelectGroup and cboSelectFocal) and then push a button to
see a crosstab query reflecting their selections; I would like for the query
to export to excel and be saved as a file of the user's choosing. Also, the
user should be able to leave some of the combo boxes null.
I have been reading on this site (which has taught...