Keep all forms maximized
I have a number of forms that are displayed one at a time. I need to display
them all maximized. I can do this fine, but there's an annoying problem
When I close one form to open the other, the next form first appears NOT
maximized and ONLY THEN gets maximized. This causes a glitch in the user
So, how can I make forms change smoothly between each other?
Thank you in advance
Hope this helps. I build a macro that has, open form, maximize for each form
and also a close form line for each form. In the properties of each form I
refer to the correct macro in the ...Year end payroll tax update
I see that Microsoft recommends updating to service pack 6
before installing the year end payroll tax update. We are
on SP5 and wonder how critical this latest service pack
really is. Does anyone know what will happen if we just
install the tax update, without installing SP6? Thanks!
I was in the same situation and decided to install
Service Pack 6 because we do 1099's from Payables and
there was a fix in SP6 for them. The install of Service
Pack 6 and the Year-End update went well and we haven't
had any problems since.
>I see that Micro...Update
What is Happening?
This message is to inform you that Microsoft will soon begin discontinuing
newsgroups and transitioning users to Microsoft forums.
As you may know, newsgroups have existed for many years now; however, the
traffic in the Microsoft newsgroups has been steadily decreasing for the
past several years while customers and participants are increasingly finding
solutions in the forums on Microsoft properties and third party sites. This
move will unify the customer experience, centralize content, make it easier
for active contributors to retain their influence, miti...VLookup not returning the last value
I am using VLOOKUP =VLOOKUP(D7,X4:X7:Y4:Y7,2,FALSE)
My problem is that X7 is not showing in the dropdown list.
The dropdown is simple text a value just like the other rows.
Can anyone help me understand why I don't see this value?
Thanks very much!
Microsoft MVP Excel
"George" <George@discussions.microsoft.com> wrote in message
> I am using VLOOKUP =VLOOKUP(D7,X...I want to ignore invalid values in scatter chart
I have an x-y scatter chart which uses values calculated from other sheets in
the workbook. Sometimes these values are invalid, and therefore I use "IF"
to render the appropriate cell blank. The entire series then disappears from
the chart. I just want that point to bu uncharted. Any ideas?
I can't reproduce you problem. Depending on the formula used my data
points either do not show, as intended, or have the value zero.
Are you using a formula like this?
=IF( test , value , NA() )
Phil Rowe wrote:
> I have an x-y scatter chart which uses values ca...Control if a form updates table
I would like to know how best to accomplish this data entry form requirement.
I have a form with a number of fields which is linked to a table. When the
operator opens the form i would like all the fields to be blank and the user
can tab through the fields as necessary. I have two command buttons. One
allows to exit the form (all set with that one) with no saving of the form
data, while the second button opens a message box which asks the operator if
they wish to submit the information on the form (within the fields) Y/N and
the message box has all the data from the fields li...Using an update query to update amount in stock automatically
I have created a database to keep a track of orders.
In the stock table I have a field called amount in stock.
In order table I have a field called order quantity.
I have created an update query to update amount in stock to [amount in
I wish to create a macro to run the update query on my order form once the
sale is confirmed.
My problem is that I want to just update the single record on the order
form, and not all items of stock from all existing orders.
I know I can add a parameter criteria to my update query (i.e. enter order
number) so that only stock relating ...Updating a CStatic text
I found posts similiar to this question but not the answer. I have a
CStatic with say 3 lines of text
bla bla bla bla bla bla
bla bla bla bla bla bla
bla bla bla bla bla bla
The when something happens this is replaced by a single line:
The problem is that when I call SetDlgitemText it displays the new text
ontop of the old one for a short while. I guess it is until the
OnEraseBkgnd is called. What is the correct way to solve this so that
the new message is displayed alone directly and not ontop of the old
Seemed to solved thi...After update Not update Text Field
I have created a subform based on a table. Within that table there is a
product name field which retrives a list of product names and prices from the
Products table. I to use the subform to enter product and then get it to
automatically update the price field.
I have read many entries about using after update to do this, but I just can
not get it to work. I select the product in the drop down and nothing
happens. I am pulling my hair out. The code I used was
Me.Product_Price = Me.Product_Name.Column(2)
Can any one help me
>I have created a subform based on a t...go to form on click
Hello all, I have a little dilemma here.
On my main menu form (frmMainMenu) I have 2 unbound combo boxes. They
display 1) Recent incidents from 1 table (updated by 4 forms) and 2) a
running Chronological Log - 1 table (updated by 1 form). What I want to do is
be able top click on a specific record in my combo box and then be taken the
applicable form and entry.
I have seen something like this in another database that I worked, obviously
not created by me!
How can I accomplish this. Here is the code from my first combo box:
SELECT tblSENEIncidentLog2008.MONTH, tblSENEIncidentLog2008...How to disable the pop up for enable auto update?
I have imported an external link in to excel, and set it auto update when it
opens, but whenever I open this file, it pops up a window to confirm whether
you like to enable auto update or not.
Does anyone have any suggestions on how to disable the pop up window for
enable auto updating links?
Thanks in advance for any suggestions
on the menu bar>edit>links>startup prompt
pick you choise.
> I have imported an external link in to excel, and set it auto update when it
> opens, but whenever I open this file, it ...custom contact form
I created a custom contact form. When I try to create an envelope or letter
from the contact window, only the name of the contact generates, not the
address. What do I need to do to get the address to generate (i.e. the
delivery address) into the envelope or letter?
Would it be correct to assume that you created custom user-defined fields
for the "delivery" address in your custom form instead of assigning the
"delivery" address fields to one of the standard address field sets?
If you have - then the answer to your question is contained in this thread:
Me...2007 Deluxe update...CRASH
Money Deluxe 2007 just told me it needed to update. I allowed this
thing to happen (silly me), and now when I try to start it, I get an
error message that tells me it cannot find checksum.exe, and that I
must reinstall from the original disks.
Silly me also purchased it as a download, and didn't pay an extra 6
bucks to get multiple downloads, or an extra $10 bucks to get a CD
(cheap silly me).
Am I screwed?
Thanks in advance...
In microsoft.public.money, villagedweller wrote:
>Money Deluxe 2007 just told me it needed to update. I allowed this
>thing to happen (silly me), and n...The on the server published free/booked-information could not be updated. The task could not be executed OL 2000
outlook 2000 (german) running with windows xp (german) gives the following
error message window when quitting after adding a date in my personal folder
calender from a other user:
"The on the server published free/booked-information could not be updated.
The task could not be executed"
Please help me fix this message. Thank you.
Well, the short version is that for whatever reason, your outlook can't
connect to your free/busy server to update the information. What causes the
error depends on your network configuration.
Diane Poremsky ...Filter Table based on Cell Value
I have an Excel (2007) worksheet that is linked to an MS Access (2003) table.
When I refresh the data, the entire table comes over. I would like to filter
this data based on the value of a cell in a different worksheet (same
workbook) so that it only brings in the data for the specified value. I would
also like to specify which fields I want to bring in (like I said, the whole
table comes over).
Example: My Access table has daily transaction records and a "transaction
date" field. I would like to only bring in records that have a "transaction
date" that is...Formula update automatically
Please look into the formula & suggest.
The excel sheet is fille-in as below:
Column A B C D
Row 1 2 6 5
Row 2 20 30 90 D2=A$1*A2+B$1*B2+C$1*C2
Row 3 2 4 8 D3=A$1*A3+B$1*B3+C$1*C3
& so on for further rows.
What I need is, if a column is added between, say, B & C, then th
formula in D column should update for the added column & similarly fo
Is there a way?
I would prefer excel formula solution. If code is the only solution
please write the complete code. The undo button should not beco...How to force rebuild and update data from msproject to project server database
(I use MS Project Pro 2003 connect to Project Server)
I have a ms project file (ABC.Published), in this file I have 800 task. In
the project server database, table MSP_TASKS, this project has 800 rows, but
there are 600 rows in the MSP_VIEW_PROJ_TASKS_STD. I forced rebuild data
with this help:
but data in MSP_VIEW_PROJ_TASKS_STD remain 600 rows.
Is there another way to force rebuild MS Project Server Database? I need to
see the log for project server error, where can I see?
...converting text values to number & decimal values..
I have any array which read a csv file and I am using split and populate
these fields into my table..
Now I want to convert my text fields to number and decimels respectively.
I tried the following functions but this works fine if they are number and
fails it was text value.
TESTID = CInt(sampleid) 'CInt(myarray(1))Convert to number
CT_num = CDec(ct_val)
Message posted via http://www.accessmonster.com
Test to see if they are numeric first.
If IsNumeric(sampleid) Then
TESTID = CInt(sampleid)
I just installed MS Money 2005 and am using a regional bank named Central
Carolina Bank (CCB Online). The bank is in the list when creating a new
account and it's a simple checking account. I've configured Money for online
updates, providing my user id/password, etc. (I'm also using MSN Billpay)
The automatic updates "seem" to work in that the bank balance is updated and
the status shows that the call was successful. However, I don't see the
transations in Money's account register. If I manually connect to the bank
via a browser and download an OFX file, th...query a table and subform
I have 3 tables
1. Printer table: printerID, ModelID, SerialNum, MACAdd
2. Toner table: TonerID, ModelID, PartName
3. Invoice table: InvoiceID, Date, Qty, PrinterID, TonerID
How can I pull up toners based on the printerID in Invoice table? I set the
TonerID as a combo box, Could anyone help me with the query that i need. The
inovoice table actual is a subform under printer in the Form. so when I
choose the printer from the main form the subform printerID changes
accordingly, I just don't know how to generate a list of toner for user to
choose based on the printer or m...How to determine the value? 04-12-10
If today is the last day of this month, then return today+2, else today.
Does anyone have any suggestions on how to determine whether today is the
last day of this month or not?
Thanks in advance for any suggestions
"Eric" <Eric@discussions.microsoft.com> wrote:
> If today is the last day of this month, then return today+2, else today.
> Does anyone have any suggestions on how to determine whether today
> is the last day of this month or not?
=if(today()=eomonth(today(),0), 2+today(), today())
If you get a #NAME error, look at the H...Update formulae
Financial planning spreadsheet containing many long interdependent formula
needs to be updated from 04 to 05. Is there some quick way of editing this
The answer is "Probably yes", but will you please provide an example of
a formula? If it was a simple search and replace you probably would
have done it already. Is it a matter of changing a cell reference from
'SheetName'!A1 to 'SheetName'!B1, where A1 is a 2004 total and B1 is a
...Charting null values
I have a chart that is plotting null values. I tried the formula
=if(C25="",N/A(),Sum(C22:C25)). I've also deleted the formula to create a
completely null cell.
I've been to Tools, Options, Chart and selected
Plot empty cells as
Not plotted, zero and Interpollated
As well as turning Plot Visible Cells only (turned it on and off)
Nothing seems to make a difference.
Stephanie, what kind of chart are you using? Can you give an example of how
your data table looks like?
> I have a chart that is plotting ...updating with now()
Using 2003. I have a work sheet, at the bottom I have "Updated" and in the
next cell I simply put in =Now(). This brings up the date and time each time
I open. Now what I want to do is see when I last opened and updated. How
can I do this
Le t's say you want cell B9 in Sheet1 to contain the date the last time the
workbook was saved. Put the following event macro in the workbook code area:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Sheet1").Range("B9").Value = Date
Because it is workbook ...KB972270 update won't install on XP SP3
Security Update for Windows XP (KB972270) will not install manually or
automaticly via windows update. I get the response "Some updates could not
Other updates installed OK. This seems to be the only one not working.
When I manually installed I attempted to use the following approach:
WindowsXP-KB972270-x86-ENU.exe /log:c:. /verbose
It fails with two Setup error messages in a graphical text box:
the system cannot find the file specified"
installation did not complete"