Excel not Access
I have designed an Access database that holds records relating to my stores
audit results going back for about 5 years plus a load more information
relating to these stores. This was used to produe a pack once a month,
however a change in senior management means that I have got to shelve this
and prodce a similar pack in Excel.
The idea would be that the user could select a month or a 12 mnth date range
that would produce data that could then be used to populate a number of excel
templates that have been designed. Having not used excel for years I would be
grateful for any suggestion...Recieve Mail Before Sending
How do I set up Outlook 2003 to recieve mail before sending
Set your send/receive group settings to receive and not send. Or are you
talking about setting authentication?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer:
Keith <firstname.lastname@example.org> asked:
| How do I set up Outlook 2003 to recieve mail before sending
...Inserting form values into a table
We have a form with values taken from an sql query that comes from two
different tables. We would like to enter the information into a third table.
Can some one direct me to code that will do the following:
1. Provide the Insert sql that shows us how to add the form values to the
2. Show us how to loop while inserting the information into the table (there
could be several lines on the form, each must be inserted one at a time).
I have worked with Access before and have never had a problem inserting
information. However, I cannot quite figure out how to insert informtion
through an ...Can I send a recurring e-mail automatically each week
I want to send a e-mail with the same verbiage to the same person once a week
and make it a recurrence with no end date. Can I set this up once in Outlook
so it is scheduled automatically?
Microsoft Office 2003 Version
Students and Teachers Edition
Windows Vista Home Premium
Happy new Year!!
...Input Excel 'Password to Open' through control in access form
We know,Excel has prompt password
to open it files.
Is it possible to create a code that can
supplies the excel prompt password?.So that when we
open the excel file through our access control in a form,
the excel files can be opened automatically.But when the
excel files opened from its default icon,it will prompt a
..."Save" preferences getting lost
I work on long documents and want to save my work frequently.
Every time I set the "Save" preference to a brief interval like
five or ten minutes, the preferences seemingly resets itself to a
default of thirty minutes.
I'm using Word 2008 for the Mac on an Intel running 10.6.2.
Thanks in advance for any thoughts.
- Mark Pavlick
That indicates that your user ID does not have permission to write to the
preference file that Word is using, or that something is replacing the
With the help of your System...Grammar check not working
I am using Word 2007 and have a problem with grammar and punctuation errors.
I deliberately put two spaces between words, do not put space after a comma,
write long sentences and finish a sentence without a verb but the green
underline never appears. The spell check is functioning properly, no problem
with that. In Word Options > Proofing, "Mark grammar errors as you type" is
selected. I changed that selection and tried again but it still did not work.
I used different languages as default language but no change.
I would be grateful if someone could come...How can I change 'Normal' Style for Word e-mails to 'Normal (Web)'?
Hi, I'm using Word as my e-mail editor in Outlook 2003 and want to change
the default Style for e-mails from 'Normal' to 'Normal (Web)'.
The problem is that new e-mails and replies in HTML format use the 'Normal'
Microsoft Word 'Style', and this has no gap after paragraphs. The upshot of
this is that when sending an e-mail, I have to press return twice to create
a gap, but when the recipient views this, their software shows it as four
gaps (the extra carriage return I typed + their correctly viewed HTML
carriage return after each line).
E.g. I type this:
Sorry folks. I asked a question and went to the hospital for a while and
the question expired.
I have an address list in excel 2007 and am using word 2007. In my address
list I have a code column which should allow the selection of addresses to
put on labels. I used to have a query section what allows for that but I
cannot find query any more. can anyone help me?
Questions here never expire, though it may become difficult to find the
answer. The previous post received one reply, from Doug Robbins, as follows:
See the article "Mailmerge Labels with Word ...How To Copy MS Word mailing labels into Excel
I have a word doc that I want to put into Excel. I want to add some
more fields to the names and addresses. Is this simple or do I have to
learn how to program?
City of Grand Prairie
Michael, have you tried to copy and paste the data into excel?
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"Michael Rodriguez" <email@example.com> wrote in messa...Radar chart in Access 2007 report
Can you add a Radar chart to an access 2207 report?
...How to get rid of personal folders view in nagivation pane with MA
Hi, trying to help a friend who migrated to hosted mail with MAPI. She is
running Oultlook 2003 with latest updates. In the navigation there are
personal folders and MAPI folders. The personal folders always show at top
and expanded, with the MAPI folders below and not expanded. She only wants
to see the MAPI folders expanded in the navigation view. I tried deleting the
personal folders and it would not let me and it will not let you deliver to
MAPI, which I understand why. Does anyone know how to make this happen?
Is this a hosted Exchange account?
You can change the...Strange Access Denied Problem with Windows 7
I got a new computer about six months ago that came with Windows Vista
Home Premium 64bit. Before that I had done all of my .NET development
either on an XP Pro VM or my former XP Pro computer at home. Shortly
after getting my new computer at home, I also got a license for VMWare
to be able to test my software on multiple platforms and
I had wrote an application originally in VB.NET that was a simple
backup utility. It supports mutiple backup configurations. Any given
copnfiguration would define a backup which would be a list of files to
backup, a list of folders to ...[Exchange 2003] Mail enabled public folder and sender address
I have a Windows 2003 domain with a native mode Exchange 2003 organization;
there are some mail enabled public folders.
When a user replies to a message in a public folder, the outgoing mail's
sender address is the user's one; I want it to be the public folder's one,
or at least I'd like the "reply-to" address to be set to the public
How can I accomplish this?
You would need to grant the user permissions to be able to Send As the
public folder. By default, when you reply to a message that is in a PF, the
PF is not composing the ...[b]Can I download Excel data to a MS Access database?[/b]
I've built an Excel 2002 form that I want our internal customers to
access from our intranet, and use. Once completed, they will send it
to us as an e-mail attachment. I'd like to be able to open it, and
somehow download the data from the form into an MS Access 2002
database I've built (so that we don't have to rekey it into the
Is this possible or even feasible? Any and all help is appreciated.
Message sent via www.excelforums.com
in Access check 'File - Import External data'
"...How do I merge cells with multiple data values?
I've tried highlighting the two cells which are in the same row. It
suggested that I format and align. Both of which I've tried. I keep getting
the same error message, "The selection contains multiple data values. Merging
into one cell will keep the upper-most data only." I need to make the cells
one with all my information. Is this possible?
Not knowing what you want to do, let me make a suggestion. Put all your
data into the first cell and leave the second cell empty. Select both
cells. Click on Format - Cells - Alignment tab. In the "Horizontal" b...McAfee 8.5.0i on access scan slows down MS Dynamics CRM web client
Our organization's McAfee 8.50i slows down MS Dynamics CRM v4 - on premise
web client considerabley when loading forms and data.
Besides completely disabling McAfee, does anyone know how to configure
McAfee (or configure CRM) to ignore CRM related form and data loads.
When disabling the oncaccess scan, or when disabling the scriptcan - it
improves lookups from 8-9 seconds to 4-5 seconds.
However, the organizatin policy is to have these enabled.
What to do?
We have the same behavior, and went we reported to Microsoft says that no
solution has, then we buy and install Microsoft Securi...HELP! remote data not accessible msg
I have a use who is currently using a Bloomberg DDE add-
in. Whenever he attempts to activate the add-in to
retreive remote data, the system hangs. If I go to task
manager, I then see a message stating "Remote data not
accessible. To access this data Excel needs to open
another program.... I have searched the knowledge base
and didn't find much help. Does anyone have any ideas? I
am desperate!!!! We are currently using Excel 2003 in XP
...Mails not appearing in Inbox although on Server and viewable by colleague
I have searched the archives and found a few more or less related
topics to my problem, but unfortunately none of them helped.
Here's my problem:
I know that I recieve several mails at a specific time each day. Those
mails are sent to a colleague of mine and myself but only he recieves
My admins looked on the Exchange Server and all say, that they can
definetely see these emails in the server logs and that the server
delivered them to the right mailbox.
If my colleague looks into my mailbox before(!!) I open Outlook, he
sees these mails as unread in my inbox. As soon as I op...Can you only merge up to a certain number of cells
I am working on microsoft excel 2003, I have a sheet that I merged cells
starting with line 8 through 43...when I type my information in the merged
area I can see all that I am typing...say it goes up to line 30 once I hit
the enter key I can only see up to line 20. Even when I print it out it only
prints up to line 20...I have checked to make sure there are not locked cells
etc. I cannot figure out at all why this is happening...is there only up to
a certain number of cells you can merge?
From "Excel Specifications and Limits"
Length of cell contents (text) ...Purchase Resolution Tables
PRW tables in Great Plains - are these tables temporary tables populated only
when the purchase resolution is run?
Im asking because i want to extract data in crystal from the PRW40034 table
but cant seen any PRW tables via crystal.
I reckon these PRW tables are names of once before existing tables in earlier
versions of GP - i believe the tables I want are the MPO tables
If this is 100% (im at about 95% with this) its a shame MBS havent cleared
up the table list to NOT show tables that are no longer used.
> PRW tables in Great Plains -...set default record to a table
I have a shared db with various front ends (mde). I would like to set a
paricular record as my default record, so whenever someone opens up the
various db forms it opens up to the same default record. Is this possible?
Maybe this is a matter of terminology...
In Access, data is stored in tables. Each table has it's own records
(collections of related data).
When you say you want a "record" to be the default one pulled up by
everyone, how do you know they are all using their different forms to look
at the same data (i.e., table)?
Next, why? What is it about ...Accessing the same PST file from multiple WinXP Pro IDs
I am running a Windows NT 4.0 network with workstations
with Windows XP Pro. One user has Outlook 2000 on his
notebook. He has a profile to log on to the machine
itself (i.e. not on the Windows NT domain) for when
he's "on the road" and one for logging on to the NT
network domain to use the printers and network
facilities. On my personal notebook I have Office XP and
I was able to configure Outlook's data files (Tools ->
Options -> Mail Setup -> Data Files) so that I would
access the same PST file under both profiles. I cannot
figure out how/if this is poss...Weighted Average Calculations for Pivot Tables
How does one implement weighted averages in pivot tables.
Bonds Interest Rate
Weighted Average Interest Rate is .0927
(I normally do this using sumproduct(col a,col b)/sum(col
I would like to be able to perform this in a pivot table
with the weighted average calc being a grand total. You
can see how this can be useful and expanded once the
basics are found. Any ideas.
...How do I copy data in single cell format to a merged cell format
I need to copy a list of data in single cell format into a spreadsheet where
those same columns are merged cells (with four cells merged into one).
I have several hundred lines of data so some way of copy & paste (other than
each cell individually) would be appreciated.
What I would do is copy format of sheet with merge cells to blank sheet then
copy single cell data to sheet with merge cells select single cell to paste
you lose formatting so after just copy format from blank sheet created earlier
I find this easiest way
Hope this helps