hepl to solve my problem
Hi, I am new to access but i have the following to complete. Please help me
scheme date period rate
FDR 1/1/2000 1 YEARS 6
FDR 1/1/2000 2 " 8
FDR 1/1/2000 3 " 12
FDR 1/8/2000 3 13
FDR 15/1/2001 2 9
FDR 15/1/2001 3 12.5
FDR 1/12/2001 2 7
FDR 1/12/2001 3 11
RAP90 1/1/2000 90 5
RAP90 1/8/2000 90 6
RAP90 15/ 1/2001 90 6.5
RAP90 20/5/2001 90 6
RAP90 1/12/2001 90 5
SCHEME RECIEPT_DATE PERIOD AMOUNT
FDR 1/2/2000 3 10000
RAP90 15/4/2001 90 15000
I want to computer to automatically renew the rec...Pivot Table not pulling all fields or data
Without getting too verbose, I have a 900 row by 26 column database I am
applying a Pivot Table to. The code seems to run fine, but it is not
returning some of the fields, and of course the related data. I have tried
reformatting the entire columns I am pulling from but no joy......however,
when I reformat an errant cell from General to TEXT, that row comes
in........and/or, if I change the value in one of the missing cells, it will
bring that row in. The code runs fine, and was mostly derived by recording
a macro in XL2k, but the data cannot be trusted becau...Problem importing dll
I have an application that used some external com dlls. So in my application
code i've imported those dlls as
#import "path of external.dll"
and i'm using smart pointers to instantiate those coms as
The problem i'm facing that those external com dlls are not mine so every
time they are modified by thier owner i've to recompile my code too with the
latest dlls otherwise my code does not work and i get Obj = NULL in the
above statement. Actually those external dlls are of a software that i've
provided integratio...How do I automatiicaly redefinie Source data range for a chart?
I have A Chart Defined by Category (X) values in Collumn B and Y values in
Collumn C. Right now Both are defined by rows 4 to 114.
I would like to be able to have the chart automatically redefine itself so
if I put a value in C115 the chart would automaticaly set Y value range to be
C4:C115 eithout having to manually define chart. Is this possible? If so
how? I've tried OFFSET bu so far no luck.
If you turn your data cells into a List, or Table in xl2007, the chart will
The named range approach will work if you set up the names correctly.
See here for more info...Problem with excluding an account from budget
I want to see my credit card payments (i.e., transfers to a credit accounts)
as an expenses in Money reports. I know that I should exclude credit accounts
from budget to achieve it, but it's impossible:
- I'm going to Account Settings, and "Include this account in the budget
planner" option is set
- Trying to clear this option simply does nothing - it's still set and
Is it possible that I've forgot something else to do before excluding an
account from budget?
If that's really your goal, the only sane way is to track them that way from
t...Exchange data backup
I'm worried emails backup of the small office.
Does SBS2008 Exchange server has a direct backup capability of whole mail
How to backup every night Emails from server to external harddisk?
Does Exchange server needs to be stopped before backup?
SBS2008 Takes care of it.
look at the comments section
Russell Grover - SBITS.Biz [SBS-MVP]
MCP, MCPS, MCNPS, SBSC
Microsoft Certified Small Business Specialist
24hr SBS Remote Support - www.SBITS.Biz
Question or Seco...Data Save error
GP Ver 6.0. Recently I am facing an error with normal users unable to save
records, where as the system administrator is able to save the same
information. Please advice on this error, what has to be done.
I have disabled the windows user ID of the Database owner. Thinking of this
made Dynasa as the DBO.
Database is having enough free space available.
How big is the company database? Is it over 10GB?
"Matthews" <Matthews@discussions.microsoft.com> wrote in message
> GP Ver 6.0. Recently I...extension DLL problems
I have CPropertySheet class with three CPropertyPage" classes in an
I compile it, and run it. I get the .LIB and the .DLL files etc.
in the client application I incluce the .LIB file and then I have add a
button which when
pressed will attempt to run the following code:
CPropertySheet myWizard("Import wizard", this, 0);
this code produces the following error:
"Debug assertion failed!"
what is to be done?
> I have CPropertySheet class with three CPropertyPage" classes in an
> e...Archive Problem
I work for an organisation that works in the dark ages. We
use Outlook 98 (8.5.5603.0) with a basic build of NT4
(Service pack 6).
When we use the archive functunality from the file menu we
find that on some emails earlier than the date specified
are not archived to the desired folder. I do not work for
IT and cannot update service packs for outlook.
Can anyone advise me what could be wrong? Was this a bug
in this version. Sometimes some files would be archived
and not all. What date is used? Is it the object's
creation date? It makes no difference whether you have
t...Tab Control Problem
I'm just wondering how I can add controls to tab control pages that
are bound to fields from different tables. I have 3 tables (road,
track and gym) with similar named fields and I want to create a tab
page for each table. Unfortunately, my tab control form only allows me
to view and set controls for one table. So even though I might have a
control bound to a field from table 'road', the information i enter
goes to the table 'track' because that is the default table for the
tab control form. My manual says I should be able to send and view
info from different tables using ...Outlook 2000 Folder Size Problem
I've created personal folders and rules for incoming
mail. I've also deleted mail from Sent, Deleted Items,
Etc. I think the problem is somewhere else...I checked
the Folder Size for all of the folders under
Outlook Today and the Total Size (Fld+SubFld): is 27900K.
However, in the detail below, it does not add up to
27900K (only about 1200K). Could this be some kind of
I can't send email because the exchange server tells me
that my box is full.
Can anyone help with this?
>I take it that you are on an exc...Problem Opening Notebooks on New Server
I have a small office and we all store and use notebooks on our
server. We moved all of our data to a new server yesterday, and now
when we try to open the notebooks we get a message that says: "OneNote
needs a password to sync some of your notebooks", and we are unable to
open the notebooks. Interestingly, if we open the notebook through a
mapped drive to the location, we get the error. But, if we navigate
directly to the notebook through the network, it will open with no
error. We are having no other problems with this mapped drive.
...problem with starting thread
During debugging if we go over the following line of code:
m_pCalculateThread = AfxBeginThread(UpdateDocThread, this);
the thread DOES NOT start, but if we go into AfxBeginThread function,
the thread DOES start. Any suggestions?
Thanks in advance!
Maybe you can look in the threads window during the debug. You could set
execution to a thread using that too.
"Leonid Nikolayev" <firstname.lastname@example.org> wrote in message
> During debugging if we go over the following line of code:
> m_pCalculateThread = AfxBeginThread(Upd...Worksheet protection problem
I am using Excel 2000, wanting to protect certain cells, but allow user to
filter using autofilter, etc. and how would I do this?
Private Sub Workbook_Open()
Worksheets("Sheet1").EnableAutoFilter = True
Right click on the Excel icon next to File in the menubar
choose view code
paste the code
Alt-Q to go back to Excel
This runs every time the workbook opens. It protects the worksheet and
allows users to use the AutoFilter dropdown lists.
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002...cell range not changing when refreshing linked data- sumproduct fo
The cell range is not updating correctly to reflect the last row in the data
sheet that is being refreshed. 5878 is the correct number of rows and 5824
is not. I can find and replace in my formulas to correct the problem, but it
does it each time the data is refreshed. Any suggestions as to why?
I gave you the INDIRECT option y'day, but received no feedback from you in
that thread. Looks like you're more interested in knowing why? One simple
hunc...Data vs. forms & Unload/reload questions
A .mdb file seems to encompass both the database and all the 'code' (forms,
modules, and logic) used to CRUD the data in the tables.
1) Is there any way to separate the database from the code into separate
files, eg. the db is mydata.mdb and the 'code is in a separate file, eg.
2) Say you have v1.0 of an app and the tables and attributes are populated
with data. You then go and build v2.0 of the app, adding tables and columns
to what already existed in v1.0, and perhaps moving some of the v1.0
attributes into different tables. What is the recommended way to
unload/reloa...Mobile Express set-up problem
After the installation, when I try to add some entities to the mobile
application I get the following error:
I am new to using Excel. I want to create a column that has the days of the
month (1 Nov 03 thru 30 Nov 03). I know there is a way I can put the date
in the first cell and then either paste or drag down and excel will add the
dates sequentially, but I can't seem to figure out how to do it...I did it
once before and don't remember the sequence that I followed. Could someone
please post the steps on how to do this?
Bobby, put the date in a cell, A1, and click on the black square in the
lower right hand corner and drag down
Always backup your data before ...csv-file problems with different regions
I have imported an American csv-file into a German Excel XP. The American
$-values are separated by a "." while the German currency values are
separated by a ",".
So now my spreadsheet reads a value of $ 18.01 as 18. January. All values
above 18.12 are ok.
How can I avoid this problem? Or, can I change the values tediously one cell
after the other? I have not found a way yet as even when I try to format a
cell user defined it automatically changes to the format used in the German
Temporarily change the regional settings on your computer to the same f...Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in
It is customer ID name and billing info but it is like a long series of
I want to be able to have them listed under captions like company name,
contact, address, city, etc.. so I can use the data.
There is an empty row between each entry. Each entry is 3 or 4 rows.
There are about 500 records so i dont want to manually set them up.
Try tinkering around with these steps
Assuming your list is in col A,
data in A2 down
(If data starts in A1 down, insert a new row for the co...Help Problems with Outlook tool bar buttons
I'm hoping someone can offer advice on problems that I'm experiencing with
Outlook 2003 toolbar buttons.
Toolbar buttons usually work fine when I first open Outlook, but after I use
a particular button once, it no longer works. For example, I can create a
task, then assign the task. the next time I create a task, the assign
button no longer works. I have to re-boot outlook to get the button to work
again - then it only works once, etc, etc.
This is also true of many other (but not all ) Outlook buttons, like "Save
and Close", "Recurrence", and others. On...Outlook Shutdown Problem
Office XP standard on XP Pro machine, in a Workgroup with
a file server. Outlook works fine, however when closing
Outlook, all indications are that it has closed, but
opening Task Manager reveals that Outlook.exe is still
running. If you try to shut puter down, Outlook "End
Program" pops up. If you try to reopen Outlook, without
killing in task manager, a second Outlook.exe pops up in
Task Manager, but Outlook never opens. If you continue to
click on Outlook icon, you can open a seemingly infinite
number of Outlook.exe's. Have run "Detect and Repair" and
have ...Problems connecting to accounts
I am having problems downloading from most of my accounts. Some work but most
do not, there is nothing I can do about this, is there?
...Custom Type Charts Problem
I am using Custom Type Charts in Excel, which uses Pivot Table as the Data
The problem that I am facing here is that whenever I Refresh the data using
the Refresh icon, the Custom Type charts LOOSE their formatting.
To make my problem clearer, I am attaching a sample Excel sheet herewith.
In the sample file, go to 3rd sheet "Custom Type Chart" and have a look at
the "Tubes" chart. Now click on the "!" Icon (this is the Refresh icon). The
formatting of the chart changes.
Try this out with the "Normal Chart". The formatting remains the same.
...Display comments as data #2
thanks a lot , this worked exactly as required, the comment go
converted to data
Now just one more thing . is the vice versa possible i.e if i have dat
in column A can it be shown as comment in column B.
the reason i need this is bcos i am shifting some data with thei
comments to MS access(Hence the need to convert omments to data)
processing them and again converting them to excel (the need to conver
data back to comments
sonika's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...