How to Access description of a Form object
I need some help in VBA coding..
I have an application in which my backend data is stored in SQL Server 2005 .
Front end has been written in MS-Access 2002, so it is obvious that the front
end is an Access Database which contains forms, reports and queries.
My current task at hand: There are forms and sub-forms in the front end
database. Only the form objects and report objects have "description" on
them apart from the "form.Name".
I need to write the code snippet to read the front-end database and display
the form and report Descriptions of only those object...why is outlook trying to open an executable file in locate link brower? #2
"Kyle Harmon" <email@example.com> wrote in message news:...
> In my MS Outlook 2002, every time I click on an url with-in my e-mail
> outlook trys to open an executable file in the "Locate link brower". And
> this only happens when I do not have a browers open. Is there a fix for
> Thank You,
> Kyle Harmon
Navigate to your default browser's executible (iexplore.exe for Internet
Explorer) and double click on it.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion in...delay sending out all emails outlook 2003
How do I permanently delay sending out all emails for 2 minutes if I
realize there is an error or I forgot an attachment?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Cente...Linked OLE Objects
I have about 400 - 500 linked embeded objects (this includes Word docs, Excel
spreads, and many Adobe Documents). It's a rather large database in size and
its hitting the limitations that Access 2007 has, (i think) which is two gig.
I was worried the many memo fields and/or database design with indexes was
making it much bigger than it needed to be but, I think it's the linked docs.
I had the users of the database right-click in the table to make sure all
447 docs are "LINKED". and they are. They deleted any embedded docs so we
have only linked docs. To prove a...Make active contract/contractdetails fields read/write
By default MS CRM makes invoice/Active Contract and it's Contract Lines
Is there a way to make some of Contract Lines/contractdetail fields
read-write again ?
...HELP files not showing
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: imap
Previously, I got help from the Help menu, Entourage Help. Now, all I get is so-called online help, which gives a bunch of tutorials and such. <br><br>Where did it go? <br><br>Specifically, I am trying to find out how to view a reply that I just sent to a certain message. There is a reply notation at the top of the message display but it doesn't do anything when I click on it.
On 4/24/10 7:08 PM, firstname.lastname@example.org wrote:
> Specifically, I am...no warning file in use
Hi. I've got a question about a shared Excel file stored on Windows 2000
server. This file is accessed by two different Windows XP end users running
Excel 2002 on their machines. Recently these two different end users have
been accessing the same shared Excel file simultaneously without the usual
file lock or warning that the file is in use. Sometimes they get the
warning, sometimes not. When they don't, they assume they have rights to
save to the file, only to find later on that their changes were not saved.
I'm having both check for updates so that their Microsoft s...Sending large mails very slow
A friend of my works with Outlook 2003 (not Outlook Express) on a HP
desktop pc with XP SP2 installed. When he sends a large email, it takes
a lot of time before the mail was send. For example: it takes 2 minutes
to send a mail of 2 MB, about 6 minutes to send a mail of 6 MB... On a
second computer, he does not have that problem.
The mailbox (pst-file) is about 476 MB. He uses ZoneAlarm en AVG
Grisoft but we turned off those with no results. Also with an new,
empty pst file, the system remains slow...
Reinstalling Outlook isn't a solution (try that too)...
Has anybody ideas?
Si...Workflow for birthday reminder/email sending
I know one can search upcoming contacts birthdays by adding the month to
form. But how can i automate it using workflow to send reminders/emails?
I have code to send emails progamtically from a module in Excel 2000 using OUtlook 2000, but now I need to have the code select 1 of 5 different email addresses and potentially a different mail server. Any ideas?
Set NewMail = CreateObject("Outlook.Application")
Set objmail = NewMail.CreateItem(olMailItem)
.To = Email
.Subject = "Quotes for " & Name
.Body = emailtext
Set NewMail = Nothing
Set objmail = Nothing
Submitted...Converting access tables to XML for use in .NET web app
I need to access tables in an .mdb file and convert them to XML for use in my
..NET 2.0 web application.
Can anyone point me to any tutorials or references on how to accomplish
this? (Note: I am using VB)
...How do I link data from two different excell files?
I have two excell spreadsheets that need to be matched up and merge a certain
field. Is there a statement that wou
> I have two excell spreadsheets that need to be matched up and merge a certain
> field. Is there a statement that wou
...Searching multiple excel documents
When searching for P.O. numbers in windows 2000 basic
search command I enter the *.xls in the files or folders
field, and i enter the P.O. number in the Containing text
field but no xls documents show up.
i've selected to search through all subdirectories and am
positive the P.O. number is in a xls document, as i've cut
and pasted it to test this.
I've tried doing alpha numeric searches that are withing
xls documents and this returns nothing aswell.
doing a pure text search in all documents does return
positive, so my search funtion does work for containting
does wind...Larger backup file
Why is the backup file larger than the original .mny file.
I can see them being the same size, if not using
compression, but actually being about 30% larger is a big
difference. Does anyone know the answer for this? Thanks
Not for me it isn't. Money file is 10mb and backup is 2mb.
Microsoft MVP - Money
"Perry" <email@example.com> wrote in message
> Why is the backu...Possible to open word documents in Excel using hyperlinks?
I wondered whether it was possible to open office documents from within MS
Excel using hyperlinks to the related files. The documents in question are MS
Have you try it ?
Existing file ......
Regards Ron de Bruin
"DobieM" <DobieM@discussions.microsoft.com> wrote in message news:2DFD72F1-0F21-4414-929D-4D9307997D68@microsoft.com...
> I wondered whether it was possible to open office documents from within MS
> Excel using hyperlinks to the related files. The documents in question are MS
> Wor...Importing QIF files in Money 2004 produces duplicate transactions
Hi. After importing all my accounts into Money 2004 from QIF files, trnasfers
between accounts generate duplicated records in related accounts.
How to fix this problem?
In microsoft.public.money, Adrian Guinsburg wrote:
>Hi. After importing all my accounts into Money 2004 from QIF files, trnasfers
>between accounts generate duplicated records in related accounts.
>How to fix this problem?
Restore your file to the way it was before import. Then import
This time import all QIF files at once using Ctrl+<click> to select
the QIF files. During the File->Import process...Can receive but can't send emails on Windows Mail
An unknown error has occurred. Subject 'good site for random camping sales',
Account: 'Rowena', Server: 'smtp.slingshot.co.nz', Protocol: SMTP, Server
Response: '421 Cannot connect to SMTP server 188.8.131.52
(184.108.40.206:25), connect error 10060', Port: 25, Secure(SSL): No, Server
Error: 421, Error Number: 0x800CCC67
This is the error message I get when I try to send emails. Up until a couple
of days ago I have been able so send emails fine but now it has stopped
working. Any idea of how I can fix this and send emails again?
This...Send automatic reply through specific account
I have setup my Outlook 2002 to work with 3 different email accounts.
I also have rules to send automatic replies for 2 of those accounts.
However, the problem is, the SMTP servers of the 2 accounts through
which the auto replies are routed allow only 1 outgoing message per
day. The third account (being a hotmail account) does not work with
the rules wizard. So, can somebody out there tell me how Outlook can
be set up such that all outgoing messages are routed through the third
(hotmail) account (because hotmail seems to have no such limit)?
Thanks in advance.
you'll need to find a SMTP t...how do I omit a duplicate field in a merged document?
I want to merge a list from Excel to a Mail Merge in Word. It works, but
there are fields that are duplicates in Excel that I do not want in Word.
For example, Mr. Smith has two lines of information in Excel which generages
two letters in Word. Is there a way to eliminate this?
You could add a column in which you count the occurrences of each entry.
For example, if you have a customer number in column A, enter the
following formula in row 2, and copy down to the last row of data:
When merging in Word, filter this column for rows with a 1.
> ...Stop opening multiple versions of Excel when click on xls files
Excel 2002 SP3
Win XP HE
If I click on an xls file in Windows Explorer, it properly starts Excel
and opens the file.
However, if I need another file opened, and click on another xls file
within Windows Explorer, instead of opening the file only, it starts up
a new instance of Excel.
So I can find myself with 3 or 4 (or more) instances of Excel running
simultaneously. It's not a huge problem but I believe not necessary and
would like to see if I can find a way of only opening the file in
question once Excel is already opened, etc.
On Jun 28, 2:55 pm, ste...Reading unicode keys from keyboard
In our application we need to read the unicode keypresses as we support
The Form keypress event does not return unicode keycodes.
Is there any way of reading the last pressed key ? For example using API ?
Then we could put this code in the For Keypress event, and find the correct
We using this to output the correct unicode letters using 3rd party
David De Bono submitted this idea :
> In our application we need to read the unicode keypresses as we support
> multiple languages.
&...POP Marked Messages as read
Setup: Server 2003 with Exchange 2003
Client: Outlook 2003 (Exchange cached mode) and Snappermail (POP) on Treo 650
When the user pPps his email before he checks his messages in Outlook they
show up in Outlook as Read messages. Is there a way to configure when the
messages arrive they are marked as Unread?
On Thu, 22 Jun 2006 17:58:01 -0700, Jeff
>Setup: Server 2003 with Exchange 2003
>Client: Outlook 2003 (Exchange cached mode) and Snappermail (POP) on Treo 650
>When the user pPps his email before he checks his messages in ...accessing XML data
I need to import data from XML to Access97 , what is the best way???
Is there any ODBC solution??
This was written with Access 2000 in view, but the idea should work. Check out
the article at DBJ.
Danny J. Lesandrini
"Domac" <firstname.lastname@example.org> wrote ...
> I need to import data from XML to Access97 , what is the best way???
> Is there any ODBC solution??
...Sending xls files to pc xlsx users
Operating System: Mac OS X 10.5 (Leopard)
My xls files are opening on my associates pc Office 2007 machines as a blue screen (shows toolbars, though). <br><br>Whats' missing?
...Find the depth of XML
I have following XML:
How can I find the depth of XML?
in other word max level of the XML
<Root> ----- level 0
<Name>----- level 1
<FirstName>name</FirstName> ---- level 2
<Info2> --- level 3
<Info3>asdasd</Info> -- level 4
Raed Sawalha wrote:
> I have following XML:...