easy way around "not updateable query" for sums?
I have a table. I am trying to update that table based on a query. The
query involved used sums. When I try to this, I get "this is not an
updatable query." I know the cause for it, the fact that the query has
I also know the way around it. Run my query as a make table query, then
build my update query from that.
This project would have me doing this a couple of dozen times. I really
do not want to build 24 make table queries, 24 update queries, and then
have to delete those 24 tables. If nothing else, I would expect that
would seriously fragment my databse,...Sum of a column based on color coded cells
Looking for some help on what sounded like an easy thing
to do, but has me stumped. I have multiple columns of job
names that get color coded when complete or need to be
escalated etc.. A typical column may look like this.
and so on.
As the jobs are completed the cell is filled in green. I
would like a total at the bottom of the column, how do you
total only the green cells?
Take a look here for some help and examples:
"MikeM" <firstname.lastname@example.org> wro...Need only one DLL instance to run...
if two apps load the same DLL - LoadLibrary(...) - system will create to
different instance of the DLL...
Now, in my DLL i've a CList and i need it to be visible to all instance and
Is there a way!?
I need the dll to remain loaded till machine reboot!!! Is it possible!?
>if two apps load the same DLL - LoadLibrary(...) - system will create to
>different instance of the DLL...
>Now, in my DLL i've a CList and i need it to be visible to all instance and
>Is there a way!?
It'll be difficult to share a ...Dynamic source data based on Today
I am creating a production barchart that is updated daily. I want the chart
to plot from 3 days old to 4 days in the future. I would like the middle of
the chart to represent today. Tomorrow's data will become today's data when
everything shifts by one at midnight.
I am pretty new to macro so please speak in laymans terms.
No need for a macro. Adapt the ideas at
particularly example 2
Custom business solutions leveraging a multi-disciplinary app...credentials to run this report are not stored
I'm getting this problem when I try and create a timed subscription.
Error: ...credentials to run this report are not stored.....
ok I created another folder under the same folder where I'm having this
loaded the report and I have no problem. I even moved the current folder
with that report in it. Creted another folder with the same name
and still the same problem with that named folder. With a different name for
the folder I have no problem???
I'm stuck here.. almost all post just talk about storing the credentials,
Already done and works...Automatically run macro
My name is Mike and i have a question about microsoft excel macro's.
Attached is a copy of the excel sheet im working on. Below the excel
sheet is the macro I built. Some of the cells contain given values and
some cells are calculated from formulas. Cell (G4) is my given
value...it is related to cell (C32). The point is, I plug a value into
cell (C10) and it runs through the rest of the calcs in the other
cells and gives me a value to cell (C32). I built a macro that works
as a goal seek pretty much. The macro makes cell (C32) equal to cell
(G4) and gives me the value for cell (C10). I wan...Tasks: Created Date appears incorrect
If I add "Created Date" to my tasks view, it seems to be
updated to the current date each time the task is
assigned to a new person.
If I go into the task properties however, it shows the
actual task creation date. Any idea how to display the
actual task creation date?
...Query Exchange/AD for users that have OWA enabled
Does anyone know if there is a query that I can run to give me a list
of all user accounts that have the OWA feature enabled?
We have 900 accounts, and we only allow some user "types" to have
We are running Exchange 2003 on Win2003 server, Active Directory, etc.
Please forgive me if I am posting to the incorrect group (Exchange instead
...run time error 10-22-03
I am having a lot of trouble when I open up word I get
run time error 52 in VB. I have tried uninstalling word
and reinstalling it. WE have tried deleting the macro
but still to no avail can someone help me please?
...Repost: Error running Report in an Access 2003 db from Access 2007
Ok, clarification - ignore the code from my original post, some of the
reports do work. The ones that don't are reports that I have being filtered.
Here is the code from one of those buttons:
Private Sub Ok_Click()
On Error GoTo Ok_Click_Err
'using the customer sub form for customer state report to filter the
report, clicking ok will open report for selected state
Dim stDocName As String
Dim stLinkCriteria As String
If Not IsNull(Me.Search_Results) Then
stLinkCriteria = "[StateOrProvince] = """ & Me![Search Results] & """"...Silly date/text question
Hi- is there an easy way to show dates/text with the day eg. July 17th
similar to Word 2k format eg July 17th . Currently cut/paste from Word 2k -
to get raised 'th' or 'rd' or 'nd' etc.
In custom format use
>Hi- is there an easy way to show dates/text with the day
eg. July 17th
>similar to Word 2k format eg July 17th . Currently
cut/paste from Word 2k -
>to get raised 'th' or 'rd' or 'nd' etc.
Are you looking for the th, rd, nd stuff or are ...Automatically display set text based on users composition
Hi, im trying to do something really simple, trouble is i
dont know what the feature's called to be able to search
for tips on how to do it.
Basically in outlook messages, when a user begins writing
a sentence e.g. "in the terms of" i need a tag to pop up
that allows the user to press enter and then the
remainder of what they will want to type in will be
inserted in, its a yellow tag that comes up above the
words. i dont know where it needs to be created and
...Date Formatting #11
Can someone help me with my date formatting problem?
I want to enter a date as text as in: January 25, 2001
and want Excel to display the date as: 1/25/01.
I have tried using a date format but when I type the date in as text it is
just displayed as i typed it in (January 25, 2001)
Thanks to anyone who can help. :)
format the cell as custom and in the input box type m/d/y
MACRE0's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1084
View this thread: http://www.excelforum.com/showt...Excel Continuous Running Total
I posted a message earlier and have received a partial solution.
I want to keep track of how much stock prices go up or down with a running
total of how much they go up or down over several days until the direction
For example, if price go up 10 on Mon, 20 on Tues, 30 on Thurs and down 10
on Fri I want my running total column to show a positive number of 60 and
then a red number of 10 and continue adding the amount of the total of the
down days until the market shows an up day.
The formula I am now using total the first and second day but does not do a
running total count if t...display changing label caption on form as sub runs w/o screen flic
let's say i have this routine
label1.caption = "Starting ... "
label1.caption = "Getting there ... "
label1.caption = "Finished! ... "
on my form, i have label1 right in the middle
what happens is sometimes the message will change, and then sometimes it
wont, or it will show the first one, skip the second and jump to the third
etc etc etc
so it is inconsistent.
is there a way to make sure the label caption displays consistently, on
time, wh...Automaticly change Void date to system date when Voiding document
When voiding payable documents Checks/Vouchers. When the use clicks the check
box change the Void Date and Post date to the system date. This will stop
user for getting the error that the period is closed or posting to the
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" ...Get query from Access
trying to do a query. So I do the following:
Data->get external data->New database query, then from the
Choose Data source, I choose MS 97 ACCESS DATABASE*,
then I select the database.
This brings me to the QUERY wizard-Choose columns
When I double click on the table/query I want, it doesn't
bring the columns to choose. It changes the + sign to -
sign but nothing else. I try a different database, and on
this one it does work. So not sure why only on one
database it works. Any suggestions?
Would appreciate it.
...Money 2002 will not run
I had been using Money 2002 for approx. 3 yrs on my home pc (Dell Dim 2100,
XP Home Ed. w/SP2). Last year, it simply would not launch. No error message,
no splash screen, no app opening, no process listed in Task Manager. Just....
The only change that was made to the system since M2k2 last ran was
upgrading my a/v solution from Trend Micro PC-Cillin to TM Internet Security.
I have tried disabling every aspect of the Internet Security product, as well
as completely un-installing the app, and then attempting to run Money, but
the same thing (nothing) happens.
I was considerin...What tables and database does the Knowledge Base use?
Hi, we are wanting to make Knowledge Basee articles available online
for customers. From what I understand we would have to setup something
manually to display SQL information on the website. So what I would
need to know is what fields and databases will we be using if we do
something like this?
"Admin Matt" <Admin.Matthew@gmail.com> wrote:
> Hi, we are wanting to make Knowledge Basee articles available online
> for customers. From what I understand we would have to setup something
...HOW TO: Plot a Team Name on a chart based on two values
I have the following table exmaple, what I like to do is to plot the team
as where their values cross, e.g. for TEAM 01 where 5 and 60 cross on a graph
having Revenue as the Y axis and Clients as the X axis.
COLUMN A COLUMN B COLUMN C
TEAMS CLIENTS REVENUE
TEAM 01 5 60
TEAM 02 10 120
TEAM 03 15 180
TEAM 04 6 72
TEAM 05 12 144
TEAM 06 18 216
TEAM 07 7 84
TEAM 08 14 168
TEAM 09 21 252
TEAM 10 8 96
Any guidence, much appriciated.
I've done this using Ron Bovey's XY Chart Labeler
"Kevin McCartney" <KevinMcCartney@discussions.microsoft.com> wrot...Re: Workflow just wont run automatically, i have to run them manually
Yes, but i realized what i was doing wrong. I assumed [bad idea] that if i create a case and hit Save & Close the first time, taht the rule will run. In order for the rule to run automatically, it has to be Save, once it saves it, then Save & Close.
Thanks for your reply.
Did you check the workflow monitor to see if the rules get triggered
correctly and complete sucessfully ?
Have a nice day,
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://...MRP Workbench Schedule Receipt Date
When using the MRP workbench, if the flag is on in MRP Preference Defaults
to move in, the scheduled receipt reflects the MRP suggested date, not the
current promise date on the Purchase Order or MO Due Date. The workbench
makes the assumption that the exception message has been acted upon. If a
Planner\Buyer used the workbench when the Move In flag is on, they will be
given information that lets them believe that the component delivery schedule
(PO or MO) supports the Forecast\Sales Order Demand, which is not true. The
Workbench should have an option to use the PO promise date and the...Adding a month to a series of dates
I'm probably being stupid, but here's my dilemma! 8o)
I have a date in cell A1, say 19/3/04 and I need to fill in the next 35
dates automatically - each being incremented by exactly one month:
I can't figure out an easy way to do this, such as adding a fixed number of
days, as each of the month's have a different number of days.
fill in A1 with 19/03/04
fill in A2 with 19/04/04
put the mouse pointer in the lower right corner of the selection (you'll get
a black cross) and drag it down using the le...Outlook Still Running
I am running XP Pro with Office 2003 Pro and sometimes when I exit out of
Outlook, Outlook.exe and Winword.exe stay as processes still running. Does
anyone else have this problem and what can do to make sure this does not
Thanks for your help
Remove ABCD from Email address to reply <neil154ABCD@earthlink.net> wrote:
> I am running XP Pro with Office 2003 Pro and sometimes when I exit
> out of Outlook, Outlook.exe and Winword.exe stay as processes still
> running. Does anyone else have this problem and what can do to make
> sure this does not happ...combo box in a query
Is it possible, do you think, to insert a combo box into the criteria
section of a query? The user of the query will have a lot of units to
choose from in the query and it would be easier for the user to have a
drop down box to make a selection from. Can this be inserted into the
query so that it appears and is functional when the query is run?
If so...how would a novice go about it?
Not directly, but you can enter a reference to a combo box as a parameter in
the query. Create an unbound form with a combo box on it which lists all the
possible values in o...