Synchronise Outlook 2003
I am using outlook 2003 on a laptop. I would like to sync my changes with my
assistant outlook 2003 when I get back to the office. Is it possible to sync
I do not want to use a central data base but really sync 2 different data
phil <firstname.lastname@example.org> wrote:
> I am using outlook 2003 on a laptop. I would like to sync my changes
> with my assistant outlook 2003 when I get back to the office. Is it
> possible to sync contacts ?
> I do not want to use a central data base but really sync 2 different
> data bases.
http://www.slipstick.com/outlook/...VBA code to say Yes or No if any VBA code is present in ActiveWork
Using XL 2003 & 97
Would like hit Ctrl+Shift+V and have an answer either yes or no as to the
presence of Any VBA code in the Active Workbook.
I do know that about the VBA editor/Explorer or to press the Run Macro
button and get a list from various sources .
I would like to stay at the keyboard and process a series of macros
including one to let me know if I even need to evoke the VBA explorer.
There is no bootstrap macro to tell you whether you have macros
or not. If there were there would be no limit to virus writers.
David McRitchie, Microsoft MVP - Excel ...Hyperlinks that I recieve in e-mails don't work in outlook 2003
LMT <LMT@discussions.microsoft.com> wrote:
Ask your question in the body of the message, not the subject.
If you're using Internet Explorer, try this: click Tools>Internet
Options>Programs>Reset Web Settings
"Brian Tillman" wrote
Thanks Brian worked great.
> LMT <LMT@discussions.microsoft.com> wrote:
> Ask your question in the body of the message, not the subject.
> If you're using Internet Explorer, try this: click Tools>Internet
> Options>...Print, Merged Cells, and VBA
I'm looking for a code that will help me with a print job
for a worksheet. There are a lot of merged cells and a
lot of "IF"s to be used in the VBA for range selection.
Thanks in advance,
...Prevent Task Publishing in Server 2003
We are running Project Server 2003 using Managed Time Periods. We're trying
to simplify our time tracking requirements by only publishing certain tasks
to PWA while keeping most of the tasks unpublished.
We'd like to use Enterprise Resources for all of the tasks so our resource
forecast information is accuarate. In other words, we don't want to use
local resources for the "planning" tasks and enterprise resources for the
"time tracking" tasks.
Is there any practical way to prevent certain tasks from being automatically
republished when our...Use VBA to update Access table or Query from Excel
Can I use VBA to update Access table or Query from Excel?
Thanks in advance
> Can I use VBA to update Access table or Query from Excel?
Of course, using ADO or DAO.
Jan Karel Pieterse
Thanks. I think ADO is what I want.
But I am not only want to export from excel to access.
I want to edit some data in access table.
For example, Access has a table "ProductList"
I want to use Excel to call the product by "Pro...Outlook 2003 drops signature settings after update
We have 3 machines out of 20 that drop the settings made to
Signatures/default signature for new messages/default signature for replies
and forwards whenever an Office update (probably a junk mail filter update)
is installed. Any idea what causes this behavior?
...Access 2007 closes without updating recordsource
If I change the recordsource for a form using the query design grid in
Access 2007, and then click on the top "X" to immediately attempt to close
Access, a popup asks if I wish to save the changes to the recordset. If I
select "Yes", the pop-up closes, and Access itself closes, but the changes
in the recordsource are not saved.
If I change the recordsoure, then close the query design window, clicking
"Yes" to accept the changes to the recordsource, I return to the design view
of the form. If I then click to immediately attempt to close Access, t...VBA and Scheduled task in Outlook
Hi, how can I:
a) pull the query from somewhere and send it by e-mail automatically. E.g. I
want to take a temperature table from
where 2009/7/10 is the date of yesterday put it into an e-mail and send it
automatically each day at 8 o'clock?
b) if this is not possible, how can I send an e-mail with the attachment
c:\Documents\query20090710.xls each day at 8 o'clock?
my boss wants this automatized, I know how to write the VBA code for Excel,
but don'...ComboBox DropDown Size: Design vs Run Time?
I was wondering, what's the reason for specifying the dropdown size of a
combobox at design time?
I'd say it's better to make the size as large as possible to display as
much rows (and columns) without falling of the screen.
Olaf van der Spek wrote:
> I was wondering, what's the reason for specifying the dropdown size of a
> combobox at design time?
> I'd say it's better to make the size as large as possible to display as
> much rows (and columns) without falling of the screen.
Sounds reasonable. Are you having some kind of issue wit...GAL access
Anyone have a Q article or something describing how Outlook clients get the
GAL in Windows 2003? Or even 2000?
When you open Outlook w/ a profile configured for your Exchange server the
GAL isn't visible? Please be more specific.
"TwistedPair" <email@example.com> wrote in message
> Anyone have a Q article or something describing how Outlook clients get
> GAL in Windows 2003? Or even 2000?
...2007 search not working with Vista with new profile
It stopped working after I deleted my mail profile and started from scratch
again. Who would have guessed doing that would break the search feature? I
thought maybe it was indexing, but this is even after indexing has finished.
Take any word from any subject line in any message and put that same word
into the search box and it doesn't find the message.
Using Vista with Outlook 2007 with Exchange 2003.
Also the desktop search no longer looks inside my emails.
Is there a cheat to make Outlook 2007 use the old simple search feature we
love/hate from Outlook 2003 and befor...JTDS support for shared memory access
Can anyone tell me if JTDS supports shared memory access?
I would like to access the DB with TCP and Named Pipe DISABLED
Appreciate your replies. Thanks!
Posted via DevelopmentNow.com Groups
On 2010-03-12 2:48, xbluewho wrote:
> Can anyone tell me if JTDS supports shared memory access?
No, it doesn't.
> I would like to access the DB with TCP and Named Pipe DISABLED
Then you're out of luck. jTDS requires at least one of those.
...MS Access and Sql Server
I am new to SQL server and am having some problems with Access and
connecting to it. I have read so many articles but have found not one
that spells it out in pure english! Hoping someone can help?
OK, I just built a new machine, bought all sorts of software, and now
I am ready to go. I have previously been just using MS Access 2003 /
2007 but now I want to store my tables and quarys in SQL Server. I
have SQL server 2008 and 2005, I also have visual studio 2008 along
with my MS access 2003 / 2007. So far I cannot get a file to connect
to my SQL Server. How on earth does o...References
Hi, I am the account manager for National Accounts for Payables and I just
want you to know that we will supply you with references and case studies so
that you can feel confident in your decision to move forward with our
Call me with any questions.
Binary Stream Software
T. (604) 522-6300 x 113
F. (866) 834-7622
...Exchange 2000/2003 Routing Problems
I recently added a new Exchange 2003 server to our 1 server Exchange 2000
org. I am able to send mail from the new Exchange 2003 server to the 2000
server. But when I send to the 2003 server the mail does not go delivered.
I am assuming this is a routing issue. How can I troubleshoot this? Should
each server be in a seperate routing group and use a routing group
connector? They are currently i n the same routing group.
In case anyone has this problem my STMP connector was setup to use a smart
relay. I had to check the box that said attempt local delivery before using...vba select field
having a button on a form, is it possible to select only some fields
(all from the same table) of the current record instead of all fields?
I've tried this code:
Forse dipende dei dati nel record.
but it selects ALL fields in the form.
On 10.04.2010 18:01, remigio wrote:
> having a button on a form, is it possible to select only some fields
> (all from the same table) of the current record instead of all fields?
> I've tried this code:
> RunCommand acCmdSelectRecord
&...reference to closed workbook
the INDIRECT formula will not pull values from a closed workbook, wha
is a solution to this?
I am trying to reference a cell in a closed workbook on a sheet tha
has the same name as the active sheet, so I want to be able to us
MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) in the referenc
to the other workbook...
Message posted from http://www.ExcelForum.com
> INDIRECT formula will not pull values from a closed workbook, what
> is a solution to this?
> I am trying to reference a cell in a closed wor...VLOOKUP in VBA
On the worksheet I can insert in a cell
=VLOOKUP(C5, Hobokee.xls!AcsLow, 2)
and it works perfectly, looks up the value in column 2 of the range named
AcsLow in the same workbook.
But elswhere I want in a macro to lookup the same table and assign the
result to a variable BalAmt.
BalAmt = VLOOKUP(AccNum, Hobokee.xls!AcsLow, 2) does not work.
It gives a function not defined error on Hobokee. If instead of Hobokee I
put Workbooks("Hobokee"), it gives function not defined error for VLOOKUP
which it changes to VLookup.
I have been overVLOOKUP in the Help file and see nothing wrong.
W...Outlook 2003 and Activesync
I installed Outlook 2003 and had 3.7.1 Activesync
installed but now when I sync my calander, etc. I get an
error stating Outlook is no longer installed. I have
reinstalled, rebooted, etc and nothing works. Any
...Excel VBA/Macro programming for beginners
I know a bit VB 6.0 programming. Will it help me to write exce
vba/macro(same thing?).can anybody help me by providing some fre
websites where i can have informations/codes for VBA/macro.
Please tell me how could i make a *command Button * in a cell in th
sdebu_2000's Profile: http://www.officehelp.in/member.php?userid=430
View this thread: http://www.officehelp.in/showthread.php?t=118812
Posted from - http://www.officehelp.i
Try David McRitchie's "getting started with mac...Turn pc speaker on/off with vba code
Is this possible?
I found something here on how to do it withVBScript. You can probably modify
it to work in VBA
> Is this possible?
I'll have a go
(I need to improve my web searching skills)
"Barb Reinhardt" wrote:
> I found something here on how to do it withVBScript. You can probably modify
> it to work in VBA
> ...Loading a Form from VBA
Hi all, I'd like a module to open and load a form in my Access 2003
database... How can I do this?
Use the OpenForm method. Look in the Help file for details.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Mike" <firstname.lastname@example.org> wrote in message
> Hi all, I'd like a module to open and load a form in my Access 2003
> database... How can I do this?
On Jul 18, 10:58 am, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com&g...Outlook 2003 RPC over HTTP everywhere disadvantages
what are the disadvantages of configuring Outlook 2003 RPC over HTTP in
everywhere either lan/wan access?
if outlook is configured in Outlook 2003 RPC over HTTP internally does it
access internet to access email or the name is resolved and accessed
I think RPC over HTTP is great for external access, but I would not
recommend running it when inside your corporate LAN, for a start I find it a
bit slower than using the traditional TCP/IP connection method, You also
need to type your username password in even if you are already logged on to
...Excel and VBA
I am very interested in learning more about using VBA in office, especially
Excel. Can you post some resources (online, books, etc) that can be used to
help learn about using Visual Basic in office.
Here's a good place to start:
Does that help?
"Bob Sinclair" wrote:
> I am very interested in learning more about using VBA in office, especially
> Excel. Can you post some resources (online, books, etc) that can be used to
> help learn about using Visual Basic in office.