I need some help with a query. I believe that a Union Query is
appropriate, but I am unsure. I have two make table queries. One
makes a table called QTY_RECEIVED that has the following field names:
Part#, Fiscal_Week, Fiscal_Year, and Receipts.
The 2nd table is called SUPPLY_REQUIREMENT which has the following
fields: Part#, Fiscal_Week, Fiscal_Year, and Demand.
I want to see the history of Demand and Receipts for all the parts
that I have entered.
Problem is that some weeks there is no demand and some weeks there is
If I link the two tables by Part# and Fiscal Week t...Modifier Error
Whenever we try to go to modifier it gets the following error.
The Modifier is currently unavailable because another user is editing
resources in the Forms Dictionary.
The Server has already been rebooted but we are still coming up with the
make sure that you are not sharing the Forms Dictionary with another
"Jess M." <JessM@discussions.microsoft.com> wrote in message
> Whenever we try to go to modifier it gets the following error.
> The Modifier is current...Outlook .pst cannot be accessed
Starting today, I cannot download email (Office Outlook 2007/VISTA). I get
the message "Cannot start reminder service. Cannot show reminder. The message
interface has returned an unknown error. If this persists restart Outlook.
Cannot open item. Item may be damaged." I have shut down and restarted my
computer four times with no change. The Unread Items folder is gone along
with my contacts in the address book, and the calendar. And, I cannot move
messages to other folders. There is also a message saying "Receiving error
0x80040600." Does anyone know what the p...Excel Front End with Access Back End #2
I would have one central Access Database that sits on a server wit
copies of the Excel front end on the users laptops. I just need to kno
how to create the interface between them.
Ripan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=471
View this thread: http://www.excelforum.com/showthread.php?threadid=26704
in access you can link to excell files like you can link
to another database. I do it all the time. and the linked
excel files work just link acc...getting column and row names if a cell has a value
I am trying to pull data out of a large Excel spreadsheet to get a
slimmed down version..
I have a large spreadsheet (100+ columns by 500+ rows, and 12
worksheets) that I'm trying to make sense of in order to import into
Each Column has a four-digit code for a "name", each row has a five-
digit code for its "name." The majority of cells have a value of '0'.
I am trying to get excel to look at the range, and if there is a value
that is not zero in a cell, give me the column name in one column, the
row name in the next column then the v...Using the highest count for the field name in a query
I have a table that list a count of peoples visits along with the State City
and 5 digit Zip Code. I would like to query this data so I can get a
total(Sum) of peoples visits by their 5 digit zip code. This is difficult
because some Zip Codes can have more than 1 town associated with that 5 digit
zip code. I would like the total for all trips in that zip code but have only
the city or town with the most visits listed in the city field. For instance
I would like the table below
City State Trips 5 Digit Zip
Anytown OH 1 18555
Anytown OH 2 18555
Farmtown...Selecting a Value from a Range of Values
I want to select a value from a range of 20 Values depending upon the relationship between two cells outside that range.
Lets say the Range of Values I want to select from is held in A1 to A20
I then Have a Range of Different Values in held in C1 to C24 - C1 = 1, C2 =2 ..... C24 = 24
In E1 I have a Value that could be anything from 1 to 24
If C1 = E1, I want to put the Value in A1 into D1, A2 into D2, A3 into D3 etc
If C2 = E1, I want to put 0 into D1,the Value in A1 into D2, A2 into D3, A3 into D4 etc
Can it be done?
Simplest way would be with one formula in D1,
And another in D2, wh...Outlook 2003 will not close!
Outlook will not close! I'm not using a exchange server.
I have to close outlook 2003 with the task manager.
This happened after upgrading office XP to 2003.
Runing with winfax Pro 10.01
WinFax 10 is not compatible with Outlook 2003. Might want to check the
Symantec support site and see if they have documented steps on how to
install WinFax 10 w/out integrating into Outlook.
Neo [MVP Outlook]
Due to the Swen virus, all e-mails sent to this account will be deleted
"sendmeabuck" <firstname.lastname@example.org> wrote in message
news:095201c39fb3$046f20e0$a6012...criteria field to auto filter
ok that seems to work but the problem now is that the screen is blank, if i select the filter the date in the field is correct with the right criteria but i have to select OK for it to work, how can i get it to select OK automatically so that will display all the transaction dates...
thanks for this
The < operator should be enclosed in quotation marks, and followed by an
Selection.AutoFilter field:=4, Criteria1:="<" & lessdays
> I am trying to write a macro that will use the autofilter function in Excel. I ha...EXE change in data modified
Have a question regarding GP. What can cause a change in the "modified
date" to the dynamics.exe file?
In theory, something would need to change the file. My best guess would be a
service pack would change the date.
> Hi Guys
> Have a question regarding GP. What can cause a change in the "modified
> date" to the dynamics.exe file?
For GP 9.0 SP 1 the Dynamics.exe modified date is 5/16/2006 which looks to
be the date the Service Pack was created (as opposed to the da...Erroneous 'Enter Parameter Value' dialog after converting to Acc 2
After converting from access 97 to access 2000 when I try to open some of my
reports from code I get an 'Enter Parameter Value' dialog appearing. There is
no field name listed in the dialog and when I press the OK button the reports
appears just as in Access 97. Is there any way to suppress this dialog from
Answered in m.p.a.reports
...changing forumla results to values on the fly
Is there a way to get a cell's forumla to convert to its resulting value on
the fly (rather than having to go back in and cut>paste special>values)?
Alternatively, is there a way to use a second column that will display the
values returned from the formulas in the first column as hard-codes values?
Thanks in advance.
Click in the cell, then:
Please keep all correspondence within the NewsGroup, so all may benefit !
------------------------------------------------------...VB.Net: how to carry SessionID(its value ) from 1 function to othe
If I get SessionID in 1 function how do I carry that SessionID(value of this
SessionID) to another function or another form within the same project
Winforms or webforms?
In Winforms, u can make the SessionID a public or internal property of the
form and in WebForms use the Session object to hold this value.
"XML newbie: Urgent pls help!"
<XMLnewbieUrgentplshelp@discussions.microsoft.com> wrote in message
> If I get SessionID in 1 function how do I carry that SessionID(value of
> SessionID) to ano...Problem to modify the size of PlotArea
I am trying to modify a chart so that it prints in a 20cm x 17,5cm frame. I
do understand that this is governed by the plotarea.insideheight and
plotarea.insidewidth properties. I also do understant that these properties
are read-only. So far my code is the following:
.SizeWithWindow = False
.PageSetup.ChartSize = xlScreenSize
.PlotArea.Width = 567
.PlotArea.Height = 496
Do While .PlotArea.InsideWidth < 567
.PlotArea.Width = .Pl...How Do I change the User name field
Running WinXp SP2 with Office 2000
I have 100+ PCs that I need to change the Username field so that when the
user gets 'File is locked' message, I know who originally opened the file.
I know this can be manually done by going Tools - Options - General.
But with 100+ PCs I would prefer to able to this either by Group policy or a
Does anyone have any ideas.
...modified timeline graph
I have a table of dates and events (and "phase"), and I want to make a
timeline graph: 1-d horizontal line, no (visible) y-axis.
I want the distance between the events to be spaced based on the date,
and the event names to be shown at each point. The dates should be
shown too, either for each event or just based on auto-scaling of the
x-axis (e.g. major unit = 3 months).
Here's the hard part. The events happen in different "phases", and I
want to show the phases graphically somehow. I was thinking this
component of the graph would be a bar chart, and I could someho...cant get outlook 2003 to work in Windows 7
installed office 2003 standard (sp3) in windows 7 and get a trouble message
when launching. A popup box called configuring outlook comes up with the task
"migrating account settings" highlited. This is followed by the trouble
message box called microsoft office outlook stating "unable to open your
default email folders. Outlook would not start because a data file to send
and receive could not be found". I went back into the windows control
panel>user accounts>mail and verified a pop email exists but there no entries
under the data tab. I selected add (...Can't trim white space from large varchar field
I am reading two very large varchar fields (2600) from the sql
server 2005 database of our ERP. This reading is being done by a
cursor. In the cursor select statement I rtrim and ltrim the field. No
matter what I do the length of the field is always 2600. I can see
that there is some sort of white space to the right of the text.
Whatever that white space is, it can't be trimmed by ltrim or rtrim.
I tried running the sql from the cursor as a query and had the
Any help would be appreciate it.
If you do a RTrim of a varchar column, the...Exchange 2003 mount public db
I have Exchange 2003 SP2 on SBS Server.
On of my customer losed old mail on a public folder and I need to restore
I have the database file that contains the emails but i wouldn't stop
exchange mount the old db (DBOLD) create e pst of email, dismount the db and
mount the official db.
It's too dangerous!
Then I reinstall the same machine on a server with the same domain,
organization, Admnistrative group of Exchange.
Dismount the original db and I try to mount the db of the other server
I receive an error like this:
The information store could not be loaded bec...Excel To Access: Help with getting a range data from excel to acce
How can I transfer a Bock of data to Access from excel by clicking a Submit"
eg: There is a "Submit" button on the excel sheet that exports all of the
student data at once in the access database.. I want to insert all this data
in access at the same time.
Here is what My excel table looks like:
Student_ID Subjects Grades
123456 Eng A
123456 Hist B
123456 Math B+
123456 Bio B-
So, once we click "Submit" I want the data displayed above to go to
access, I...memo/payee fields
Even though my wife's employer's name is listed in
the 'memo' field for a downloaded transaction, money
insists on auto-filling the 'from' field with my
employer. anyone know how to change this stuff? happens
with grocery stores too - even though the transaction is
downloaded from kroger, the 'from' field will always
say 'meijer', for example. i suspect it's the same
Sound like your bank is sending malformed data. Typical. Try calling them
and telling them to get with the program.
"russ" <email@example.com> w...Access Issues
I am very new to CRM, just got thrown in at the deep end due to a new
For some reason i can't access web CRM on my PC or the server.
As soon as i try to connect i get, it does not even as me for a
username or password.
Microsoft CRM could not log you on to the system. Make sure your user
record is enabled and that you have been assigned at least one
security role. For more information, contact your system
Log onto random another PCs and it works fine!!
Internet Explorer - Tools - Internet options - Local intranet - User
authenticati...Outlook 2003 is slow to switch from Mail to Calendar, why?
it takes about 15 seconds to switch from mail view to calendar - can someone
offer a suggestion? My outlook.pst is only 250 MB
...Problem importing leads/contacts with embedded comma in fields
When importing .csv file, if a text field that is delimited with double
quotes contains a comma the import tool still see the comman and separated
the field into two or more fields, which then shifts all the following fields
into the wrong position.
Am I missing a fix. I am running CRM 1.2 with the last rollup. Was there an
earilier patch to fix this.
Thanks - Bob
There is no fix. You have to ensure your CSV data is clean.
Microsoft CRM MVP
"Robert Morris" <RobertMorris@discussions.microsoft.com> wrote in message
news:7EBD...Matching a value in two worksheets, and then copying a cell from one to other
Noob alert :)
I have a workbook containing several worksheets. I will be adding another
worksheet that will, in effect, be a master for all of the other worksheets.
In the source worksheets (existing) there will be several employee id's
(unique) per sheet (sheets are different departments), and a seperate column
housing that employees pay rate. Any employee may work for one or more
departments, so there may be duplicate id's when considering all of the
worksheets, but in each, the id will be unique.
What I would like to do, is have the master worksheet with an individual