Query That Pulls Multiple Businesses
I have a single table that my query is built from:
In my query I can pull a single line of business name by using this:
Like [Enter Name of LOB] & "*"
What I would like is the abililty to pull multiple lines of business in the
...How do i create a calendar with M-F as the main days
I am creating a school calendar. I have several things for M-F - nothing on
Sat/Sun. I need the space - how do I make S/S the smallest days - just the
date actually without making the rest of the days small? Can I move S/S to
the lRight of the calendar? How?
Resize the columns.
I have 2006 and 2007 Monday start calendar on my web site, Saturday and Sunday
are on the right. It is a no frill calendar.
Mary Sauer MSFT MVP
http://officebeta.iponet.net/en-us/...Append Query Not Working 02-15-08
I have an append query that has worked in the past but now when I run it I
get the long error message,"Microsoft Access can't append all the records in
the append query..." I have checked everything and cannot find the problem.
Since I cannot attach the screen shot of the error message, here is the SQL
code for the query:
INSERT INTO sick_history ( emp_no )
FROM ee LEFT JOIN sick_history ON ee.emp_no = sick_history.emp_no
WHERE (((sick_history.emp_no) Is Null));
Right now I need to add 80 records to the sick_history table and cannot due
to this error.
TIA,...Help with query calculation
I need a calculation to determine holiday pay.
I have the total hrs work*5.6/52 is the calcuation I use. HOWEVER if the
person works more than 39 hrs a week those hours have to be ignored.
So if someone worked say 50hrs how would I do the same calculation but
ignoring all hours worked beyond 39?
finally solved it using the IIF function
"Craig McLaughlin" <info@NOTHANKS.discoverymedia.co.uk> wrote in message
>I need a calculation to determine holiday pay.
> I have the total hr...How to Make Table query create a Yes/No field
I have a query which will make a table which will then be used in a form
for some data entry/manipulation. I want to put a couple of Yes/No
fields in that table, filled with "no."
I can set the property of the field in the design grid to yes/no.
The field itself, I have tried:
The first generates an error, The second generates a text field, the
third generates a number field. How do I generate a Yes/No field?
consider; instead of a MakeTable query use an AppendQuery; you can then
premake your table with the field property be...create email button
Several years ago I received a tip on how to create a button that
would email a certain person. It went into the Standard email bar.
Unfortunately that .pst went with a hard drive that stopped working
one night about two years ago. I think I read it in a daily tip from
C-Net/Dummies or something like that. I cannot locate it, nor
replicate it. Basically it was like the "New" button, but it was to a
specific person. It could be a single button, or have a drop-down for
different addresses. If anyone knows what I am referring to, please
reply with location of the steps or paste the six...create chart with significant data in a column
I would like to create a chart in excel with data in a column but only want
the significant data used. For example, I have two columns - one with names
and the other with values ranging from 0 to 10 (the cell is blank). The
colums are long. I want a chart from these columns that only uses the cells
that have values in larger than 5. Is there a way to do this without me
going through the data and only selecting the appropriate cells?
An even better solution would be to reference a different cell for the
minimum value to use.
Select your data, go to the Data menu, select F...Pivot table to query data in a set range
I'm with a real estate company and we do a lot of analysis of properties in
specific price ranges. Is there a way in a pivot table to set filters by a
range of data? For example, I want to look at average days on market for
properties that are priced $500K to $1M?
You can do with Auto Filter.
> I'm with a real estate company and we do a lot of analysis of properties in
> specific price ranges. Is there a way in a pivot table to set filters by a
> range of data? For example, I want to look at average days on market for
> proper...Create and distribute add-in
I have some useful code in my normal template which I would like to convert
to an add-in and distribute to colleagues.
Users are a mix of Word 2003 and 2007.
Any help much appreciated.
For general advice, see
The act that makes an add-in is to store a template in Word's Startup
folder. The default location of that folder is the hidden folder
There are a few differences between Word 2003 and Word 2007 that could
cause problems for a macro that needs to ...Flicker problem while creating and destroying child dialog control....
i am facing a flickering problem while creating and destroying child
dialogs on a parent dialog. basically its a dialog based applicationb
with child dialogs, those appear & destroy on different buttons click.
I am placing dialogs on static control rect area. Child dialog create
and destroy well but there is flickering problem.
Child Dilogs have the following properties set:
Border: Dailog Frame
More Style: visible, control (tick means enable)
Extended Style: transparent (tick)
Could anybody please help me out
Thanks in advance...
Set the WS_CLIPCHILDERE...SBS2003 + ISA2004 + iPhone query
An accountant friend of mine has an SBS 2003 Premium server with ISA 2004.
He also has an iPhone.
He has two broadband lines at his home office, one for domestic use and one
for his accountancy business use.
So he has two separate LAN's, one home and one business...(bear with me) bot
fitted up for Wireless connections.
His business broadband line is faster and better than his domestic line and
he doesn't have to share that with his family.
So he tends to connect his iPhone to his SBS 2003 LAN as performance is
When he wants to watch certai...Grouping duplicate/nonstandardized names and addresses AND Removing the "First of" label when using the First Of option in queries
I may be approaching this the wrong way, so feel free to direct me
I am trying to group a list of duplicative data (names, addresses,
etc) that does not have a unique identifier, other than their full
name (which in some cases can be more than one person). I am trying to
do decent job of reducing the nonstandardized entries to a single
To do this, I am first concatenating and grouping by a short name
(such as the first four 8 letters of their name, plus their zip code),
using the left function. When I run a totals query, I group by the
short name, and use a "FI...Problems with Crosstab Query
This should be so simple, but I'm about to tear my hair out.
I have a crosstab query based on a table, left joined to a query which
selects distinct FYs from another table, so that all FYs will show as
column headings. Pretty standard stuff. The strange thing about this
is that the crosstab query returns a single blank record, in addition
to the records I expect. But even stranger is that, if I add a WHERE
clause to the query, the query no longer returns all the fields from
the left-joined FY query, so column headings which have no data are
Using Ac...WEb Query... help!
Using Office XP I am creating a web query that pulls down a <name>.ttx
file from a web page.
When I normally browse to the web page in IE and hit the link to this
file it only gives me the File Download box with the standard "Open
file from it's Current Location" or "Save this File to Disk" options.
I go into Excel and do Import External Data from the Data Menu and
select New Web Query. I browse to this site and try to get it to import
the *.ttx file. When I click on the link for that file it again gives
me the "Open file from it's Current Location&qu...Queries
Is there a way to lock a column width in so that when using a
query-based spreadsheet, the column isn't resized each time the sheet
I answered my own question. From excel you can modify the data range
properties. One checkbox was checked "Adjust column width". Uncheck
it and voila, no more column width changes.
I happen to be sure my column data won't exceed given widths - a note
to any who use this particular fix - if your data is wider than the
column and you've specified not to adjust column width, the column will
only show partial data.
<shrug&...Publisher 2007 will not open up after hitting CREATE.
I have tried all the previous suggestions:
Is it possible that it is a "bad" install? Would i need to receive a new set
Can you open a Publisher file by double-clicking it?
If you can disable the *Getting Started" menu. Tools, Options, uncheck *Show
Publication types when starting Publisher.*
"Kurt P." <KurtP@discussions.microsoft.com> wrote in message
>I have tried all the previo...Creating and using a GUI thread
I need to update a control 20 times a second (its a graph control).
I want to place the control into a separate GUI thread what simply spins
and updates the control on my dialog.
How can i do this? I have a class that does the updating and data
handling etc, but when i write the data to the control, the GUI freezes
because its too quick.
Does anyone have an example code to update a control (progress bar for
example) in a separate thread?
On Wed, 19 Apr 2006 10:16:32 +0100, JoeB <email@example.com> wrote:
>I need to update a control 20 times...Creating delete query based on matching fields between two tables
I'm sure there's already one if not several posts for this but I couldn't
any. I have two tables both the same serial code field. I want to a basic
delete from tableA where tableA and tableB have matching serial codes. I have
tried just joining the two table by the serial code field in a delete query
but no matter how I try to go about it nothing works.
Thanks in advance for any assistance you can provide on this issue.
DELETE FROM tableA
WHERE tableA.SerialCode IN (SELECT DISTINCT SerialCode FROM tableB)
Doug Steele, Microsoft Access MVP
http://...How do I print query parameters on the report?
I'll try to keep this short. I have created a query with multiple
parameters. I want to print reports showing invoices to a specified customer
between certain dates. When I run the query, it is set up to enter the
customer name first, and then type the beginning date of the invoice period,
and then type the ending date of the invoice period. I have that part down
okay. When I print the report, I want the date parameters that I typed in
for the query to appear on the printed report. I created a text box in
Design View on the report, and for the Control Source, I entered the sam...Create new Activity Type
how can i create a new Activity Type such as "new fax" or ...?
Unfortunately, there is no supported way to do this. The best option is to
either "categorize" an existing type by adding a picklist or by re-using one
of the 6 types you are not using.
MVP - Microsoft CRM
"PIT" <PIT@newsgroup.nospam> wrote in message
how can i create a new Activity Type such as "new fax" or ...?
thanks for your post. I am new in crm. can y...Can Pivot Table views of a query be saved as a favorite?
....if so, how?
Have the query properties sheet visible (right click on an empty spot on the
top half, if not, or use the toolbar): the second property is Default View.
Specify the one you wish to get.
Hoping it may help,
Vanderghast, Access MVP
<firstname.lastname@example.org> wrote in message
> ...if so, how?
...Creating forms on the fly?
Hi there, hopefully somebody will be able to offer me some words of advice.
I am creating a database for a firm that deals with property insurance claims.
Creating a databse of relevant contacts etc ... is not a problem.
The current system that the company uses is that of an excel spreadsheet,
where the details for each room are recorded and relatively simple
calculations are carried out on this.
The details needed for each room are the same (ie height, width, damage floor
etc ...), the variation being for each claim being how many rooms.
My intention is to move the system comp...how to create new organization business unit
anyone knows how to create new database/business unit. do
i need to reinstall the crm server and select new database.
>anyone knows how to create new database/business unit.
>i need to reinstall the crm server and select new
Do you need a new Business Unit, or do you need to change
the Organisation name ?
ah..new organization name...like abc company...? may i
know what is the difference between organization and
>>anyone knows how to...Created 3-panel brochure; how to edit back 3 pages?
I created a 3-page brochure and edited the content of the three pages.
When I printed it, I got two physical sheets: the front three pages
and the back three pages.
I need to edit the content of the back three pages. How do bring them
up for editing?
BTW, when I find a duplex printer to produce the fully edited brochure,
I'll be in Publisher Heaven :-)
Thanks in advance,
Never mind; I found it.
I opened a practice session and, happily, it started with a brochure.
That example pointed out that it started with two pages. That made me
take notice of the littl...create a guid
How can I in VB. NET 2005, I can auto-generate a GUID number ?
The object browser can also help to discover available methods, classes,
"Mr. X." <nospam@nospam_please.com> a �crit dans le message de groupe de
discussion : ##GJIjdmKHA.4872@TK2MSFTNGP05.phx.gbl...
> How can I in VB. NET 2005, I can auto-generate a GUID number ?
> Thanks :)
I remember once I did that by some key combinati...