TempVars unusable in field default value
I'm trying to use a temporary variable to keep track of which CSR is
I have a macro which prompts user for ID code, which is stored in the temp
On a form control default value property, I can use the expression
[TempVars]![TempUser], which will populate that user's ID code into the
However, I cannot use that same expression in the tables field default value
property. If I try, when I save the changes to the table, I get the error
message "Could not find the field 'TempVars]![TempUser'. "
Any ideas why I ca...[ANN] Office 11.3.8 update
A new security update just came out.
I suspect it requires 11.3.7 to install.
Anyway, time to run the Microsoft Updater or to grab it from
--- Mac:MS MVP http://www.cortig.net/wordpress/ ---
http://www.mvps.org - http://mvp.support.microsoft.com
MVPs are not MS employees - Les MVP ne travaillent pas pour MS
Remove "NoSpam" to e-mail me - Retirez "NoSpam" pour m'�crire
I just let the Microsoft AutoUpdate do its thing. The only Office...Worksheet Auto update
I need to find a way to automate a process.
Is there a way to automatically replace the content of a worksheet with the
content of another one?
Every morning I get a sales report in excel for the previous day sales. I
save it in a folder and then I do a pivot table on this sheet to determine
sales by product category for example.
The following day, I open the previous day file, replace the sales report
with the new one and then refresh my pivot table.
Is there a way to have my sales report update anytime I get a new sales
To be more clear
I have a workbook with two tabs: Pivot...rounding up values
Has anyone done round up of values to the nearest dollar.For example I want to give a 10% of the price to my customers but if the result is other than .00 then I wanted to round up to the nearest dollar amount.My calculation using sql has been price * percent and then subtract the value from the price, then what do I need to do to roundit up??Thanks for your suggestion.Also I have a problem with my customers that I am extracting and the query does return all the values from 2004 and 2006 that are equal except for the price I have given them, how do I get only the latest ones in 2006 and not th...Can't create Organizational Forms Library in Exchange 2003 with SP
I cannot create an Organizational Form in EFORMS REGISTRY folder (from First
Administrative Group->Folders->Public Folders->EFORMS REGISTRY in ESM). When
I right-click the EFORMS REGISTRY folder and select New, there is no
Organization Form. Instead, I only see Public Folder in the popup menu. Do
you have any idea why Organizational Form menu does not show?
My Exchange Server is Exchange 2003 with SP2. The login user is Administrator.
Could you please help me? Thank you very much.
Is that account member of "Enterprise Admins" group?
Yang Zhang wrote:
&...Pass parameter from FORM to QUERY
I have an append query that I trying to call from a cmd btn...but it
prompts me for the parameter(ie QuoteID)...
How do I tye it into my call:
Dim stQueName As String
stQueName = "Quote Query"
DoCmd.OpenQuery stQueName, acNormal, acEdit
On Apr 13, 12:56 pm, jlt...@hotmail.com wrote:
> I have an append query that I trying to call from a cmd btn...but it
> prompts me for the parameter(ie QuoteID)...
> How do I tye it into my call:
> Dim stQueName As String
> stQueName = "Quote Query"
> DoCmd.OpenQuery stQueName, acNormal, acEd...Office 2007 forms
I am creating a form with office 2007, will those people who do not use
office 2007 be able to fill in my form? should I save it in a particular
Provided you start from the normal template, don't use fonts that were
introduced with Word 2007, and save the form in Word 97-2003 document
format, anyone with Word 97 or later should be able to open it. Use only the
legacy form fields, to which end
http://gregmaxey.mvps.org/Classic%20Form%20Controls.htm will make things
<>>< ><<> ><<> <>>< ><<...About Exit and close window.
I have a dialogue base application. There's an Exit button in it. Eachtime
when exit the program by clicking Exit button, fun() and OnOK() executed,
but if the window is close by clicking (x) on the upper-right coner, fun()
will not be executed. How to make this function--fun()--executed when click
(x) button on the upper-right coner?
Rather than calling your fun() from the Exit event handler, call it from the
dialog closing event handler, so that no matter how it is shut down, that
method is called, and so is fun().
hope that helps.
"sxy7711" <sxy771...Estimated Revenue of an Opportunity 03-09-07
It would be very useful to be able to simply quote an amount for an
Opportunity without having to break the amount down into individual
products. This can be done through the Estimated Revenue field of an
Opportunity. When it is set to be user provided, the estimated revenue is not
carried over automatically when a related quote is created. Write-in products
can be added to a Quote, Order or Invoice to achieve that functionality but
as far as I can see there is no facility to
achieve the same thing with an Opportunity.
Basically I would like to set an Estimated Revenue valu...Problem with Update function of CRecordSet class
When I use from Update function of CRecordSet class, it apply to table
after a few time(for example 1 second) when I need to see it at time.
...How to track ActiveControl.Name when switching records in form with multiple subforms
I need to have a global variable always contain the name of the
current form field. This bit of code is attached to the GotFocus
event of all fields and the Enter event of all subforms:
gxCurrentField = Me.ActiveControl.Name
However it doesn't work properly when changing records in a subform.
My parent form contains two subforms in a many-to-many relationship.
The above variable usually ends up containing the name of the first
field in the second subform when switching records in the first
How to correctly code this? Or is there some native variable I'm not
aware of? I...Updating a chart Automatically
Hi, i update a spreadsheet with new data from Access
everyweek. I have a chart that displays the last thrity
days, how do i do this automatically, so i dont have to
keep updating the chart manually ?
Thanks in advance Jay
Jay Richardson wrote:
> Hi, i update a spreadsheet with new data from Access
> everyweek. I have a chart that displays the last thrity
> days, how do i do this automatically, so i dont have to
> keep updating the chart manually ?
> Thanks in advance Jay
See www.tushar-mehta.com, Dynamic Charts.
dvt at psu dot edu
...line chart with NA() values
12 month line chart, with some values being 0.
I am using an if statement that turns any 0 values to #N/A so they do
not show on the graph (which is what I want).
My problem arises when the 0 values fall in the middle of my data.
So for example:
1) data for all months (Jan-Dec), the line shows across all 12
2) I have data for only 6 months (Jul-Dec), the line starts in Jul and
ends in Dec (perfect);
3) When I have data from Jan-Mar, and Oct-Dec, the line connects
between Mar and Oct. I want 2 distinct lines with no line where there
is no data (#N/A).
gri...Multivalue with Null value SSRS 2005
I have a query to populate a multivalue parameter:
SELECT distinct cast(AGRPYear.value as varchar(4)) + AGRPMonth.value
FROM TPROJECT AS TPROJECT
One of the values that is returned from this query is NULL. However, when I
run the report, the NULL value does not show in the dropdown. I've also
"select NULL as 'ReportDate' union" to the above query and the null value
still doesn't show.
As a result some of the records in my database have a null value for this
field, they will never show up on my report. Any id...Updating Credit Card Information
I have been trying counless times to update my credit card information from
several Banks, but Money states that the system is unaavaible or the
transaction cannot be completed at this time. What can I do to correct this
On 2005-03-23, Lou <Lou@discussions.microsoft.com> wrote:
> I have been trying counless times to update my credit card information from
> several Banks, but Money states that the system is unaavaible or the
> transaction cannot be completed at this time. What can I do to correct this
Well it depends on how long you've been tr...cursor missing from form textboxes
I believe that I know 98% of the little intricacies of Publisher, but I'm
stumped on this one. I created a website with a contact page and none of the
standard textboxes will show a cursor to indicate with field you are in (I've
even made the site live to double check). If you tab between textboxes, the
tabbing works, as does typing, there is just no visual cursor to indicate
where you are. If you click on the first textbox and type, all is good you
can tab to the next box and type, and it's fine. I'd like to have the visual
cursor show and can't get it. I also have ...VBA form
Im using a form/macro that i linked to through another thread and a
tailoring it to my needs. I basically have it doing what i need but
cant get a button to do what i want. When the user starts the macro i
brings up the form with a message and 2 buttons (Continue/Cancel). Whe
continue is pressed i want the message on the form to change to aniothe
message and so on until all messages are shown. Ive attacehed what i
working on and apprecaite any help offered.
|Filename: Excel.zip ...how to automatically update inventory list with sales
Please provide the help on how to update the inventory list when some items are
Do you want to check this out while you wait for an answer?
"lalani" <email@example.com> wrote in message
> Please provide the help on how to update the inventory list when some
The page that Epinn points out is probably as good as any. Excel is a rather
poor tool for trying to track inventory. You'll notice that the actual...how to run onhand value report
I get the message enter parameter when entering the zoom feature
On Sat, 6 Mar 2010 17:36:01 -0800, junebugg
>I get the message enter parameter when entering the zoom feature
You'll have to give us some more context than that, junebugg. What's the
"onhand value report"? What's the "zoom feature"?
You can see your database; we cannot!
John W. Vinson [MVP]
...Money Updates #2
Was wondering about money updates. What exactly is the program downloading
during the update process? And if the program is updated on a daily basis,
why would I ever need to upgrade to a newer version?
In microsoft.public.money, invalid wrote:
>Was wondering about money updates. What exactly is the program downloading
>during the update process? And if the program is updated on a daily basis,
>why would I ever need to upgrade to a newer version?
It is mainly changes in online bank setup.
Despite appearances is typically does not change anywhere daily.
"invalid" <...Increasing and decreasing values
Using column chart type I want to display increasing values and then
decreasing values (not negative). For example 10,20,25 top value 55, then I
want to show from 55 decrasing amount 10,35,10 (back to 0 starting point). Is
Put the numbers into the worksheet. A row or a column, whatever you like. If each
number has a corresponding category label, put them in the row or column before the
data. Select the data (one or two rows/columns), and run the Chart Wizard (the icon
like a column chart, or Insert menu > Chart). Choose the Column chart type, and
click through the rest o...Formula to count the number of different values in a range
I'm looking for a formula that will give me the number of different values
in a range.
Example: Column A may have five cells that are "4", five cells that are
"7", five cells that are "9". Of the fifteen cells that contain data, there
are only 3 different values. I'd like to use a formula that will count the
number of different values in column A, in this case the result is "3".
=SUM(IF(A1:A15<>"",1/COUNTIF(A1:A...Textbox fomatting value based on another textbox
I have two text boxes on a form. One is a value that can be changed by the
user. The second is the value 1 - textbox1. I need everthing to be in %.
For example, in textbox1 the user could type 75 and it would automatically
be recognized as 75% and textbox2's value would calculate to be 25%.
Everytime I try textbox1's value is = to say 7500%. Any help is
Maybe something like:
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim TB1Val As Double
If IsNumeric(.Value) Then
TB1Va...Excel 2007 Line Chart
Is it possible to configure a line chart in Excel 2007 to ignore the
intervals and graph straight to the next value. For example if I have
Jan with the value 1000
Feb with the value 900
March with the value 500
April with the value 0
May with the value 0
June with the value 0
I want the March value to drop directly from 500 to 0 ignoring the
interval to April, I do not want a curved line it must drop directly
to zero then the line is straight across to April.
I have no idea if this is possible, any ideas?
On Tue, 11 Oct 2011 15:40:45 -0700 (PDT), TyreDu...Scroll Wheel effecting a form
Is there any way to keep a mouse scroll wheel from having an effect on a
This is a single form for data entry and if are part way thru the form and
for what ever reasom use the scroll wheel all the fields on the form are
effected (they dissapear - like going to the next new record).
My suggestion to get a mouse without a scrool wheel was not met with
Any help here will be appreciated.
Thanks in advance
The scroll wheel is moving you through the records. Nothing except your
view of the records is disappearing. The records are still there. I
wouldn't think y...