Outlook data/address files
I need to reinstall Outlook and I want to copy my address
book/archieve files/sent e-mail files etc. where you I
find these and what do they look like, ie. extensions.
Look here for all the information you need on backup and restoration of
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***
> I need to reinstall Outlook and I want to copy my a...Data from tables
Okay. Think I wasn't clear.
Have a table called FDA that contains tons of data.
Have table called Log
Have table called Daily totals
Have a query called Foods_qry
The source for the form is the query. The source for the field called Food
is the table FDA. This is what I did based on what you said...
.FindFirst "[Calories] = " & Me.Food
If Not .NoMatch Then
Me.Bookmark = .Bookmark
I get an error: Run Time Error '3077' Syntax error (comma) in expression.
It points to .FindFirst "[Calori...compiling tables
I have a long list of names (col D) and a date (col G) when they attended a
course. Every person needs to attend a refresher course within 12 months. I
am trying to predetermine who will be on the course in 12 months time, plus
or minus a week or two, the problem is the course may have 12 persons
attending or 6 depending on the number of trainers. Several courses are
available on a rolling basis. I guess this is a queuing problem.
So far I have worked out the lapse time in days (col J), and the rank (Col
K) then I used:
=OFFSET(D$11,MATCH(SMALL(K$11:K$38,ROW()-ROW(M$11)+1),K$11:K$38,0)...combining data into subtotal report
I need to manually enter data under various categories. (i.e. column A will
be Job # and the other columns will contain the counts of various supplies),
creating a very large running total of jobs and total supplies. It is
important to realize that I may enter the same job # with new data more than
one time. Now, I understand how to create subtotals of columns, but I was
wondering if, once I have sorted data by job #, there is a way to create a
fast and easy report that indicates ONLY the column headings and each job's
subtotal. I do not want to see the 25 different entries that it ...MFC requires C++ compilation (change the compilation setting to
c:\microsoft visual studio\vc98\mfc\include\afx.h(15) : fatal error C1189:
#error : MFC requires C++ compilation (use a .cpp suffix)
One of my vc6 project has the above error, I check the file, one of my
file(myfile.c) include a file util.h which is written in MFC format
including .h and .cpp file and all other files are written in c language ,are
..c file and do not have c++ syntax.
I compile all the files separately, only the myfile.c have the above error.
It seems that I need to change the compilation setting to c++ compile
setting to meet the requirement of MFC Class.
It seem...Importing data #2
Importing data into customer, item, suppliers, and GL master files.
This is a brand new company and I need to import the master files from
another system. I am able to easily dump each file to excel, but how do I
import into GP?
Gino S. GPK Computers
Usually you would use an import tool like Integration Manager or eConnect.
If this is a one time import, you're probably better off with Integration
Dynamics GP MVP
"Gino@GPK" <firstname.lastname@example.org> wrote in message
> Impo...emailing filtered data
Need to know how you can send a filtered email attachment
but not have the receipent the ability to unfilter the
filtered data. The only data the receipent should get is
the filtered information. I put protection on the column,
only to find the receipent could advance filter the column.
See this example
My Add-in have this option also
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
"Janet" <email@example.com> wrote in message news:firstname.lastname@example.org...
> Need to know ho...Importing Data #3
Good Morning everybody
just I would like to ask, How could I import a data from multiple column in
an excel sheet to other single column without being any of those imported
PLS HELP ME URGENTLY
Sphinx Shipping Agency
IT Manager & Shipping Excutive
Email : Hadoka@gmail.com
Msn Messenger : Hadoka@msn.com
Yahoo ID : Hadoka1982
...chart data by day of week
I have a spreadsheet of >12,000 records of stolen vehicles (cars,
SUV's, pickups, motorcycles, etc.) covering a period of almost two
years. Each record has a date of theft and other info about the
vehicle. I'd like to look at the thefts for day of the seven day week.
For instance, I'd like to look at all motorcycle thefts over a one year
period and count occurances by day of week and then generate a single
chart with theft count as the ordinate and day-of-the-week as the
I'm new to the group so pardon me if this question has been asked
> I h...Compiler
Is there a compiler available for Access applications, specifically for
Manager Information Services
Ohio Coatings Company
I would be interested in what you are really asking for, but the compiler for
Access (all versions) is built-in to the program and is available when you
are in the code window by going to DEBUG > COMPILE xxx.
There is no external compiler and doesn't need to be. If you are asking if
you can make it an exe file, the answer is no. You can use the Access
runtime and the developer extensions to create an installation pac...Data entry form
I need to create a form that will allow me to enter daily sales info
from a macro run from a button on the main page of my workbook. I want
the results to be added to a list that I can link to other worksheets
in the workbook. I am a little lost when it comes to visual basic and
was wondering if there is a template I can modify to achieve this task.
If not any links to info to achieve this would be helpfull, I have seen
many form tutorials and templates, just not one that will accomplish
I'm just guessing but I think what you are looking for is a way to update
the range refe...Reports not returning correct data
I am trying to run the Top Sales Rep Report in HQ and in SO Manager. The
problem is they are not returning the same data for each store.
The HQ report is also missing some of the Sales Reps. The SO Manager report
gives the correct data and all the sales reps.
Also, the numbers are off. For instance, Store 1 in SO Manager might show
that Rep. A sold $5200 and Store 1 in HQ might show that he only sold $4800.
Anyone having any other trouble like this?
Please help, my financial person is on my ass!!!
Must have access to ...Create summary tab of last entry/row on all tabs in workbook
I am tracking projects in a workbook. I have a tab/worksheet for each
project. For a weekly status meeting I create a spreadsheet that has the
last entry/row from each tab. Is there a way to program so I do not have to
copy/paste from each tab each week? I do add and delete tabs/projects from
time to time. PS- not very adept at the technical details so need to respond
to me in simple terms : )
You might want to submit your question to an Excel NG since I don't see
anything in your question regarding MS Access.
IMHO, I would move the workbooks to an Access database rather than...array data type
Hi, I'm trying to take a column of integers and input them into an arra
which I can then use for a loop instead of using this format:
If (Worksheets("NeeleyNedPRE").Cells(pRow, pCol).Value = 0) Then
For some reason this doesn't work because the column selected al
resets to zero rather than running the loop correctly and I think tha
an arrray might be the only option. What the easiest way to solve thi
Message posted from http://www.ExcelForum.com
anjem < wrote:
> Hi, I'm trying to take a column of integers and input them into an array
> whi...Specific filter for the data in a field
In a field there are entries that have the symbol * entered for some reason.
How can I filter and find all the data in that field that has "*" entered. I
can't seem to find the filter for it.
On Wed, 3 Feb 2010 14:29:28 +0200, "Dimitris" <ipackREMOVE@otenet.gr>
Use this expression:
This means a wildcard followed by an asterisk followed by a wildcard.
Microsoft Access MVP
>In a field there are entries that have ...Gathering Data using excel
I have an output from an engineering program that exports data into excel. I
would like to have a summary sheet where the pertinent data that I have can
be seen instead of having my clients having to pour over hundreds of sheets.
How do I get the text to appear.
Cell A5 shows the text "A/V Alcove - 332"
Cell A105 shows the text "Accessible Entrance"
On another sheet, I want to put Name in the top row and below that, I want
to have it be able to call up Cell A5 and then have A105 below that. There
are hundreds of room names so an automatic way ...Macro to copy data frow rows to one column
With this macro I try to copy data in columns B:M (12 months) and rows
3:8 (6 years)
into one column only, to then make a 1-serie graph. Data sample could
be this group archive, at the bottom of page:
But I get errors.
Thanks for help.
DestinationRowID = 10
For RowID = 3 To 8
For ColID = B To M
Range((ColID) + CStr(RowID)).Select
Range("B" + CStr(DestinationRowID + 1)).Select
Application.CutCopyMode = False
One way (I think):
Is it possible to somehow compile a program done with excel 2007 ?
Take a look here
"Duplatt" <Duplatt@discussions.microsoft.com> wrote in message
> Is it possible to somehow compile a program done with excel 2007 ?
> Thank You
This probably will not make it a 'stand alone' program.
I used a program ( Super Calc -- Dos) in the early 80's that had a compiler
Worked great fo...Linking of data
I have one main proposal spreadsheet. In this spreadsheet I have hyperlinks
to individual proposal templates (also Excel files) Behind every proposal
link I have pricing information from these indiviual proposal templates
linked back to my main proposal speadsheet. My problem is that when I open a
template and save it under a different name, the pricing information in my
main proposal spreadsheet is changed automatically from my individual
proposal template to the newly created proposal. Can anybody tell me how to
prevent this from happening. The price from the individual proposal temp...data validation and certain condition
When using data validation, I encountered the following problem. Th
Define data range as list_1, it included A, B, C, D, E, for examle.
In cell A5, I can select the desired option, for example A (one of th
In cell A10, I input figure here and let B10 (previously set it havin
data validation function) is the same value of A5 automatically, but
also want to select data from list_1 if necessary, for exampl
I tried data/validation/custom and input "=if(A10>0,A5,list_1)". th
results showed A only but cannot choose another from list_1.
Any id...Libs needing each others to compile.
I am taking over a project and the first thing I noticed it that the project
does not compile properly.
if I have 3 .lib files and one .exe file.
A.lib needs B.lib but, B.lib needs A.lib to compile. (C.lib needs both A.lib
How can this be done? This is obviously wrong, ( I think), but before I make
a fool out of myself I just want to check.
Is it possible to achieve the above? compile two .lib files that need each
others before they even exist?
The way they used to compile it was using the previously created lib file to
compile. And I guess at some stage they added li...Macro to delete specific data in tables
I am an analyst working in service quality for a market research firm. We
use SPSS 12 to output the data and later copy paste the tables into Excel for
formatting and printing.
The problem I currently have is that I got a large group of output tables
which come in two different formats. The first table is like this:
Mean Std Deviation
Masculino 5,4 1,4
Femenino 3,8 2,2
Group Total 5,3 1,5
Menos de 2400 UF 5,9 ,9
2401 a 25 mil UF 5,6 1,2
25.001 a 100 mil UF 5,0 1,6
Más de 100.001 UF ...How to make Visio discard cropped data
The Visio Crop tool appears to be more of a Mask tool. It does not
really crop anything.
I loaded a large bitmap file into Visio and cropped it down to a small
portion in the middle. When I saved and closed the file, I was
surprised that the file size did not shrink. When I reopened it, I
discovered that I could uncrop the image.
Is there some way I can tell Visio to discard the cropped material?
I need to extract some small segments from some large graphics files.
I don't want to store all that extra junk.
Email: Usenet-20031220 at spamex.com
You need to use a r...Error when trying to import data that was exported on another computer on networ
A file error has occurred in Comma Separated Values
(Windows) translator while initializing a translator to
build a field map.
The file \\Laptop\claptop\documents and settings\All....
The disk is locked, the file is a read-only, in use by
another program, or because you don't have permission to
use a network path.
...Help figuring out how to represent data
I would appreciate some thoughts on how I can best accomplish th
following task. I have a spreadsheet showing projected billing amount
for the next 12 months, the columns are labeled with the month and eac
row represents a different "type" of bill, the data is the amoun
billed in each month for each type. These are all projecte
figures,each month I will need to somehow reflect the ACTUAL billin
that occurred and then come up with the % difference between th
projection and actual. How can I best represent this in a spreadshee
(umm.. maybe I should go to Access?). In addition, I have c...