Home Page Ending Balance?
For some reason, my checking account balance shown on "My Money Home Page"
(MS 2004) no longer agrees with the balance shown in the register. It's off
by a few dollars. There are no future transactions - all balances are current.
I've tried changing the opening balance, but that simply changes the
register amount. The register balance and home page balance still don't agree.
Any ideas? Thanks!
Make a backup and try repairing the file. file: repair money file: quick
"Dave M." <DaveM@discussions.microsoft.com> wrote in message
n...Tab to specific cells
I am using excel 2002 and my boss 2003. I want to tab to specific cells in
my work sheet. Can anyone help me get started?
You could try the named range approach.
Select your *second* cell for data entry and then hold down <Ctrl> and
continue to select all the rest of the desired cells in order, ending with
selecting your *first* cell *last*.
While the cells are still selected, click in the name box and give this
range a short name such as "Entry1".
Now, when you're ready for data entry, simply click on the range name in the
name box. The focus for the range is th...Slow when closing a form
1. Front-End - MS Access 2003
2. Back-End - SQL Server 2005
3. OS - Windows XP
I cannot understand why it takes a 5-7 seconds to close our Invoice form.
The Invoice form has several data components in it that retrieves data.
The code in the "Done" button of the form perform the following:
b. Check other loaded forms "IsLoaded()"
The form has also a code in the "Close" event which only checks for loaded
forms again "IsLoaded()".
"Ben" <firstname.lastname@example.org> wr...Moving Exchange 5.5 #3
We currently have W2K3 domain with external 2-way trust with NT4 domain where
Exchange 5.5 is located. I'd lik to move my Exchange to the new server W2K
member of the W2K3 domain. During the change I'd like to change also the
organization and site name. Does anyboby have any information on how can
easily do this without any client reconfiguration?
On Tue, 25 Jan 2005 09:31:06 -0800, "TagaR"
>We currently have W2K3 domain with external 2-way trust with NT4 domain where
>Exchange 5.5 is located. I'd l...Move Detail on Report
I used the wizard to create a form. Everything is fine except I want to
have the subtotals under the group headers but the default is for the
opposite. Is there a way of 'dragging and dropping' the detail line?
On Jul 13, 6:28 pm, Andrew <And...@discussions.microsoft.com> wrote:
> Sorry, no, that didn't anser my question. When looking at the report design
> I have various group headers (working) and the detail after them. I want my
> detail above them - any ideas?
> "Maurice" wrote:
> > Andrew,...Display/Hide a Form Control/Field Based On Another Field Value?
Hi all, I have to Combo boxes on a form. The first one I would always
like users to see. The second, however, I would like hidden if the
first box has certain values selected. So, if ComboBox1 has values of
1 or 2, I would like ComboBox2 to show as normal. If ComboBox1 has a
value of 3, I would like ComboBox2 hidden. Is there a relatively
simple way of doing this, if at all? Thanks for your help as always!
You have to take care of 2 things:
(1) When you move from record to record and the combo box contents changes
(2) When the user changes the contents of the combo box
For (1), inse...Cross Tab Query
I have a access database with SQL backend. The table labproofs has charges
listed by report date, with the below query, I can run a cross tabquery with
the end date selected from a form (monthly report), and it gives me the 12
month data from the end date selected. However, the problem I face is for
example if the end date selected is feb 28th, I get the data for previous
months as Jan 28, Dec 28, Nov 28 ......, I want data for the month end
numbers like feb 28, Jan 31, Dec 31....., I am not sure what I am doing wrong
PARAMETERS [Forms]![Monthly Reports]...slow moving larger items between folders...
hello, i'm on exchange 5.5 and there are about 20 or so fairly large
When moving messages containing attachments between folders in my
mailbox, it takes ages!
It takes about a minute to move a message of about 250k.
It never used to be like this. I'm fairly sure this is a recent
Any ideas as to why this has happened and how to solve it?
...Automatically moving data #4
Thanx for all the help.
I'm going to make the file smaller first. Where do I email it to
multiplan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1591
View this thread: http://www.excelforum.com/showthread.php?threadid=27391
Thought I gave you this reply earlier ??
GMT+8, 1� 22' N 103� 45' E
xdemechanik <at>yahoo<dot>...How to display page tabs vertically?
How do I set tab pages be displayed vertically (left side). By default, they
are set on top, I need them on the left side. Please assist.
Thank you for any tip/help provided.
Please post all your inquiries on this community so we can all benefit -
"Adnan" <email@example.com(donotspam)> wrote in message
> How do I set tab pages be displayed vertically (left side). By default,
> are set on top, I need them on the left side. Please assist.
> Thank you for any tip/he..."Move to bottom of range"
I have some code that adds the contents of one sheet to the end of
another. How do I correctly select the first empty cell below the first
sheet that I want to add data to?
'Move to bottom of range
^^^ This is where I need work.
Can I simply perform a cursor key move down one cell?
How do I code cursor key operations?
It is very unlikely that you will need to select a cell to do what you want
but here's a couple of methods
Select empty cell after last used cell in col A
R...Auto Filling fields in form
I am new at creating code and would like to have two fields populated when
the record is reviewed.
One is the user name and the other is the date reviewed.
There is a form which contains the Member Name and ID number. I would like
to add the two auto fill fields in the Parent form and have it fill in the
subform fields for that particular member using a trigger of some sort.
Any advice would be appreciated.
Access forms display data... Access tables store it.
If you want to see data from a record in a table in your form, your controls
in the form need to be poin...User form problem
I have made a userform, which works great. However i have a problem.
I would like the userform to only load up when the template file i
opened. I do not want it to load when saved workbook copies of th
template are opened.
The system I am creating is an invoice system, and thus the loading o
the userform is only necessary upon opening the template, not any othe
Is this possible to do? Any help would be appreciated.
Message posted from http://www.ExcelForum.com
You can check the Len of the Thisworkbook.path in the Macro.
A template have no path
I...Sizing a form in Access 2007
I've been working with Access for the past decade, and recently upgraded to
2007. I've created several forms but can't figure out how to make them the
size I want in display view. In older versions all I needed to do was pull
in the left side and bottom of the form and minimize to the size I wanted.
2007 doesn't appear to have this ability.
I was able to get the display size I wanted by setting the form to popup and
modal, but this keeps the form on top. I tried pulling the form under the
ribbon. This allows reports opened with the form to display, but I can...Return the name of the object I click on in a form
How do I go about returning the name of an object on a form. For example if
I set the "On Click" event procedure on a rectangle object to return:
I get the form name. What I want to do is click on the object and be abe to
reference it's properties such as Tag to run other code based in these values.
As always any assistance is greatly appreciated.
For the name of the control try
For the control itself use
"John Dumay" <JohnDumay@dis...Vertical Page Break
Is it possible to force a vertical page break on a report? For
example, I have a report that is 20 inches across, and I would it to
"break"/start the new page at 10 inches. Now, fiddling with the page
setup and page layout is fine when I am working with only one printer,
but the formatting gets slightly messed up when I am printing across
different printers, to PDF, etc.
Any ideas on how this vertical page break can be done?
that sure would be nice to have
I'd reccomend just putting the page 2 below page 1.. and use more
subreports if you run out of room
On ...how to enable font button within mail format tab
I am trying to change the font size for composing email
with outlook 2002. When I click, tools, then options,
then select the mail format tab, my font button (under
stationary & fonts) is greyed out. How do I get this
Font button only appears in HTML mail. Change the format in the email and it
will be available.
> I am trying to change the font size for composing email
> with outlook 2002. When I click, tools, then options,
> then select the mail format tab, my font button (under
> stationary & fonts) is greyed out. How ...Modifying a pages Refresh Rate
Windows XP(Home) SP3, OE6, IE8; Plenty of RAM & HHD space. Continuous checks
1.4Ghz, VIA Technologies, Inc. 8 kilobyte primary memory cache, 256 kilobyte
secondary memory cache, P4X266-8233, Enclosure Type: Desktop V2 Premier,
Windows XP (Home) SP3, 2 Calvary External USB 400/500 GB Hard Drives (NTFS),
1.5 GB Ram, Upgraded PSU, Belarc Advisor, Multimedia - lists, MPU-401
Compatible MIDI Device - Realtek AC'97 Audio for VIA (R) Audio Controller -
Standard Game Port. Circuit Board: P4X266-8233, Bus Clock: 100 megahertz,
BIOS: Award Software International,...Data from Form to Subform to Table
I have a main form for material inspection, and another form for the
inpsection results, and tables for each that store the data. For example, you
have to enter the PO# and P/N on the main form, as well as some other info,
then you click to open up the inspection results form in datasheet view. The
inpsection results form shows the PO# and P/N that you entered on the main
form, but it wont store the info in the table for the inspection results. Can
someone please help me figure out how to get the info to store in the
inspection results table as well as the material inspection tab...How to write figures in words form?
If I want to write 120 in words form (One Hundred twenty), how I can do it in
> If I want to write 120 in words form (One Hundred twenty), how I can do
> it in
Bryan Hessey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21059
View this thread: http://www.excelforum.com/showthread.php?threadid=400011
...moving publisher #2
I bought a computer with publisher bundled (no cd). Now I want to put it on
my new laptop. How do I move it from the desktop computer to the laptop????
without the source CD...you don't.
Microsoft MVP Expression
"Cliff" <Cliff@discussions.microsoft.com> wrote in message
> I bought a computer with publisher bundled (no cd). Now I want to put it
> my new laptop. How do I move it from the desktop computer to the
I...Exchange SP2 "Move All Replicas"
Was curious if the "Move All Replicas" feature will move Public folder
replicas from Exch2K to Exch2003 w/sp2? Also, does it matter if some folders
are already replicating?
On Wed, 12 Apr 2006 13:22:02 -0700, Jim@bg
> Was curious if the "Move All Replicas" feature will move Public folder
>replicas from Exch2K to Exch2003 w/sp2? Also, does it matter if some folders
>are already replicating?
Thanks, guess that was an easy one. Not much dir...Moving a row from one sheet to another wrongly leaves blank-row artifact.
Moving an entire row within a sheet in Excel XP is implemented
Select the entire row, cut it, go to the target location, and Insert
Copied Cells. The target row is inserted (pushing all rows below it
down), and the source row is deleted (bringing all rows below it up, as
NOT so when the target is in another sheet in the same workbook.
Excel inserts the target row correctly, but fails to delete the source
row. The row still exists (only it's blanked out). You have to remeber
to, tediously, return to the source and delete the blank row. Which
means that if you intende...Main form causing multiple errors
History: I have created a database for my company to track all
incidents, equipment issues, and more. The database has been in use
for over a year and has been working quite well. It is a split
database with the back end located on a network hard drive and the
front end updated through autofeupdate. The database is setup for a
multiuser environment. I have integrated functions to send email
messages and create reports daily. Recently, I have added six list
boxes to the main form. Each listbox displays information on current
records. For instance, one listbox shows all the open equipment
ticket...How can I go to a specific page number in a large document
How do I go to a specific page number in a large word document.
Read the replies to your earlier identical post
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
"yisaajao" <firstname.lastname@example.org> wrote in message