Duplicating MainForm, SubForm and Sub-SubForm
I have an Order Entry Form composed of a MainForm, a SubForm and 2 Sub-
Subforms. The SubForm is a continuous form. The two Sub-SubForms are children
of a SubForm via a foreign key (which is the Primary Key of a SubForm).
There are some instances when customers revised their order by changing just
the amount of orders or by just removing one item and the rest are the same.
To do this, I would like to keep the initial order (record) and create
another record by duplicating the first order then change the amount (or
remove an item whatever the case maybe) on the new record. The...sum total hours and minutes
ok I have read all the questions and answers and I still can't get my program
to work: here is what I do:
July Event StartTime End
8 Purchase cat food / diet pepsi / rug cleaner 1:30 PM 2:15 PM 00:45
15 Pay house gas and phone bills 10:00 AM 10:30 AM 00:30
the format I use for start time is: TIME 1:30PM
the format I use for end time: TIME 2:15PM
the last column formula is: =TEXT(D4-C4,"hh:mm"...Running Total 11-23-09
I would like to be able to have a running total for the month.
therefor the total as of 12/12009 will be 160 and run until the end of the
month and then to start from zero and begin running the total again.
thanks for your help
>>therefor the total as of 12/12009 will be 160 - I believe you mean 12/1/2009.
Your words do not match the math -- Your words say to start over at the
begining of each month so on 12/1/2009 ...Outlook 2000 Sub folder
I am using outlook 2000 and I have a created a subfolder in my inbox however
I am unable to view the folder My Shortcuts on the left hand side of the
screen where all my other sub folders are located. In the navigation bar at
the top of my pane there is an icon called "move to Folder" and the folder is
located here. I am unable to find the location of the folder therefore unable
to open the folder or move it to "My shortcuts" I am in need of your
expertise. I am ok with computers and can follow instructions so please
please please help.
Thanking you in ...Money 2000 and Euro wrong total
I use Money 2000 Pro (vers. 8.0) and my primary currency since 2002 is Euro
(I live in Italia, Eu)
I have a problem since I changed for the former currency (italian lira) to
actual currency (Euro)... (My older bills were in Lira so I've changed them
manually to converse in Euros.)
I made changes on my multiple bills to join new currency and it works fine
(Now I've 2 bills [1999-2006] in Euro) but...
When I see to the main page with both bills summary the total of money is
Bill 1 : 1000,00 Euro
Bill 2 : 2000,00 Euro
SubTotal (Sum of Bill 1 + Bill 2...What are the formula for calculating ROI all dates (Total return all dates)
From http://money.mvps.org/articles/portfolio_columns.aspx, it says
that dividends should be included in calculation of ROI all dates(Total
return all dates)
So the formula for ROI should be ((market price - purchase price)+
dividend) / purchase price.
Is this correct?
However, what I am seeing is that ROI all dates is calculated as
(market price - purchase price)/purchase price.
Is there any other parameter that includes dividends also
In microsoft.public.money, email@example.com wrote:
> From http://money.mvps.org/articles/portfolio_columns.aspx, it says
>that dividends should be i...sub-process
What is the sub-process function in the workflow?
How do you set one up?
Why would you use it?
A sub-process is a way to call a manual rule. If you create a manual rule in
workflow called Rule A, in another rule you can insert a sub-process and
select the manual rule to run.
This is a helpful way to create loops and if/then rules that trigger other
"David M" wrote:
> What is the sub-process function in the workflow?
> How do you set one up?
> Why would you use it?
...Growing Total using Autofilter in Excel?
I have a spreadsheet i am working on in Excel 2002. I have a ton of
data which i am sorting to date using AutoFilter, which is working
fine. when the data is not filtered i have a rolling total which adds
up the whole thing like this.
1 100 100
2 100 200
3 150 350
but when i use the filter i see the larger totals in the list (which i
understand) What i want is the same thing in a new column, but for
only the current data from the view. example
7 150 150
8 100 250
9 200 450
I have tried using sum and subtotal but it doesnt allow + example:
=sum(b7+a8) and =subtotal(9,b7+a8...Sub, Private Sub, Public Sub
I got a different lap top and when I moved my Personal.xls from one to the
other some of my macros were not on the list of macros when you go to
tools>macros. Although when I look in the code they are there. I figured
out that the ones that were "Private Sub" macros were no working. I also
figured that when I changed them to just "Sub" they worked. I do know that
if "It aint broke don't fix it, cus to try is usually to fix it till it is
broke." But what is the difference between "Sub", "Private Sub", & "Public
...Cascade current view to sub-folders
Is there any way I can set a custom View setting to a set
of folders (e.g. set a view setting for a high-level
folder and then have it cascade to all sub-folders)? By a
custom View I mean the way that items in a folder shoud
look - i.e. font settings and the like.
I have the following problem:
I have an Excel file with Column B 'Quantity' and column F 'Sector'. Now i
need to count all the quantities within the same sector
Sorting + AutoSum isn't an option, since the file has other calculations in
it as well, that also depend on a sort.
There's in my Dutch version a function 'DBSUM' and a function
'TURNTABEL.FETCH' ... these are translated terms, so I don't know if they
match with English versions ... but could someone please tell me how these
functions work, since i can't get them right (n...Great Plains payroll transaction entry total dollars per employee
When I enter transactions in payroll batches, I would like to see the entry
window show me a dollar total (rate x hours) as I'm entering the transactions
(per line) and then a dollar total per employee.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.mi...Shift wise Totals
I have a shift 6 running after midnight, hence the productions shows on the
next day, can I have the production for the same day.
The shifts timings are shift 1 - 6am - 9am, shift 2 - 9:30am _12:30pm,
shift3 - 1pm - 4pm, shift 4 - 5pm-8pm, shift 5 - 8:30pm:1130pm, & shift6 -
00am - 2:30am
Thats the production for the day, but since shift 6 falls after midnight,
all that is process falls on the next day, while actually the production is
for the previous day.
Subtract, logically, 2h30 ?
SELECT ..., SUM( something) ,...
GROUP BY DateValue( dateTimeStamp - #02:30:00# )
Vande...A way to create sub-categories?
I want to group contacts by category and then a sub-category for easy
viewing. Apart from creating a new field for sub-category is there a way of
doing this? Outlook doesn't seem to support sub-categories.
Author - Special Edition Using Microsoft Office Outlook 2003
Lead Author - Access 2003 VBA Programmer's Reference
Author - Absolute Beginner's Guide to Microsoft OneNote 2003
"Casebase" <firstname.lastname@example.org> wrote in message
news:%23rx5a...Microsoft Office Doc Image Writer is still printing ghosts and it's totally freaking me out!!!!!!!
Every time i use 'Microsoft Office (2003) Doc Image Writer' (no printer at
home) no printed document appears - ever!!!
But when I try to reprint the document it's 'dis-embodied' ghost appears
only in the save as dialogue box (even after a reboot)
I think this is yet another Vista bug (Vista can't see/find existing
I've reported this before without cure
Anyone know the name of it's predecessor (we use at work) which works
perfectly - creates it's own document type albeit can't remember the
I cannot repeat the problem. But ...Are sub-totals able to be set to be bold automatically?
I have a large amount of sub-totals, which at the moment are not bold unless
I do a manual job of making them so. Is there any way of automating this
process in the sub-total procedure?
You can use conditional formatting to bold the rows. There are
instructions in Excel's Help files, and on the following page:
Select the columns that contain the table
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the textbox, enter a formula that refers to a column in which the
"Total" text appears...Sub or Function not defined?!
In a further attempt to debug the disabled=false problem, I wrote out some
enabling code in the subforms and call it from the parent. Here is the code
in the subform...
Public Sub UpdateFillsFormState(canEdit)
QuantityField.Enabled = canEdit
PriceField.Enabled = canEdit
TaxField.Enabled = canEdit
NetField.Enabled = canEdit
If Me.RecordsetClone.recordCount > 0 And QuantityField.Enabled = True
Over in the main form I wait until I know the form is loaded and set up
properly, then I do this...
Public Sub SetupFillState()
canEdit = isEditable()
Call Update...Sub error
I have created this macro but everytime I run it the Columns it hides is
incorrect. It hides FGHIJK it should only hide GHI. Can anyone tell me why
this is happening?
Thank you for your help.
' Done_Changes Macro
Selection.Locked = True
Selection.FormulaHidden = False
Selection.Locked = True
Selection.FormulaHidden = False
Selection.Locked = T...Filter by Form with sub form crash
I'm having problems with filter by form causing access 2003 to shut down.
Looking at the Northwind database the same thing happens.
If a main form has "new additions" setting to no and has sub forms
filter by form is used and the data serched on the main fom returns null (
eg some one filters Michal insted of Michael, access crashes.
My own forms are linked to queries which results in not allowing "new
additions" so this has the same effect in access shutting down.
any adivce would be great
with thanks Mike
Mike, I just tried this in Access 2003 ...disabling all menu and its sub menus
how to disable entire menu and its sub menus.
i tried the following code it gets the Menu ID but is not disabling the menu
HWND hwnd = GetSafeHwnd();
hMenu = ::GetMenu(hwnd);
for (int i=0;i<nCount;i++)
//get the sub menu
//get the number of items in the submenu and disable them individually.
for (int j=0;j<nSubItems;j++)
EnableMenuItem(hSubMenu,G...running a Sub in a class module from a functionin a general module
If I have a sub in the module for a form named frmActivity which contains a
is there a way to call that Sub and run the procedure from a function in a
Thanks in advance,
"Paul" <email@example.com> wrote in message
> If I have a sub in the module for a form named frmActivity which contains
> a procedure named
> Sub cmd_close_form_Click()
> is there a way to call that Sub and run the procedure from a function in...How do I import sub.....
Ok, I have my personal contacts folder. It is called by default "contacts"
I have out public contacts folder. It is called "IT contacts"
How do I get the info from IT contacts into my personal contacts.
I tried exporting a personal file, then importing it into my personal
and it did, in a subfolder. I don't want it in a subfolder (my pda won't
I want it added to my personal contacts folder...
Ctrl+drag and drop the individual items.
Sue Mosher, Outlook MVP
Microsoft Outlook ...sorting cells in a sub routine
I'm trying to Sort a block of cells as a step in a routine. The size of the
block varies, but it will always be Sorted in Ascending order by the last
The routine works by having Excel evaluate the CurrentRegion of the
ActiveCell with the CurrentRegion cells surrounding it. If they match, the
All of this works fine except when the sheet is protected.
As far as I can tell, CurrentRegion causes an error message when the sheet
is protected. How else can I establish the area to be sorted?
I'm currently doing it by finding the first and last Columns in the Region
an...Excluding multiple checking accounts from budget totals?
Running Money06, and I have two checking accounts synching through Bank of
America. Everything there is working well, but one thing that I dont like is
that the totals for BOTH accounts are added together.
I have two accounts, 'personal' and 'class', and both accounts are shown in
the net balance statements, the 'spending by catagory' chart on the home page
I would like to keep synched with my class account, but want it excluded
from all of the balances.. any suggestions?
"Raichean" <Raichean@discussions.microsoft.com> wrote in mes...Sync all sub folders from a specific public folder
I know how to sync a single public folder, but is there an easier way to
sync a public folder and include all levels of sub directiores related?
Thanks in advance
> I know how to sync a single public folder, but is there an easier way
> to sync a public folder and include all levels of sub directiores
> Thanks in advance
You have to drag all folders to favorites in order to sync them to offline
files. Subfolders too. Depending on your v. of Outlook you may be able to
easily select all PF favorites for s...