Operating System: Mac OS X 10.5 (Leopard)
Email Client: Exchange
Hi I have a script to open entourage to configure a account, although the first time round for every user the script stops due to the message in Entourage asking would you like to make entourage you default browser. <br>
Anyone have a script to set this to default or any way of setting this so it never ask's ? <br><br>thanks
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=iso-8859-1; format=flowed
C...Requery a Sub Form!
On [frmMain] I have a sub form [subRemindTog] which has a text box
From another form how do I requery this subform??
Thanks for any help..........Bob
It would be so: Forms![frmMain]!Forms![subRemindTog].Requery
Or you can call to class module representing your subform. If you have any
code in subform then your VBA project exactly has form module
Form_subRemindTog. So, you can do this: Form_subRemindTog.Requery
Note that sometimes you may be needed to use both .Requery and .Repaint
"Bob V" <email@example.com> �������/�������� � �������� ���������:
n...Making a Pivot chart from 3 differnt sets of data / worksheets.
Hi, I have 2 workshsheets of data with a list of delivery dates of about 10
different products over the last 3 years, (i cant combine these to just 1
worksheet for other separate reasons) and a 3rd worksheet with a column of
the same products and dates that some of these products became faulty and
were sent back to me .
On a 4th worksheet, I am trying to do a graph that looks at the 3
worksheets and plots pivot table of dates and amount of each product
deliveries & returned to me. So as i select ,say, product A from that pivot
list, it produces a graph for these 3 variables (dat...Customize forms
Is there a way to add different columns to my OWA tasks folder? I would
especially like to do this in my tasks folder in my public folders.
Outlook Web Access is only a web VIEW of your Exchange mailbox. I don't
know if customizing the default Exchange Mail Task item to show your custom
view if it would translate to the web view - I presume not.
Double check by asking in an Exchange group since Outlook Web Access,
despite its name, is a part of Exchange, not Outlook.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Du...Record UserID in form
I'm using Access 2007. I've read various posts on capturing the userid. I
have a form where the user is supposed to enter their name so we know who
created a particular record. (I'm interested in who created the record, not
if anyone modified it afterwards). Needless to say, they don't always
complete this field. I'd like to capture it automatically based on their
I created a new module for the fOSUserName function I found on one of the
postings on this forum. I named the module basUserName.
Then I created a text field called UserID on my...making a transfer show up in the budget
I am running MS money 2006. How do I make a transfer show up in my budget?
I have several liabilities and credit cards, and I would like to make a
budget with the monthly amount owed to each creditor showing up in my
budget. The MS Money 2006 standard program does not allow me, as far as I
can tell, to make a monthly transfer to a credit card or liability show up
in my budget, unless I make it a category. Any help with this is much
See http://umpmfaq.info/faqdb.php?q=124 for the short answer. You may be
more interested in "cash flow" than &qu...Access 2007 Form
I have short form with following controls:
I would like to transfer the value of Remaining balance control to the next
record’s Invoice amount control when I am adding new data. Two conditions
should be true. First, the customer ID in the new record should matches the
customer ID in previous record and second the value of Remaining balance in
previous record should be greater than zero.
You need a field, DateTime would do, so that Access knows which record comes ...What is the Outlook keyboard shortcut for checking new mail
"Steve Jaeger" <Sjaeger1@elp.rr.com> wrote in message
If there is a coded shortcut for a menu item, you will see it on the
rightside of the menu. If you open Tools -> Send/Receive ->
Send/Receive All, you will see F9 listed on the right.
Also, it is considered impolite to use only the Subject line to carry
the body of your message.
** Share with others. Post replies in the newsgroup.
** If present, remove all "-nix" from my email address.
_________...analysis for new bank branch proposal
I have been given to make a proposal for new bank branch .But since I never
have done this before I need some help
Good luck with your proposal but I think you may have posted to the wrong
place. This area is to discuss the microsoft programme called Access. Sorry.
> Dear all
> I have been given to make a proposal for new bank branch .But since I never
> have done this before I need some help
what is the best way to make numbered tickets using
Hi lc (firstname.lastname@example.org),
in the Microsoft Office Publisher newsgroup
|| what is the best way to make numbered tickets using
|| Publisher 2002?
Check out the following link:
Microsoft Office Publisher MVP
Official Publisher MVP Site:
This posting is provided "AS IS" with no warranties, and
confers no rights.
>what is the best way to make numbered tickets using
>Publi...variable for current owner? (want to use to create new "My" view)
I want to create a new view which is just like "My Active Contacts" but with
an additional filter criteria. I want the results to vary by user. So
instead of creating separate views for each user (Tom's Active Contacts in
MA), it would change itself per user and the new view would be "My Active
Contacts in MA". The results would be all active contacts in MA who are
owned by the current user.
How do I specify to use the current user in the Filter criteria?
All help much appreciated!
In the View editing window (Settings > System Customization > Con...subforms from an unbound form
I have an unbound form with two subforms : SbFrm1 and SbFrm2.
These two subforms are bound forms, so have their own recordset, e.g. :
“select * from tblTable1” - recordset for SbFrm1
“select * from tblTable2” - recordset for SbFrm2
On my main form I have a combobox CboBox; CboBox.column(0) contains the
value I want to use to filter the recordset of both subforms, strKey.
I do not think I can set a parent-child relation between the main form and
But then I do not know neither how to limit the records of these forms to
only show these records where strKey...How make a favorite for all users in Ex2007/OWA/Documents area?
I am playing around with OWA in 2007 and exploring the "documents" feature of
OWA that allows users to view Windows file shares by UNC.
There is the individual "add to favories" option, but does anyone know of a
way to administratively specify a favorite for all users? The alternative
seems to be logon as each user to setup the same favorite--surely that is not
the only way?
Thanks for any help!
...Refresh a form when closing another form
I apologize if this is posted somewhere already, I looked and didn't see
anything that exactly matched.
I have created a form which serves as a record selection screen to allow a
user to edit certain values.
Once the user highlights a particular row, they click on a "Edit Record"
button. This takes them to a second form which allows them to edit certain
When the user has made the changes, they click on a "Save & Close" button
which returns them to the record selection form.
I wish to refresh the record selection form, when the "edit re...AN OPPORTUNITY TO MAKE $$$
THIS REALLY WORKS IF YOU FOLLOW THROUGH!!!
MAKE MONEY!!! MAKE MONEY!!!
MAKE THOUSANDS OF "$$$" !!!
I found this "NETWORKING PROJECT" on a bulletin board and decided to
All I say is, it "WORKS".
All it takes is a small INVESTMENT of your "TIME" AND "less than
INTERESTED??? E-mail: "email@example.com" for DETAILS.
...closing a form that uses a Dlookup
I have a form I use to enter new production requirements in to a
table. On that form I have a the following controls
The Code control has the following VBA on the On Exit event:
Private Sub fldcode_Exit(Cancel As Integer)
Dim varrtgno As String
Dim vardays As Double
Dim varfstop As Date
Dim varplandate As Date
varrtgno = DLookup("[rtg_no]", "dbo_imitmidx_sql", "[item_no]='" &
[Forms]![frm enter fillroom requirements]![fldcode] & "'")
'Me!rtgno = varrtgno
Select Case varrtgno
' some cas...Move exchange 2003 to new hardware
I have exchange 2003 ent on windows 2000 machine , i would like to move to
another machine with windows 2003 as OS. Can anyone help !!!!!!!!
- Install new server in the Exchange Org - this will be installed in the
same Administrative Group by default.
- Move mailboxes, replicate public folders
- Follow http://support.microsoft.com/default.aspx?scid=kb;en-us;822931
- Shut down Exchange services on old server for a couple of days
- If all looks good, uninstall Exchange from the old server
----------------------...Conditional Formating Excel Form
I have a Form in excel which lets people enter monitoring information
It has the fields Target, Reported and Difference. The Target field i
pre-set, they have to enter the Reported field and the Difference fiel
is a calculated field based on Targeted - Reported.
If this difference is more than 10% or less than -10% I would like i
A. To change the font colour in the Difference text box red.
B. The form to open another text box (called reason) - so that they ca
explain the difference.
Any help would be much appreciated
I c...Bar Graph on Form (rectangle control code)
This website gives a good description of how to use a small amount of coding
to have a rectangle controlled by a field value on a report appear as a bar
graph when you print preview. I would like to do something very similar,
show a bar graph within a form based on a field's percentage (between 0 and
1). In the example they put the code into the OnFormat event property. I
would like my bar graphs to appear upon opening the form. Hope that I can
use very similar code as in the example but what would I put it in... OnLoad...how do you make all incoming emails bold?
"Beth" <Beth@discussions.microsoft.com> wrote in message
I could've sworn there was a message here, but when I looked the body was
completely blank. Oh well, guess the poster really didn't want to ask a
how do you make all incoming emails bold?
"Vanguard (NPI)" wrote:
> "Beth" <Beth@discussions.microsoft.com> wrote in message
> I could've sworn there was a messag...How do I make the X-Axis increase in scale with the quantity?
For example: If I have the values 1.5, 3.5, 8.7, 9.9 in the x values for a
line graph, is there anyway to make them spaced apart so that they are in
scale with eachother... Like so the distance between 3.5 and 8.7 is larger
than, the distance between 1.5 and 3.5?
Create a XY Scatter chart. It, and a bubble chart, are the only 2 that
allow for cardinals values on the x axis.
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <F2D3DC58-86D3-4D21-9D57-F704A78941FB@microsoft.com>, =?Utf-
8...Controls in forms
How do I add a control button that will open another form in "add" mode
rather than edit?
On Thu, 7 Jan 2010 10:00:22 -0800, Bill wrote:
> How do I add a control button that will open another form in "add" mode
> rather than edit?
Set the Click event of the command button to:
DoCmd.OpenForm "FormName", , , , acFormAdd
Please respond only to this newsgroup.
I do not reply to personal e-mail
All it did was come up with a message that it couldn't find the object 'DoCmd'
> On Thu, 7 Jan ...Excel 2007 Form errors in calculations
I created a form in Excel 2007 that uses calculations. The
calculations in the form work great on my home computer (WINDOWS 7,
Excel 2007), BUT the calculations do not calculate at work using the
same file. At work we have Excel 2007 and XP on a network. I've
tried it on one of my co-worker's computer, no luck. I sent the same
file to a friend who uses XP and Excel 2003 and it works just fine.
What could it possibly be wrong??
...Form does not display the same on two different PC's
I have a form set to display a blank record when it opens. This works on all
the PC's except one. Is there something in the set up of Access on that PC
that would affect this?
What does the form show that is different on this computer?
Is the database split with each user having a copy of the front end?
Any other differences between the computers such as version of Access?
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> I have a form set to display a blank record when it opens. This works on a...How to make VLOOKUP work for this
I have a "master" spreadsheet where column A is a time column and every row
represents a second (in plain text format) such as 00:00, 00:01, 00:02....
00:59:, 01:00, 01:01, 01:02,... and continues on for 24 minutes... 23:59,
24:00. (1442 rows). Off to the side (I'm thinking of putting it on
another sheet though) I have a small table where I'll enter the time and
corresponding data I need populated in Column B, and will look something
like the following example;
My question(s) are, is the VLOOKUP function the best way to populate column
B with the values? It's ...