recall of infor on a form
I have created two tables: table one has basic info lname, fname, grade,
student id number. Table two is an incident report form with fields: student
id number, date ,grade , etc. I have a relationship from table one to to
table two in a one to many relationship respectively. My user wishes to enter
incidents on a form. So I created a form from table two and all works as
planned. However my user would like to enter either a)student number or b)
last name with out using a drop down list( long list of choices.) and then
have it display both student number and last name then save...Searching a backup prog for ALL (!) Outlook data.
I am searching a backup program which helps me to backup and restore really all
data components of all version of Outlook.
The most backup programs I have seen so far have restrictions: They...
- either are only suitable to Outlook or Outlook Express
- either are for Outlook 2003 or Outlook 2000
- either backup messages only or address book entries only.
Is there a program which handles really all these components?
Gerd Pohlmann wrote:
> I am searching a backup program which helps me to backup and restore
> really all data components of all version of Outlook.
> The mos...WBS in Data Analysis or Reports
Is there a way to get the WBS codes into a Data Analysis report?
If not, what table/view is the 'WBS' ifield n the Database? This is so that
I can create a SQL query to combine the WBS column into a report.
Please look for TaskOutlineLevel and TaskOutlineNumber fields in
On Feb 2, 10:35=A0am, Bubba <Bu...@discussions.microsoft.com> wrote:
> Is there a way to get the WBS codes into a Data Analysis report?
> If not, what tabl...Requisition Management should not force the use of requisition ad.
Requsition Management has by default the requisition administrator as the top
of the hierarchy and it cannot be eliminated or replacwed with an user. This
poses a problem when setting up requisition management using users instead of
roles. Often the top user of the hierarchy forgets to select final approve
and only approves the request routing it to the requisition administrator. In
an implementation with one company this forces the user to go back to the
approval page and select the role to finally approve the request.
In implementations with multiple companies with centralized admini...Create Range from Range
Let's say I have a range object set to be from B2:F6, and i need to
make another range object to be the last row of my original range.
(New range to be B6:F6) How would i go about doing this? I tried
the .Resize option, but that only works from the top left cell of a
Set xxx = Range("B2:F6")
Set yyy = xxx.Resize(1).Offset(xxx.Rows.Count - 1)
> Let's say I have a range object set to be from B2:F6, and i...OUTLK11.ADM
Is it a good idea to add OUTLK11.ADM to my GPO to control Outlook 2003
settings? The file is only 95 KB, so I figure the worse thing that can
happen is that the file has to replicate to all DCs. I'd like to get some
feedback from anyone who has used this before. Thank you and happy
Do you have current GPO's? Then just add OUTLK11.ADM and set your settings
for the OU you want to control. Unless you have a very complicated domain
structure, there should be no problems regarding replication.
and ofcourse a happy than...Need help with dual domain name problems
Windows 2003 Server SP1
Exchange 2003 Standard SP2
Windows 2003 Server SP1
Exchange 2003 Enterprise SP2
I'm just getting Exchange setup, I have internal communications working
properly but have run into a problem sending externally.
The organization has different internal & external domain names, lets call
them abc.com (internal) & xyz.com (external). When a message is sent to an
external address it goes out as firstname.lastname@example.org. Since abc.com doesn't exist
externally reply attempts fail. I need the exchange to change the sender to
email@example.com when sendin...Excel files via FTP are read-only if spaces in the name
If I open a spreadsheet from an FTP site, and the spreadsheet has a space in
the name, then Excel will always open the file as read-only. If I rename the
file to exclude the space in the name, then Excel will open it and allow me
to save any changes to the file. Any ideas what's happening? How can I open
a file named "My Spreadsheet.xls" directly from an FTP site? Is this a known
bug or a feature?
Here are a few of the details: I'm using Excel 2002 (10.6501.6714) SP3 and
the FTP site is using authenticated login, not anonymous. It's an IIS FTP
server on Windows 2000.
Th...What is CreateDialogIndirect() used for?
When I tried to use
> When I tried to use
Then you died?-)
Anyway, Raymond Chen just did a blog entry on the indirect dialog
I run Exchange 2003 and MS Outlook 2003. I am wondering about forms under
my scenario. Does someone know of a good site that details the use of
Custom Outlook forms? See the Forms pages at www.outlookcode.com
[MVP - Outlook]
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
"Mostro" <firstname.lastname@example.org> wrote in message
>I run Exchange 2...Using Photo's in a publication
I am trying to create a Calendar, 12 pages plus a cover 1 month to a opening.
I want to have a photo from my collection showing each month, it will be
printed on the reverse side of the page.
My problem is I can't see the photo when I insert it I have looked at the
View menu and set the picture setting to view picture not placeholder? what
else am I getting wrong?
> I am trying to create a Calendar, 12 pages plus a cover 1 month to a
> opening. I want to have a photo from my collection showing each
> month, it will be printed on the reverse side o...moving data
I need to move data in the same column on different rows
to the same row in different columns.
2222 n blow st
blowsville BL 00000
joe blow 2222 n blow st blowsville BL 00000
I have about 12000 rows of data, so the ole cut & paste
isn't gonna happen. Does anyone know of a better way?
Copy and paste special values transpose.
>I need to move data in the same column on different rows
>to the same row in different columns.
>2222 n blo...how to write data to EXCLE file
I need to write data to a EXCLE file in vc++ ,how to do I need?
If you are using the excel automation object, then from the project
settings include the component.
Project -> Add to project -> components and controls.
In this choose the excel component. IIRC the classwizard will generate
an classes to use the component. Or you can use the functions provided
with the excel component using automation.
If you want to write data raw i.e. create the excel file yourselves,
then you might want to look at the documentation of the excel file format.
SSEE wrote:...Xfr excel data from Office 97 to Office XP
I have been working on an excel document, that I often
carry home with me and use on my laptop. The file was
created in Excel XP and my laptop runs excel version
office 97. Using the file on both computers worked great
until recently. The file is now 600KB and will no longer
open on my laptop at home with the office 97 software.
It works great at work only on the excel XP. I do not
understand why all of a sudden I can no longer access
this file at home. I could really use some help, does
anybody have any ideas?
...Duplicate data on combo box
I have a combo box on a form that is fed from a table where customer info is
entered.. name address city state zip... The combo box is for the city
field. However, if there is more than one customer from NEW YORK it is
showing new york twice instead of once. How can I change that?
"Karen" <Karen@discussions.microsoft.com> wrote in message
>I have a combo box on a form that is fed from a table where customer info
> entered.. name address city state zip... The combo box is for the city
> f...Filtering Excel Data
I have just downloaded an excel file, which contains lottery number
and the date they were drawn.
I want to try and search the excel spreadsheet to see if my lotter
numbers have ever come up before, but am unsure on how to go abou
The data is in the form:
Column A: Draw Date
Column B: Ball 1
Column C: Ball 2
Column D: Ball 3
Column E: Ball 4
Column F: Ball 5
Column G: Ball 5
Column H: Bonus Ball
Column I: Ball Set
Column J: Machine
It is only the draw date, main ball numbers and the bonus ball that i
Can anyone help?
Message posted from http:/...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 ...Exclude hidden data from summary totals
I'm trying to write a formula for a subtotal summary cell that will exclude
data when the row is hidden and will not produce error values if data is
deleted. They should also allow for the insertion of additional rows of
data without requiring additional edits of the formula. The cells need to be
totaled so that the data within the cells is added, and not just counted.
Which I figured out how to do, I just can't get the formula to add the data i
have in the cell.
In addition, I need a formula for a grand total cell that will sum all of
the data in the subtotal formula cell...Quickest method to wipe data?
Is there a quicker way to wipe all the account and contact records from the
CRM database (other than deleting 100 records at a time within the
In my development environment, I have been running delete statements against
all the necessary <entity>Base tables. This has worked so far.
"Britt Landrum" <email@example.com> wrote in message
> Is there a quicker way to wipe all the account and contact records from
> CRM database (other than deleting 100 records at a time within...Please help- sorting and organizing data
Ost Ocity Dstate Dcity price
A B C D 34
A B E F 45
X C L Y 78
X C M S 87
T O A B 98
Q W A B 86
Ost and Ocity go together. for example A B is the origin in first
two rows and A B is the destn in last two rows- I want to sort this
data in a report or a query such that the origin and dest are next
to one another i.e in this example the first two rows( A B as origin)
are next to last two rows( A B as destn) . The last two rows should be
3rd and 4 th row an...Retrieval data from MS 2000 outlook public folder
I am using MS 2000 outlook. My company stores all the products and service
guidelines in the public folder located at outlook. Every week there are
updates of products and service guidelines where I need to check for those
guidelines to support the sales teams and back office. The structure is as
Each product or service is made into a new subfolder and there further
subfolders when ...Passing form name
I found this code (EnableFormControls) in the forum to enable/disable
controls on a form but I'm having trouble setting the variable 'frmAny' and
passing it to the sub EnableFormControls. What am I doing wrong?
Sub EnableFormControls(frmAny As Form, _
strControlSkip As String, _
Optional tfEnable As Boolean = True)
Dim ctlAny As Control
On Error GoTo ERROR_Handler
For Each ctlAny In frmAny.Controls
If ctlAny.Name <> strControlSkip Then
Select Case ct...Excel Data Not Visible in Cells 2007
I have two users in my office that use 2007 - myself and my manager.
This morning something strange happened to a spreadsheet he was
working on. There was data in the first 200 lines of the
spreadsheet. somewhere around line 35 and up to line 60 the data -
dissapeared. You couldn't see the text in the cells. BUT if you
clicked in the cells you could see the info in the formula bar. He
clicked save, and then it showed all the information again. This has
happend several times over several spreadsheets. Can anyone help
...I am trying to show names in my address book in last name first or
I am trying to show names in my address book in last name first order. KB
gives info about sorting contacts but that does not help me with my personal
When you post questions, include your Outlook version so someone can
M Gerber wrote:
> I am trying to show names in my address book in last name first order. KB
> gives info about sorting contacts but that does not help me with my personal
> address book.
...How Organize Data from Multiple Copies of Outlook?
I have three hard drives, a 15 GB, a 80 GB, and a 120 GB. Only the 15
has a working Win XP on it and it's the boot drive I'm using now.
Because of different events (don't get me started!), I have three copies
of Outlook 2003, one on each drive. I have some contacts and messages I
want on each drive, and I have lots of duplicates. Some contacts are
updated versions of other contacts with the same name.
What's the best way to edit and arrange all this into one set of mail
folders with one final group of contacts?
I want to clear out the 120 HD, and fresh install XP on it. So